Best way to recover is to recover is get the OS back to where you want it,
reinstall SQL Server, restore the master database, restore your user
databases, roll forward the tran log backups of your user databases.

restoring the mdf and ldf files won't work because you can't really ensure
data integrity, unless you backup all the files at once while SQL Server
is not running.

Thanks,
Lisa Greetham
Database Administrator, Corporate Internet Group
Bank One




"Howard, John" <[Email Address Removed] 08:28 PM

To
"LazyDBA.com Discussion" <[Email Address Removed] Recovery procedures






If it were me it would hinge on what gets me the closest to last good
live environment. No matter what you do watch out for corruption if it
was a disk or raid controller that went bad.


-----Original Message-----
From: Trice Liz Contractor AFSVA/SVSN
[mailto:Liz.[Email Address Removed] Thursday, February 20, 2003 4:54 PM
To: LazyDBA.com Discussion
Subject: Recovery procedures

Does anyone have any written SQL database recovery procedures or know of
a
site I can refer to in the event of Hardware failure. Such is the case
if I
had to totally recover my sql database from a tape device.

I suppose my first step would be repair the hardware.
Reload all necessary operating sys applications after configuring
hardware
etc....
Reload sql
At this point I'm not sure if it's best to restore my mdf & ldf files
from
the tape backup or my bak files from my database backups?????

Thank you in advance for your help.


Elizabeth Trice
Air Force Services Agency
Dept: Network Operations Division







---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

MS Sql Server LazyDBA home page