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

Java issue when access EqualLogic Group Manager

 Do you still manage an EqualLogic SAN? Yes I do. I still have an EqualLogic PS6100 running STRONGLY. I tried to access the management inter...