MS SQL Database Backup Script

Besides using Database Maintenance Plan to create automatic backup of critical database, you can simply use the below script and call it regularly as Scheduled Jobs inside SQL Server Agent


BACKUP DATABASE [MYDB]
  TO  DISK = N'Z:\RestoreData\MYDB.BAK'
   WITH  INIT ,  NOUNLOAD , 
   NAME = N'MYDB backup',  NOSKIP ,  STATS = 10,  NOFORMAT



Comments

Popular Posts