|
Posted by Akber Alwani on September 29, 2007, 5:56 am
Please log in for more thread options
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.
"Jamal" wrote:
> 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 FilesMicrosoft SQL
> ServerMSSQL.1MSSQLData 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 FilesMicrosoft SQL ServerMSSQL.1MSSQLData
>
> 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.
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap