Backup LOG first, then DATABASE ? does the order matter? 1

[mb22]

I do a full backup of my database and log each night. I used to do the database first, followed by the log.

But then I changed my mind .. and started backing the log first, then followed by the database.

Does it really matter? Is that the better way?

 

[Corran007]

Why do both? when you backup the full database you get everything. there really is no reason to even do the log at that time. you should be doing the log throughout the day then a full that night. if you really want to shorten your downtime. you can throw a diffirental backup in there as well. unless you have your database backup not set to remove inactive entries from the log which you then use your log to do. but im not really sure why you would need to do that.

 

[mrdenny]

If you plan on restoring the log onto the database, you must backup the database first. But as Corran said, the log should be backed up through out the day, not just at night.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[mb22]

thanks guys.