Home / server / Questions / 359824
Accepted
vlannoob
Asked: 2012-02-14 18:14:01 +0800 CST

SQL and Shadow Protect Server

  • 772

Rolling out a Server2008R2 box with SQL2008R2 on it to trial some new payroll software. I have ShadowProtect virtual licences for my VM's and this box will get one.

My question is: What is the best practice for backing up this SQL database? Will the ShadowProtect software allow me to restore just the DB or will it be a case of recovering the whole server? I know I can backup the DB manually via the SQL Managment studio if needed, but is there a way to automate this step if needed. I'm guessing some kind of script which goes into the Shadow Protect nightly backup that dismounts the DB, backs it up to a file and then remounts the DB??

backup sql-server-2008

2 Answers

  1. Best Answer

    I know this is a little bit old, but I found this page via Google, so might be useful for anyone else looking. This link gives suggestions from Storage Craft about using Shadow Protect and SQL backups. Some useful tips Maintenance Plans Versus Shadow Protect - The Pros And Cons

    As per the comment below, here are a couple of the most useful points from the link :

    • You must identify the volumes that the SQL data and log files reside on and include all these volumes in the same ShadowProtect job. This is counter to their (Storage Craft's) normal recommendation of a job per volume. The other downside with ShadowProtect is that because it is sector based it will not truncate the SQL log file. Therefore it is highly recommended to create a Maintenance Plan that truncates the log file simply by backing up the log file once per day (or week) and keeping one (1) backup. This backup must be performed before the ShadowProtect incremental backups start each day

    • There is a good reason that you should not mix Shadow Protect Backups and "normal" SQL Server Backups through out the day. If you rely upon SQL backups to replay logs to "roll in" and / or "roll out" transactions, you will encounter the issue when a SQL restore requests the next backup. It will be pointing to a ShadowProtect backup but it will not find the BAK file that it is expecting and you will therefore be unable to continue and have an incomplete restore

    • 2

  2. ShadowProtect takes images of the entire system, its is meant for disaster recovery, not cherry picking files to restore. However, in a pinch, you can mount an image inside of the ShadowProtect Server console installed on an OS and pick through the file system if need be.

    Depending on how you are handling snapshots, you have some flexibility on how far back you can go.

    • 1