[Reprinted] use the SQLServer maintenance plan to implement regular automatic Database Backup

For data security considerations, You need to regularly back up the database in SQLServer. The backup database is generally performed in the early morning when there are basically no database operations, so we cannot ask the Administrator to back up the database at every day. To implement regular automatic database backup, the most common method is to use the SQL Server proxy.

In SQL Server, regular database backup is required for data security considerations. The backup database is generally performed in the early morning when there are basically no database operations, so we cannot ask the Administrator to back up the database at every day. To implement regular automatic database backup, the most common method is to use the SQL Server proxy.

In SQL Server, regular database backup is required for data security considerations. The backup database is generally performed in the early morning when there are basically no database operations, so we cannot ask the Administrator to back up the database at every day. To implement regular automatic database backup, the most common method is to use jobs in the SQL Server proxy. Start the SQL Server Agent service, website space, and then create a job in it, Hong Kong Space, add a backup step in the job, type is T-SQL script, and then enter the following SQL statement in the command, this statement implements a complete Backup of the database TestDB1. The Backup file is in the Backup folder on disk C, and the Hong Kong server is rented. The file name is TestDB1 + date string of the Backup at that time. bak.