sqlserver增量+全量备份

sql server全量备份：

osql/sqlcmd -U $user -P ?$passwd -d master -S $instance -Q "BACKUP DATABASE lory TO DISK='C:lorydbbackuplory.sql' with format,init"

sql server增量备份：

osql/sqlcmd -U $user -P ?$passwd -d master -S $instance -Q "BACKUP DATABASE lory TO DISK='C:lorydbbackuplory.diff' with format,differential"

sql server恢复完整备份文件：

osql/sqlcmd -U $user -P ?$passwd -d master -S $instance -Q "alter database lory set offline with rollback immediate; restore database lory from disk='C:lorydbbackuplory.sql' with replace; alter database lory set online"

osql/sqlcmd -U $user -P ?$passwd -d master -S $instance -Q ""alter database lory set offline with rollback immediate; restore database lory from disk='C:lorydbbackuplory.sql' with replace,norecovery ; restore database lory from disk='C:lorydbbackuplory.diff' with recovery; alter database lory set online"<span style="font-family: 'Microsoft Yahei',Simsun; background-color: rgb(255,255,255);">?</span>

备?注：

1.采用osql 或 sqlcmd工具； ?

2.$user,$passwd,$instance为对应的命令参数；

3.测试的数据库为lory ?完整备份文件以.sql结尾；差异备份文件以.diff结尾?

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!