RMS 2.0 With MSDE Database Lost


J

Jamal

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

Advertisements

A

Akber Alwani

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 in RMS admin program,
remember the data file and log name remain the same. Then stop the SQL SErver
all services and then go to path where new data files are created as below
path: copied the old _Data and _Log files and override them now restart the
sql services see is everything recovered. I usually use this procedure and
worked. if work rate don't forget.
 
Ad

Advertisements

M

Mahmoud Amin

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'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top