This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 求助,MS. SQL SERVER 的增量恢复：我的头嫌数据库在磁盘上的full backup file 浪费空间，决定采用shutdown SERVER +copy data files to SNA. 每两周一次． 由于没有了full backup file, 请问我还能每天对数据库做增量differential 备份和恢复吗?
-findinghouse(不写错别字。10);
2005-1-24
{52}
(#2091747@0)
-
No.
-yangn(Raymond);
2005-1-25
(#2092869@0)
-
谢! 刚查到我们应该用SNA的BACKUP DRIVER FOR SQL SERVER把数据库直接备份到SNA上,而不是甩开SQLSERVER单干. 其实这是道挺好的面试题.FROM BOOKS ONLINE:
The sequence for restoring differential database backups is:
1.Restore the most recent database backup.
2.Restore the last differential database backup.
-findinghouse(不写错别字。10);
2005-1-25
{177}
(#2093282@0)