I have a client whos PC died and had was the RMS database server running SQL server express 2005. Assuming that the hard drive in intact, how can I restore the data to a replacement PC. The customer made NO backups. Help is very much appreciated.
Phil
Phil, If the hard drive is still good and will spin up. Just remove the .mdf and .ldf from the old hard drive to the new hard drive. Then from SQL Management Studio attach the .mdf file.
The default path is C:\Program Files\Microsoft SQL Server\MSSQL.1\Data\
Make sure you instruct your customer to start making backups and storing them on an external drive. I know SQL Server Express does not have the Agent to schedule backups but that doesnt mean you can create a batch file to run sqlcmd to backup the DB.
Dane
reet_83 had written this in response to
------------------------------------- =?Utf-8?B?UGhpbCBW?= wrote:
why don't you try Stellar Phoenix SQL Recovery Software to recover all SQL database.
##-----------------------------------------------## Newsgroup Access Courtesy
Have something to add? Share your thoughts — no account required.
Ask the community — no account required