TransactSQL Backup

BACKUP DATABASE [ecom] TO DISK = N'D:\bak\name' WITH NOFORMAT, INIT, NAME = N'name-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

Note: The drive must be local, not network or any removable device. You can use XCOPY or other command line argument to move the file after the backup is finished.

See also:

• http://www.cs.trinity.edu/~thicks/Tutorials/MSSQL-Server-Management-Studio-Import-Export-Backup/Import-Export-Backup-MSSQL-Database.html How to backup, restore, etc... Note that the SQLServer2005MSSQLUser must have full permissions for a folder from which it will import or restore data.