« »

backing up sql 2008 r2 express databases w/ t-sql

t-sql syntax:

USE AdventureWorks2012;
GO
BACKUP DATABASE AdventureWorks2012
TO DISK = 'Z:\SQLServerBackups\AdventureWorks2012.Bak'
   WITH FORMAT,
      MEDIANAME = 'Z_SQLServerBackups',
      NAME = 'Full Backup of AdventureWorks2012';
GO

sources:
http://msdn.microsoft.com/en-us/library/ms187510.aspx
http://msdn.microsoft.com/en-us/library/ms162773.aspx

This entry was written by resinblade , posted on Tuesday June 11 2013at 06:06 pm , filed under IT . Bookmark the permalink . Post a comment below or leave a trackback: Trackback URL.

Comments are closed.

« »