April 28, 2010 at 6:48 am
Hi we are running fullbackups on every sunday at 2a.m.and transactional log backups
on monday to saturday at 3:30a.m.i have to schedule diferential backups also on everyday.
please guys let me know at what time can i schedule.
Thanks in advance
April 28, 2010 at 7:10 am
d.srikanth50 (4/28/2010)
Hi we are running fullbackups on every sunday at 2a.m.and transactional log backupson monday to saturday at 3:30a.m.i have to schedule diferential backups also on everyday.
please guys let me know at what time can i schedule.
Thanks in advance
Pretty much whatever time you want. The differential log backups are dependent on the full backup, not log backups.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2010 at 8:19 am
If these are important databases with frequent activity, then it's strange you are only taking transaction log backups once a day at 3:30 am. If you have a failure or data corruption at 6 pm you may lose everything since 3:30 am.
April 28, 2010 at 8:22 am
I was thinking the same thing, plus, how the heck big are the transaction logs?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2010 at 6:46 pm
And why the differential backup now? It is apparent that the tlogs are being used as the diff and loss of data is permissible.
I would consider revising the entire schedule, more frequent tlog backups and daily diffs.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply