#Install Symantec Vss Provider full#

aware-tool), that suggests a way of tricking SQL into allowing a restore of these, but I haven't had any luck getting that to work (error of 'A previous restore operation was interrupted and did not complete processing.' when restoring the diff).

#Install Symantec Vss Provider full#

It seems like there should be some way of taking a full VSS backup and using it as the base for diff/tlog backups, but I haven't been able to find a way to do this. While I have restored the MDF/LDF files out of the full backup file from 11:30pm, does anybody know if there's any way I can combine this with the diff/tlog backups that happened after that? I don't know of anyway to restore from the MDF/LDF files other than attaching them to the server, but this leaves the database online and doesn't allow restoring any other backups on top of it. However, looking at the backup chain on the SQL server now, I see that the full server backup that happened at 11:30pm is the base full backup for the subsequent differential backups, rather than the regular full backup at 9:30pm. Normally this would require restoring the full DB backup from Thursday night at 9:30pm onto a separate SQL server, then the last diff backup from Friday morning, and the remaining transaction log backups. As part of this we added host-level backups of the VM (Backup Exec 2012, ugh.), while leaving the SQL backups in place to allow for quicker disaster recovery.įast forward to now where we have the need to recover some data based on the last transaction log backup at 11:15am on Friday. Recently we performed a P2V conversion on a SQL server (Win 2003, SQL 2005) to move it into a ESXi VM.

Our normal practices for backing up SQL servers is to use the regular SQL backup tools to perform full, differential and transaction log backups and this has always worked fine.