Backup of MS SQL bases
The MSSQL
Set up service plans for backup of Microsoft SQL Server bases.
Examples of a standard service plan:
1 . Once a day:
1.1 Verification of the integrity of the bases;
1.2 maintenance of index;
1.3 Complete backup;
1.4 Removal of old backups and logs of the service plan.
2nd Multiple backup or backup of the transaction log over the days with the specified frequency.
Optionally, backup copies can be replicated to a remote storage.
If necessary, the functionality can be expanded through the scripts of t-sql, PowerShell, CMD.
Set up service plans for backup of Microsoft SQL Server bases.
Examples of a standard service plan:
1 . Once a day:
1.1 Verification of the integrity of the bases;
1.2 maintenance of index;
1.3 Complete backup;
1.4 Removal of old backups and logs of the service plan.
2nd Multiple backup or backup of the transaction log over the days with the specified frequency.
Optionally, backup copies can be replicated to a remote storage.
If necessary, the functionality can be expanded through the scripts of t-sql, PowerShell, CMD.