SQL Backup
Grab the orphan log before any restore
USE master
BACKUP LOG database TO device
WITH NOINIT, NO_TRUNCATE,
NAME = 'nwcopy-Log2',
DESCRIPTION = 'Transaction log backup after database failure'
+++++++++++++++++++++++
Basic backup
USE master
EXEC sp_addumpdevice 'disk', 'nwc2','c:mssql7backupnwc2.bak'
BACKUP DATABASE nwcopy TO nwc2
WITH FORMAT, NAME = 'nwcopy-Complete',
DESCRIPTION = 'A single file complete backup of nwcopy'
++++++++++++++++++++
backup log
USE master
EXEC sp_addumpdevice 'disk', 'nwchange', 'c:mssql7backupnwchange.bak'
BACKUP LOG nwcopy TO nwchange
WITH FORMAT,
NAME = 'nwcopy-Log1',
DESCRIPTION = 'Transaction log backup of nwcopy'
++++++++++++++++
diff backup
USE master
BACKUP DATABASE nwcopy to nwchange
WITH DIFFERENTIAL, NOINIT,
NAME = 'nwcopy-Diff',
DESCRIPTION = 'Differential backup of nwcopy'
|