SQL Server Backup Question: 1

[Apollo21]

Apollo21 (Programmer)

Good Afternoon/Morning Everyone!

A question has come up about the order that SQL Server wants us to do the backups. Meaning we do a Full .BAK, then to do a Log .TRN Backup and all is fine. What if we swapped the two and did a .TRN prior to doing a .BAK, What would the repercussions be from doing it in that order?

Opinions and Facts wanted!

Thank you for you input in advance!

Apollo21

 

[onpnt]

You need a full backup to attach the log backup to so you do a full and then a log. If you did a log backup before it would apply to the backup done the previous full. (did I say that right)

The basic setup on a full recovery db will be
Take a full backup say Monday
Daily increment a log backup. say every 10 minutes
nightly (but the full night) take a diff backup

This way you ahve a recovery point every 10 minutes with your backups not causing performance and resource issues



[sub]____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[Apollo21]

Thank you. I know the correct sequence. This was just a what if from one of the people who are unfamiliar with the product. I would still like to know the rudiments of what would happen. Would the log not revert its processes back to the full backup before the current one? (I don't know if I said that correctly)

I will be back tomorrow.

Again Thanks!

 

[onpnt]

The log file will revert to whatever full backup was done prior to it. So it would be kind of useless to do a backup of your log and then a full backup unless you have some process or batch you do on the DB directly prior to the backup


[sub]____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]