Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Thanks!

share|improve this question

1 Answer 1

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!

share|improve this answer
    
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"). –  michielvoo Aug 6 '10 at 7:41

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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