Backup script for SQL

From DataSelf Knowledge Base
Revision as of 04:19, 4 December 2013 by Dataself (talk | contribs) (Created page with "{{#breadcrumb:SQL Features}} Category:Microsoft SQL Server <!-- {{TOCFloatRight}} -->__NOTOC__ == SQL Server Job Step configuration to back up a dw DB: == Type: Transact-...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

SQL Server Job Step configuration to back up a dw DB:

Type: Transact-SQL script (T-SQL) Database: select correct DB

BACKUP DATABASE [DbName] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\FileName.bak'