Need restoration procedure

[dindu]

Hi,
Please give the retoration procedure:
I have a production server and I want test it on the other machine to check whether my backups are working or not?(Please give me step by step so that I can do easily)
Your answer will be highly appreciated.
Thanks,
dindu

[Ray Miao]

1. use domain account to start sql services on both servers.
2. run "restore database db_name from disk = '\pro_servershire_nameackup_file_name' with recovery" from query analyzer on backup server.


------------
dindu at 1/11/00 2:20:34 PM

Hi,
Please give the retoration procedure:
I have a production server and I want test it on the other machine to check whether my backups are working or not?(Please give me step by step so that I can do easily)
Your answer will be highly appreciated.
Thanks,
dindu