RMS 2.0 With MSDE Database Lost

Sep 28, 2007 2 Replies
J

I am using MS RMS 2.0 with SQL MSDE 2005 with Windows XP Professional.



Couple of my windows file corrupted and windows was not starting correctely. I tried to repair it but I was unsuccessful. SO I have to reload windows on over the old windows.



When loading the new windows I can see the RMS files and SQL MSDE files in my C: drives. So I copy SQL data files C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to another folder.



Since all the old settings are replaced by new windows setup, So I have to install RMS and MSDE 2005 SQL server again.



I know how to backup and restore database. But we dont have the latest backup database, Its around 2-3 month old.



My old database name was zipps30 I can see the sonme database files under following folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data



zipps30_Data and zipps30_Log



When I go to RMS Administrator I cant See or connect to Database zipps30.



My question is how can I recover that database.



Vote
Twitter Facebook LinkedIn
A

hi Jamal, you said you have no backup however in the same instance you said that you have the Log and Data File. you can saved it anywhere in safe side now I tell you the procedure.

Create the fresh database with same path and name > I am using MS RMS 2.0 with SQL MSDE 2005 with Windows XP Professional. >

Vote
Twitter Facebook LinkedIn
M

assuming that you re-installed the rms system to the original file and you have database files in the same directory

run this query from RMS administrator utility

Use Master

GO

EXEC sp_attach_db @dbname = 'zipps30',

@filename1 = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\zipps30.mdf',

@filename2 = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\zipps30_log.ldf'

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required