We run a Windows Small Business Server 2003 with SQL Server 2005 Express on it. The server is configured to do a daily backup of system state and all files. Today I need to restore a single database from the back-up, but the back-up is corrupt.

I thought I'd use the shadow copy that is created as part of the backup process, SQL Server indicates that a backup has been made of the database (using SQL Server Management Studio Express the database properties windows shows a Last Database Backup property).

Using the vssadmin.exe tool I see that there is a SqlServerWriter registered. Is it possible to restore the database file from the shadow copy? I can only see a command to restore the complete disk to a previous version.



i read your question a few days ago & stumbled across this blog by a computer forensics guy who is using robocopy to pull files out of shadow copy volumes & remembered your question!

No idea if this will work for you, you can try copying out the data/log files & see how it goes!

  • Thanks for the link! I tried to do that, but it's a Windows Server 2003 machine, so I can't use mklink. I tried it using junction.exe from SysInternals. Unfortunately it can't create a link to a shadow copy volume (error "the data present in the reparse point is invalid"). Aug 6 '10 at 7:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.