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
Subscribe to:
Post Comments (Atom)
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...
-
If you have received the following errors when running the ACL scripts, "The ordinal xxxx could not be located in the dynamic link libr... -
This has been a frequent seen issue in our environment. The common symptoms are: After a Word or Excel file open, or when trying to save... -
The error is "Sorry, we're unable to reach the server right now. Please try again later." The solution is to uncheck "D...
No comments:
Post a Comment