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 |
|
vzao
Starting Member
1 Post |
 Posted - 2005-08-17 : 17:08:17
|
| Hi,I am planning to set up the transaction log files on a separate disk drive than the database files. What will happen if the disk drive of the transaction log files failed? Also, How can I recovery the database when that happens?Thanks in advance for your reply. |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-17 : 17:33:14
|
| Your database will go suspect and will not be usable.Various ways to prepare for this.One way is to take daily full backups and regular (say 1/2 hourly) log backups. If the log drive fails, you lose no more than 1/2 work, plus the time to restore the backup and all the log backups.Another way it to have a standby server using log-shipping. Many books and web-sites (including msdn.microsoft.com) have advice for high-availability and disaster recovery.In SQL Server 2005, you can use database mirroring to have a fast fail-over system available.ThanksPaul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
Transaction Log disk drive failed