Below script describe how to backup database and output file include current date
DECLARE @filename NVARCHAR ( 500 )
SET @filename = 'C:\ABC_' + CONVERT(NVARCHAR, GETDATE(),112) + '.BAK'
BACKUP DATABASE ABC TO DISK = @filename
Happy code ;)
Subscribe to:
Post Comments (Atom)
Data Governance Learning Plan
Seven courses to build the knowledge of Data Governance Program ( planning & establishment ) by Kelle O'Neal with 100 MCQs Exam 1....
No comments:
Post a Comment