每小时备份和恢复数据库：如何实现？ [英] Backup and restore database hourly: how to implement it?

问题描述

我有两台服务器，使用SQL Server 2000.

我被要求在一台服务器上实现每小时备份3数据库

并将这些数据库恢复到另一台服务器。 br />

有人能给我详细的步骤吗？

提前多多谢谢！

I have two servers, using SQL server 2000.
I was asked for implementing hourly Backup 3 databases in one server
and restore those databases to another server.

Could anyone give me the detailed steps to do that?
Thanks a lot in advance!

推荐答案

< da ***** @ gmail.comwrote in message

news：11 ****** ****************@l53g2000cwa.googlegr oups.com ...

<da*****@gmail.comwrote in message
news:11**********************@l53g2000cwa.googlegr oups.com...

>我有两台服务器，使用SQL server 2000.

我被要求在一台服务器上实现每小时备份3数据库

并将这些数据库恢复到另一台服务器。

>I have two servers, using SQL server 2000.
I was asked for implementing hourly Backup 3 databases in one server
and restore those databases to another server.

Google log-shipping。


你真的只想对服务器B进行全面恢复，然后再进行交易

之后的日志备份/恢复。

Google log-shipping.

You really only want to do a ful restore to server B, and then transaction
log backup/restores after that.

>

任何人都可以给我详细的步骤来做到这一点？

提前多多谢谢！

>
Could anyone give me the detailed steps to do that?
Thanks a lot in advance!

日志传送是一个从主服务器获取事务日志的过程

SQL Server并按计划顺序应用它们另外一台SQL Server。


备份是否同样如此/恢复数据库??非常感谢

的任何解释。我根本不知道。

Log shipping is a process that takes transaction logs from a primary
SQL Server and applies them sequentially on a scheduled basis to
another SQL Server.

Does this do same thing for Backup/Restore the database?? Thanks a lot
for any explaination. I do have no idea about that.

谷歌日志发货。


你真的只想做一个完整的恢复到服务器B，然后交易

logbackup /恢复之后。

Google log-shipping.

You really only want to do a ful restore to server B, and then transaction
logbackup/restores after that.

< da ***** @ gmail.com写信息

新闻：11 ********************** @ q2g2000cwa.googlegro ups.com ...

<da*****@gmail.comwrote in message
news:11**********************@q2g2000cwa.googlegro ups.com...

日志传送是一个从主要的
SQL Server获取事务日志并应用它们的过程按顺序依次按
另一个SQL Server。


这对备份/恢复数据库有同样的作用吗？非常感谢

的任何解释。我不知道这一点。

Log shipping is a process that takes transaction logs from a primary
SQL Server and applies them sequentially on a scheduled basis to
another SQL Server.

Does this do same thing for Backup/Restore the database?? Thanks a lot
for any explaination. I do have no idea about that.

一般来说，由于时间的缘故，你不想做一个完整的备份/恢复。


有没有特别有理由你想要进行完全备份/恢复而不是

只需登录发货吗？

Generally you don''t want to do a full backup/restore due to the time.

Is there a specific reasony ou want to do a full backup/restore rather than
simply log-shipping?

>

>

>谷歌日志传送。

你真的只想对服务器B进行全面恢复，然后
交易
logbackup /恢复之后。

>Google log-shipping.

You really only want to do a ful restore to server B, and then
transaction
logbackup/restores after that.

这篇关于每小时备份和恢复数据库：如何实现？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！