Post reply

Backup schedules

  • April 28, 2010 at 6:48 am

    #220935

    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

    #1158878

    d.srikanth50 (4/28/2010)

    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

    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

    #1158958

    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

    #1158963

    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

    #1159365

    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