Post reply

Backup of the SQL Server binaries

  • May 17, 2007 at 6:14 am

    #117314 

    Do we need to shut down the SQL Server services when doing a backup for the SQL Server binaries ?
    

    (ex: C:\Program Files\Microsoft SQL Server\).
    

    We currently backup the databases via the Database Maintenance plan but have no backup of the SQL server binaries. How often should this be done ?
    

    .
    

    And would it be worth copying the System Database files while the services are down, then if we loose the Master DB then we could just copy it back and restore on top of it
    

    .
    

    Thanks
     
      
    •  
  •   
     
     
     May 18, 2007 at 3:16 am 
     
      #707356  
          
         
     
    Our standard practice is to take nightly tape backups after the Maintenance jobs have generated their .BAK files, and once a week to Net Stop the SQL Server services before running the full tape backup.  It keeps our Ops people happy, though it means database downtime, which we can accommodate.
    Ops also take occasional Ghost images of the server C: drives.
    If it came to a restore, I would much rather use SQL Server restore from .BAK and .TRN than rely on file snapshots, even if these were apparently up to date - it's a managed process that should guarantee data integrity.
     
      
    •  
  •   
     
     
     May 18, 2007 at 5:08 am 
     
      #707375  
          
         
     
    If you're in a situation that you cannot stop the SQL engine, I suggest you to have ghost back-up. 
     
      
    •  
Viewing 3 posts - 1 through 2 (of 2 total)
 
You must be logged in to reply to this topic. Login to reply