Recently, due to the server problem, a database migration. Migration found SQL Server Express version is free, can meet my needs, abandoned the original version of SQL Server R2 directly used.
Database has been built, the data also migrated, the Business Server is also updated database connection, the database is automatically backed up, the problem also comes:SQL Server Agent service can not start! after one hours of research, it was discovered that the Express version could not use the agent service.
Microsoft is also very specific, also wrote a free express version of SQL Server How to do free automatic backup.
Original URL: https://support.microsoft.com/en-us/help/2019698/ How-to-schedule-and-automate-backups-of-sql-server-databases-in-sql-se
Website: https://support.microsoft.com/zh-cn/help/2019698/ How-to-schedule-and-automate-backups-of-sql-server-databases-in-sql-se
My server is Windows SERVER2012R2.
Through practice, the article is basically correct, where step B cannot be executed correctly. After research, the statements that I finally successfully use are
Sqlcmd-q "EXEC sp_backupdatabases @backupLocation = ' D:\SQLBackups\ ', @databaseName = ' database name you want to back up ', @BackupType = ' F '"
Operation Practice notes for daily automatic database backup under Windows server2012r2+sql Server Express version