SQL SERVER数据库备份与还原

完整备份 backup database pubs to disk='d:pubs1.bak'

日志备份 backup log pubs to disk='d:pubslog1.bak'

差异备份 backup database pubs to disk='d:pubs1cy.bak' with differential

日志备份 backup log pubs to disk='d:pubslog2.bak'

完整备份 backup database pubs to disk='d:pubs2.bak'

差异备份 backup database pubs to disk='d:pubs2cy.bak' with differential

日志备份 backup log pubs to disk='d:pubslog3.bak'

数据库损坏时备份日志： backup log pubs to disk='d:pubslog.bak' with NO_TRUNCATE

还原完整备份with只读 restore database pubs from disk='d:pubs1.bak' with standby='d:undo.trc'

还原日志备份with只读 restore log pubs from disk='d:pubslog2.bak' with standby='d:undo.trc'

还原差异备份with只读 restore database pubs from disk='d:pubs1cy.bak' with standby='d:undo.trc'

指示还原操作回滚任何未提交的事务。在恢复进程后即可随时使用数据库。 recovery restore log pubs with recovery

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/775555/viewspace-1008308/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/775555/viewspace-1008308/