How to retrieve a database if the server had crashed?

• Sudarsan Srinivasan

  Ten Centuries

  Points: 1140

  More actions

  December 3, 2007 at 5:30 am

  #71192

  Hi All, I am need of your help.

  I have the below scenario and if somebody help me out on this regard, it would be helpful.

  We have a production server and a DR server between which there is double take running. Log files are created in the DR server every 15 minutes. Now lets say the production server has crashed at 3 PM and we need to restore the DR to Production as it was before the crash. i have the database backup as of previous day also. how do we apply the logs accumulated on DR till the crash on the restored backup and make it sync as at 3 PM.

• SQL_ABD

  SSCertifiable

  Points: 5832

  More actions

  December 5, 2007 at 4:34 am

  #757288

  Hi,

  Restore the full backup , then all transaction logs and that's it

  Check the following links

  http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

  Backing Up and Restoring SQL Server Databases and Transaction Logs

  http://www.databasejournal.com/features/mssql/article.php/2232371

  http://www.builderau.com.au/program/sqlserver/soa/Restore-your-SQL-Server-database-using-transaction-logs/0,339028455,339282046,00.htm

  Regards,

  Ahmed