Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Backups on new server

    Hello I have a silly question we got a new server it has Windows Server 2008 on it and SQL Server 2008 on it. I have the SQL sever doing backups and windows does backups but I was wondering are they going to conflict with one another, because apparently the windows server has stopped backing up. The last backup was on 03/02/2014 (windows server backup) would they be conflicting with one another and should I get some software to do both backups instead??

    Thank you

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    No, a SQL Server Maintenance Plan (or any other SQL backup done using Microsoft provided tools) won't conflict with Microsoft Windows Backup.

    Yes, you can purchase tools which will backup both SQL Server and other Windows files. This is a REALLY bad idea since it costs money and will probably cause problems, which you usually discover AFTER it is too late to recover from those problems.

    Stay with SQL Server backups (preferably via Maintenance Plans) and stock Windows Backups if you can.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Thank you Pat

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    To be fair, though, if you have a very large backup (say it takes an hour to run), then the files of that backup won't be eligible for the Windows backup, as those backup files will be open at that time (and incomplete for that matter), so you may need to do some fancy scheduling, if your SQL backups run long.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    MCrowley makes a good point.

    If you are using SIMPLE recovery for your databases, figure out how long you expect the backup to take and start it three times that long before you start the Windows backup. So if you expect your SQL backup to take 58 minutes, and you want to start your Windows backup at 23:00, then start your SQL backup at 20:00. This allows for a SQL database backup that runs more than twice as long as expected to still be caught on the Windows backup.

    If you are using FULL recovery for your databases, the do a FULL backup 6-8 hours ahead of the Windows backup, and do Transaction Log backups as you see fit. As long as you are sure that the FULL and all relevant transaction logs end up on the same Windows file backup, then restores can be mildly painful/time consuming, but they are possible!

    Paul Randal did a fantastic job explaining the issues and how to handle them in Planning a Recovery Strategy.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  6. #6
    Join Date
    Mar 2014
    Posts
    1
    Your new Windows server came with its own backup application, but is it enough? Just as the type of work you do dictates your small business network architecture, so should it help you realize that the one size fits all Microsoft Server Backup approach doesn’t exactly fit all situations. Your own network configuration could make backing up your server one that requires multiple applications with knowledge of several work-around techniques.

    Attempting to keep so many moving parts working together can be disastrous for your recovery. What you need is a server backup that combines the capabilities of multiple applications in a single management console. Unfortunately, most server administrators don’t realize this fact until it’s too late and their data is lost forever.


    For more please visit six week industrial training in chandigarh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •