Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2003-01-22 : 10:46:51
|
| I have SQL 7.0 on NT4.0 server with the following Configuration:Program Files on C: drive as well as the OS..Data Files on E: driveBackup files on D: driveFor Disaster, I would like to know the following:1) If I have a hardware failure of say E: drive. What do I need to do. I am thinking just replace the drive and restore from (D:)Backup files on the new E: drive.2) If I have a hardware failure on say C: drive. What needs to be done to bring up the server. I;m thinking build a new server and restore database from the old server. Does anyone have any suggestion, If so please let me know.thanks,Jay |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-01-22 : 11:18:28
|
| Are the data and log files on the same drive E: ?? You will want to reconsider this if they are. They should always be kept on separate drives from each other. Perhaps you are not using the log for anything ?? The problem you have with point (1) is if the drive goes at the end of the day (worst case) then you've only got the previous nights backup (i'm assuming you do it once a night - backup that is) so you'll lose the days work. with the logs available (if they were on a different drive) then you could restore the database and all additional log files to a precise moment in time thus not losing much if any work. You should back up the log file periodically throughout the day depending on the size of your database and hardware resources available ??2) yes you'll need to reinstall SQL Server et al but rather than restore the database you will be able to detach and reattach the database files.===========Paul |
 |
|
|
Jay1Jay
Yak Posting Veteran
50 Posts |
Posted - 2003-01-22 : 15:04:17
|
| So Paul, what you are saying is that if my log files are on a different drive as they are on the D: drive and the data files on the E: drive. I can just pop in a blank drive (E:) in case of a hardware failure to the original E: drive on to the existing SQL server and just restore the database and the logs from my backup D: and I'll be fine.Thanks, Jay |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-01-23 : 04:41:12
|
| hi JayYes that should do the trick nicely. This is exactly the reason for keeping the transaction logs on a different physical drive to the actual database file. You can happily restore to any point in time.Backup + transaction log(s) = easily restored databasehope that helps a bit===========Paul |
|
|
|
|
|
|
Disaster Recovery