Requirements:
1. A company's management software, the database is sql2008r2.
2. synchronizes the entire database to the FTP server as a single file
3. You need to have multiple backups, one at a time, to back up the last file to the backup folder.
Important:
1. When a user adds a data entry to a database, the modification time of the database file is not changed synchronously.
2. tick the "shadow copy" feature. The Bestsync will be able to synchronize the database files being edited.
3. Database file modification times need to be implemented by pre-executing batch files, and real-time monitoring cannot implement the ability to perform other files before starting tasks.
4.
Task implementation process:
-5:30 every day, the task starts.
--Closes the SQL database service. Shutting down the database writes all of the database cache data in a single day to the database file.
--Synchronizes the database files to the backup folder.
--Opens the SQL database service.
Follow the steps below to record only the key steps:
Edit-Append task:
General Properties page, setting source, purpose. SQL database file path typically defaults to:
C:\Program Files\Microsoft SQL Server\mssql10_50.sql2008r2\mssql\data
Backup property pages, multiple backups, but only for 7 days (can be set on demand):
Select the Exclude property page to synchronize only two files, excluding all other files:
Note: To use shadow copy, you must run with Administrator privileges:
1. When starting Bestsync:
2. Bestsync menu, Options-"option"
Schedule Property page (set timing or real-time):
Program Properties page: Manually create two batch files.
Two batches of file contents:
Stopsql.bat
@echo off
net stop mssql$sql2008r2
Startsql.bat
@echo off
net start mssql$sql2008r2
Note: How to know the SQL Server service name
Enter the service interface, double-click the SQL Service routine, and the service name in the pop-up window is.