Tuesday, March 17, 2009

Backup Database script

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 ;)
Post a Comment

What You Need To Build an Open Sourced Data Science Platform.

Source::#brighttalk.com The most common questions you may have after you see the architecture , I think get them answered before see th...