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)
Solution: The size of the extent is less than the minimum in VMware
I ran out the C drive space in a Windows 10 virtual machine in VMware. However, after adding additional free disk space, the "Extend&q...
-
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... -
Recommended by a very knowledgeable Xerox technician - perform this procedure once a month Unplug both Ethernet and power cable for 5 fu...
-
If you have received the following errors when running the ACL scripts, "The ordinal xxxx could not be located in the dynamic link libr...
No comments:
Post a Comment