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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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