Posted by Erland Sommarskog on 12/20/06 22:47

gabe101 (gabe101@gmail.com) writes:
> My only concern here comes back to my inexperience with transaction
> logs. Doing a restore through the Enterprise Manager is incredibly
> simple with a full .BAK file. I've not done a transaction log restore
> and have been told it's much more complex. I agree with you and Erland
> here, but given our current situation, a restore from a full backup
> file and then manually entering the day's transactions may ultimately
> be just as simple to accomplish.

Note that what I suggested was *not* a transaction log dump, but a
differential backup. I will have to admit that I've never taken a
differential backup, nor restored from one, but I can't imagine
that it's that tricky. You would need to play with it on a test
box, so that you are confident with the process when the disaster
strikes.

A differential backup only includs the changed pages since the last
full backup, so it would be a lot smaller and thus tax the system
less.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]