在CentOS上备份和恢复SQL Server数据库可以通过多种方式实现,以下是详细的步骤和策略:
完整备份:
BACKUP DATABASE [AdventureWorks2019] TO DISK = N'/backups/AdventureWorks2019.bak' WITH FORMAT;
差异备份:
BACKUP DATABASE [AdventureWorks2019] TO DISK = N'/backups/AdventureWorks2019_Diff.bak' WITH DIFFERENTIAL;
事务日志备份:
BACKUP LOG [AdventureWorks2019] TO DISK = N'/backups/AdventureWorks2019_Log.bak';
定期备份:
完整恢复:
RESTORE DATABASE [AdventureWorks2019] FROM DISK = N'/backups/AdventureWorks2019.bak' WITH RECOVERY;
简单恢复:
RESTORE DATABASE [AdventureWorks2019] FROM DISK = N'/backups/AdventureWorks2019.bak' WITH NORECOVERY;
大容量日志恢复:
RESTORE DATABASE [AdventureWorks2019] FROM DISK = N'/backups/AdventureWorks2019.bak' WITH RECOVERY, REPLACE;
安装mssql-tools:
sudo yum install -y mssql-tools
备份数据库:
sqlcmd -S MSSQLSERVER -d your_database -E
BACKUP DATABASE your_database TO DISK '/backups/backup.bak' WITH FORMAT;
EXIT;
恢复数据库:
sqlcmd -S MSSQLSERVER -d your_database -E
RESTORE DATABASE [your_database] FROM DISK '/backups/backup.bak' WITH REPLACE, RECOVERY;
EXIT;
通过上述策略和步骤,可以在CentOS上有效地进行SQL Server数据库的备份和恢复,确保数据的安全性和可靠性。
亿速云「云数据库 MySQL」免部署即开即用,比自行安装部署数据库高出1倍以上的性能,双节点冗余防止单节点故障,数据自动定期备份随时恢复。点击查看>>