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:
Post a Comment