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)
What happened if the Security Default is turned off in Microsoft Entra?
No need to worry about turning off Security Default in Microsoft Entra ID because Microsoft will automatically create 4 managed conditiaiona...
-
Users complained they were unable to log in VMware Horizon Client portal and the logon stuck at "Authenticating...." screen. So I...
-
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... -
I ran out the C drive space in a Windows 10 virtual machine in VMware. However, after adding additional free disk space, the "Extend...
No comments:
Post a Comment