locked
Restore DB without Transaction Log RRS feed

  • Question

  • Hi,

    How can I restore a DB without TRN log. As database transaction logs grows too much and I only want to restore the database.

    Thanks

    Shafiq

     

    Monday, June 5, 2006 8:10 PM

Answers

  • You should be wary about just going to simple recovery model. This is not suitable for production systems where loss of recent changes (in the event of a problem) is not acceptable.

    This is because after a data backup in the simple recovery model, the transaction log is truncated. This means that its only possible to restore back to the time the last backup was completed - its not possible to do a point-in-time restore up to just before the problem occured so all work between those two points is lost.

    See the SQL Server 2005 BOL entry for 'Overview of Simple Recovery' for more details.

    Thanks

    Monday, June 5, 2006 10:52 PM

All replies

  • If you only restore the transaction log then the database will be transactionally inconsistent - the transaction log is an integral part of the backup.

    What's the scenario context here?

    BTW, what size DB and transaction log are we talking about here?

    Thanks

    Monday, June 5, 2006 8:47 PM
  • You should be wary about just going to simple recovery model. This is not suitable for production systems where loss of recent changes (in the event of a problem) is not acceptable.

    This is because after a data backup in the simple recovery model, the transaction log is truncated. This means that its only possible to restore back to the time the last backup was completed - its not possible to do a point-in-time restore up to just before the problem occured so all work between those two points is lost.

    See the SQL Server 2005 BOL entry for 'Overview of Simple Recovery' for more details.

    Thanks

    Monday, June 5, 2006 10:52 PM