Backup script for SQL

From DataSelf Knowledge Base
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'