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