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!