RMS 2.0 With MSDE Database Lost

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.

Reply to
Jamal
Loading thread data ...

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. >

Reply to
Akber Alwani

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'

Reply to
Mahmoud Amin

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.