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.