[Mssqlcity.com] -- The primary data file of the pubs database was damaged -- on Tuesday at 3 AM -- Back up the active transaction log. BACKUP LOG pubs TO pubs_back_log GO -- Restore the full database from Sunday 1 AM without recovering RESTORE DATABASE pubs FROM pubs_back_db WITH NORECOVERY GO -- Restore the differential backup from Tuesday 1AM without recovering RESTORE DATABASE pubs FROM pubs_back_db WITH FILE = 3, NORECOVERY GO -- Restore the transaction log backup from Tuesday 2AM with recovering RESTORE LOG pubs FROM pubs_back_log WITH FILE = 2, NORECOVERY GO -- Apply the last created log backup and recover the database RESTORE LOG pubs FROM pubs_back_log WITH FILE = 3, RECOVERY GO
Some related posts from Technorati and Google.
[Blog.transactsql.com] Transact-SQL Blog: Flu is over and backup file security hole: BACKUP DATABASE test_backup_2005 to DISK = 'C:\test_backup_2005.bak' WITH CHECKSUM --CHECKSUM will prevent tampering with backup file
[Red-gate.com] SQL Backup log shipping: SQL Backup will pick up all files matching the *.msb pattern in the F:\Backups\pubs\logs\ folder. It will discard locked files (in the process of being copied from the primary server), identify backup groups (or split backups), ensure all members of a backup group are present, arrange the files in sequence and finally restore each backup group sequentially.
[Windowsitpro.com] Why can't I backup/restore my SQL Server database to a share on ...: See the SQL Server error log for more details. Server: Msg 3013, Level 16, State 1, Line 1 Backup or restore operation terminating abnormally."
[Weblogs.asp.net] Jon Galloway : [SQL] Scripting backup and restore all databases on ...: The following script builds a temp table (#fileinfo) which holds the logical and physical names of both the data and log files for every database on a server. No, this probably won't help that guy with multiple data or log files for a single database (I think his name was Raphael), but he stopped reading back at the first paragraph.
Reflected tags on Technorati: Blog, Restore Database, Data Recovery Reports