Post reply

How to backup T-log when data base is down

  • January 5, 2003 at 6:35 am

    #105940

    I'm trying to simulate SQL Server 2000 failure and restore DB to the point of failure. In Books Online there is said that the first step is to create T-log backup. How can I backup T-log when DB *.mdf file is damaged (DB is suspected). All committed transactions are backed up in full or differential backup. It would be quite logic to restore all committed transactions from healthy log file but how? Pleas help me ...

  • January 8, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • January 8, 2003 at 8:39 am

    #445852

    This is the reason for periodic backups. You might try sp_resetstatus on the DB then restart server to see if recovers, otherwise you have lost the TL I do believe.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply