July 21, 2009 at 9:34 am
if I add an image to a table and I have backed up the transaction log but not yet the database, what happens during recovery? Does the transaction log hold hold the image file, too? I think it should, but I can't find any documentation on it.
thanks,
MKM
July 21, 2009 at 12:41 pm
Hope it shud hold them, but can do a simple try checking the .trn backup file size after inserting only images and backing it in a sample db.
July 21, 2009 at 2:07 pm
good idea...however, I finally found documentation that verifies that the datapage itself is backed up in the trn log.
thank,
MKM
July 22, 2009 at 1:17 pm
Can you post a link for that?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 22, 2009 at 1:50 pm
Monica K. Murphy (7/21/2009)
I finally found documentation that verifies that the datapage itself is backed up in the trn log.
That is for bulk operations in bulk-logged recovery only.
If you have never backed up the database, you will not be able to backup the log. You'll get an error saying that a current database backup does not exist. You need a full backup to start off the log chain. The first log backup after that will have the log records since the full backup. Every log backup after will have the log records since the previous log backup.
If there has never been a database backup thenthe database behaves like it's in simple recovery.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply