Example 9-1
------------------------------------------------------------------------------------------------
BACKUP DATABASE [myDatabase] 
TO  DISK = N'C:\DBBackup\myDatabasebk' 
WITH  NOINIT ,  NOUNLOAD ,  
NAME = N'myDatabasebackup',  
NOSKIP ,  STATS = 10,  NOFORMAT 
GO

Example 9-2
------------------------------------------------------------------------------------------------
BACKUP DATABASE [myDatabase]   
FILE = N'myDatabase_Data' 
TO  DISK = N'D:\DBBackup\myDatabaseFilebk' 
WITH  NOINIT ,  NOUNLOAD ,  
NAME = N'myDatabaseFilebackup',  
NOSKIP ,  STATS = 10,  NOFORMAT 

Exmple 9-3
------------------------------------------------------------------------------------------------
BACKUP LOG [myDatabase] 
TO  DISK = N'D:\DBBackup\myDatabaseLogbk' 
WITH  NOINIT ,  NOUNLOAD ,  
NAME = N'myDatabaseLogbackup',  
NOSKIP ,  STATS = 10,  NOFORMAT 

Exmple 9-4
------------------------------------------------------------------------------------------------
BACKUP LOG [myDatabase] 
WITH TRUNCATE_ONLY

Exmple 9-5
------------------------------------------------------------------------------------------------
EXEC sp_addumpdevice 'disk', 
'mybackupdevice',
'D:\DBBackup\mybackupdevice.dat' 

Exmple 9-6
------------------------------------------------------------------------------------------------
BACKUP DATABASE mydatabase 
TO mybackupdevice

Exmple 9-7
------------------------------------------------------------------------------------------------
BACKUP LOG mydatabase 
TO mybackupdevice

Exmple 9-8
------------------------------------------------------------------------------------------------
BACKUP DATABASE [myDatabase]   
FILE = N'myDatabase_Data' 
TO  mybackupdevice
WITH  NOINIT ,  NOUNLOAD ,  
NAME = N'myDatabaseBackupDevice',  
NOSKIP ,  STATS = 10,  NOFORMAT 


Exmple 9-9
------------------------------------------------------------------------------------------------
RESTORE DATABASE myDatabase 
 FROM DISK = N'D:\DBBackup\myDatabasebk'

Exmple 9-10
------------------------------------------------------------------------------------------------
RESTORE DATABASE MyNwind
		FROM MyNwind_1
WITH NORECOVERY
RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH FILE = 2


Exmple 9-11
------------------------------------------------------------------------------------------------
RESTORE DATABASE MyNwind
   FROM MyNwind_1
   WITH NORECOVERY, 
   MOVE 'MyNwind' TO 'c:\Program Files\Microsoft 
	SQL Server\MSSQL\Data\NewNwind.mdf', 
   MOVE 'MyNwindLog1' TO 'c:\Program 
	Files\Microsoft SQL 
	Server\MSSQL\Data\NewNwind.ldf'
	RESTORE LOG MyNwind
   FROM MyNwindLog1
   WITH RECOVERY





