full backup and transaction

Question

full backup and transaction

dbit

Valued Member

Points: 67
More actions
December 17, 2009 at 2:21 pm

#228619

Hi,
I created backups through maintenance plan, full backup every night at 6pm, and transaction log backup at 9am, 11am, 3pm. If i want to restore the database for testing or development purposes on another server with the backup files, do I need to restore both full and transaction log? or just full backup will do? thx.

Viewing 5 posts - 1 through 4 (of 4 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Depends.

Do you just want a copy of the database on the dev box? If so, just the full's fine. If you want the opy on the dev box to reflect exactly what production looked like at a specific time (like 9am), then you'll need the log backups as well.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

It depends. How current do you want the data for testing and/or development. If it doesn't matter, then all you need is the full backup.

dbit Valued Member Points: 67 More actions · Answer 3

Got it! thank you. Perhaps just the full would suffice. Development doesn't need the latest transaction included.

homebrew01 SSC Guru Points: 55548 More actions · Answer 4

Transaction logs of production databases are usually backed up more frequently than you are doing. Are you sure you don't need them more often ? (I don't mean to be nosy)