Thursday, May 29, 2014

Backing up a database using Transact


BACKUP DATABASE ExampleDBName
TO DISK = 'D:\SQLBackups\backupfilename'+convert(varchar,getdate(),121)+.bak'
GO



You can also add a datetime string to your file name to make them unique:


No comments:

Post a Comment