SQL database recovery


P

Phil V

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
 
Ad

Advertisements

D

Dane

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\<yourfile.mdf>

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
 
Ad

Advertisements

R

reet_83

reet_83 had written this in response to
http://www.rockryno.com/point-of-sale/SQL-database-recovery-36650-.htm :


-------------------------------------
=?Utf-8?B?UGhpbCBW?= wrote:

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.

why don't you try Stellar Phoenix SQL Recovery Software to recover all SQL
database.



##-----------------------------------------------#
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Accounting Software Forum
Web and RSS access to your favorite newsgroup -
microsoft.public.pos - 37183 messages and counting
##-----------------------------------------------##
 

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

Similar Threads


Top