還原DB資料

Discussion:

還原DB資料

(时间太久无法回复)

smokehouse

2007-03-04 10:58:05 UTC

您好

有件事情想請問大家
我的SQL2000有設定備份
備份方式如下
每週日完備份成*.BAK
每週一到五差異備份 *.TRN

假如我的機器毀損
我要還原星期四
基本上我是先還原BAK檔後
在逐一還原一到四的交易紀錄檔

想請問該怎還原呢?
謝謝您

Cloud

2007-03-04 18:05:38 UTC

Permalink

Do you perform diff backup or log backup during weekdays? If do log backup,
you need restore the db as you said. If do diff backup, need restore from
Sunday's full backup then latest diff backup.

Post by smokehouse
您好
有件事情想請問大家
我的SQL2000有設定備份
備份方式如下
每週日完備份成*.BAK
每週一到五差異備份 *.TRN
假如我的機器毀損
我要還原星期四
基本上我是先還原BAK檔後
在逐一還原一到四的交易紀錄檔
想請問該怎還原呢?
謝謝您
Cloud

smokehouse

2007-03-05 02:49:08 UTC

Permalink

您好

我確實在每周日製作db backup 每周一二三四五製作log diff backup
今天我還原db backup後然後再利用逐一還原log diff backup

首先我利用sqlmanager直接還原.bak檔
然後在利用語法如下
restore log mydb
from disk='D:\xxx1.trn'
with norecovery

restore log mydb
from disk='D:\xxx2.trn'
with norecovery

restore log mydb
from disk='D:\xxx3.trn'
with norecovery

restore log mydb
from disk='D:\xxx1.trn'
with recovery

但是似乎不行?
是因為一開始使用sqlmanager直接還原的關係嗎?

"RM" 來函：

Post by RM
Do you perform diff backup or log backup during weekdays? If do log backup,
you need restore the db as you said. If do diff backup, need restore from
Sunday's full backup then latest diff backup.

2007-03-05 15:02:31 UTC

Permalink

Lotg backup is different from diff backup, there is no log diff backup in sql
server.

Post by smokehouse
您好
我確實在每周日製作db backup 每周一二三四五製作log diff backup
今天我還原db backup後然後再利用逐一還原log diff backup
首先我利用sqlmanager直接還原.bak檔
然後在利用語法如下
restore log mydb
from disk='D:\xxx1.trn'
with norecovery
restore log mydb
from disk='D:\xxx2.trn'
with norecovery
restore log mydb
from disk='D:\xxx3.trn'
with norecovery
restore log mydb
from disk='D:\xxx1.trn'
with recovery
但是似乎不行?
是因為一開始使用sqlmanager直接還原的關係嗎?
"RM" 來函：