Monday, August 22, 2011

SQL Backup Script

To create a simple backup job by using SQL Server Agent in MS SQL Server Management Studio

DECLARE @BackupPath VARCHAR(100)

SET @BackupPath = '\\<UNC Path>\PM_' + CONVERT(VARCHAR, GETDATE(), 112) + '.bak'

BACKUP DATABASE [<database_name>]

TO DISK = @BackupPath
GO

 

No comments:

Post a Comment

ordinal xxxx error in ACL

If you have received the following errors when running the ACL scripts, "The ordinal xxxx could not be located in the dynamic link libr...