Ms SQL Express server backup script

Posted on Thu 05 April 2018 in Hack • 3 min read

Who said there are no backups in SQL Express Server? Prepare SQL script like below:

#. 2BACKUP DATABASE [database_name] TO DISK = N'C:\\Backup_baz\\database_name' WITH NOFORMAT, INIT, NAME = N'database_name-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
#. 4BACKUP DATABASE [database2_name] TO DISK = N'C:\\Backup_baz\\database2_name' WITH NOFORMAT, INIT, NAME = N'database2_name-Full Database Backup' …

Continue reading