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??