Tuesday, November 5, 2013

Create a Full Database Backup (SQL Server)

 

Examples (Transact-SQL)

 The following example backs up the complete 
    AdventureWorks2012
   database to disk, by using FORMAT to create a new media set.
 
 
USE AdventureWorks2012;
GO
BACKUP DATABASE AdventureWorks2012
TO DISK = 'Z:\SQLServerBackups\AdventureWorks2012.Bak'
   WITH FORMAT,
      MEDIANAME = 'Z_SQLServerBackups',
      NAME = 'Full Backup of AdventureWorks2012';
GO
 
 
 
ref:
http://technet.microsoft.com/en-us/library/ms187510.aspx
 

No comments:

MS in Computer Science with paid training in USA company