增量备份和还原 [英] Incremental backup and restore

问题描述

您好专家！



我想自动执行从服务器2目录中的服务器1获取增量备份的过程，并恢复目录中每个最新的差异备份服务器2在两个服务器中具有相同名称的现有数据库...



我使用sqlserver2008 r2。



你的帮助真的很轻松。





谢谢

farh

Hello experts !

I want to automate the process of taking incremetal backup from server 1 in the directory of server 2 and restore every lastest differential backup in the directory to server 2 existing db having same names in both servers...

Iam using sqlserver2008 r2.

Your help really ease my life.


Thank you
farh

推荐答案

看看 http://www.sqlmag.com/blog/sql-server-questions-answered-28/sql-server/does-sql-server-have-incremental-data- backups-137150 [ ^ ]

http://sqlanywhere.blogspot.in/2011/04/demonstrating-full-and-incremental.html [ ^ ]

先生，



我找到了恢复不同备份但有错误的链接。我的级别非常低，以上链接非常有用，无法实现？







http://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup- files-in-a-directory / [ ^ ]



我评论了所有其他完整备份和交易lo gs有差异但有错误



< db2Msg 16916，等级16，状态1，行42

名为'的游标'backupFiles''不存在。

消息16916，级别16，状态1，行61

名称为''backupFiles''的游标不存在。

消息16916，级别16，状态1，行71

名称为''backupFiles''的游标不存在。

消息16916 ，16级，状态1，行72

名称为''backupFiles''的光标不存在。

RESTORE DATABASE db2 WITH RECOVERY>





帮助我...

谢谢

Sir,

I find the link to restore differntial backup but having error.My level is very low the above link very informative bu iam unable to implement?



http://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/[^]

I commented all the all other full backup and transaction logs leaved differential but having error back

<db2Msg 16916, Level 16, State 1, Line 42
A cursor with the name ''backupFiles'' does not exist.
Msg 16916, Level 16, State 1, Line 61
A cursor with the name ''backupFiles'' does not exist.
Msg 16916, Level 16, State 1, Line 71
A cursor with the name ''backupFiles'' does not exist.
Msg 16916, Level 16, State 1, Line 72
A cursor with the name ''backupFiles'' does not exist.
RESTORE DATABASE db2 WITH RECOVERY>


help me out ...
thanks

这篇关于增量备份和还原的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！