回滚日志的sql是否为: restore database service from disk='e:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\service.dat' with norecovery restore log service from disk='e:\Program Files\Microsoft SQL Server\MSSQL\backup\service.dat' with recovery,stopat='july 26, 2005 12:00 am'?
F. 使用 STOPAT 语法还原到即时点和使用多个设备进行还原 下例将数据库还原到其在 1998 年 4 月 15 日中午 12 点时的状态,并显示涉及多个日志和多个备份设备的还原操作。RESTORE DATABASE MyNwind FROM MyNwind_1, MyNwind_2 WITH NORECOVERY RESTORE LOG MyNwind FROM MyNwindLog1 WITH NORECOVERY RESTORE LOG MyNwind FROM MyNwindLog2 WITH RECOVERY, STOPAT = 'Apr 15, 1998 12:00 AM'
谢谢,我先试下,马上结 但是还有些不清楚这几句话的意思 RESTORE DATABASE MyNwind FROM MyNwind_1, MyNwind_2 WITH NORECOVERY//为什么要 FROM MyNwind_1, MyNwind_2? RESTORE LOG MyNwind FROM MyNwindLog1 WITH NORECOVERY RESTORE LOG MyNwind FROM MyNwindLog2 WITH RECOVERY, STOPAT = 'Apr 15, 1998 12:00 AM'//"Apr 15, 1998 12:00 AM"这个可以写成"2005-01-01 12:00"的格式吗?
restore database service from disk='e:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\service.dat' with norecovery restore log service from disk='e:\Program Files\Microsoft SQL Server\MSSQL\backup\service.dat' with recovery,stopat='july 26, 2005 12:00 am'?
下例将数据库还原到其在 1998 年 4 月 15 日中午 12 点时的状态,并显示涉及多个日志和多个备份设备的还原操作。RESTORE DATABASE MyNwind
FROM MyNwind_1, MyNwind_2
WITH NORECOVERY
RESTORE LOG MyNwind
FROM MyNwindLog1
WITH NORECOVERY
RESTORE LOG MyNwind
FROM MyNwindLog2
WITH RECOVERY, STOPAT = 'Apr 15, 1998 12:00 AM'
但是还有些不清楚这几句话的意思
RESTORE DATABASE MyNwind
FROM MyNwind_1, MyNwind_2
WITH NORECOVERY//为什么要 FROM MyNwind_1, MyNwind_2?
RESTORE LOG MyNwind
FROM MyNwindLog1
WITH NORECOVERY
RESTORE LOG MyNwind
FROM MyNwindLog2
WITH RECOVERY, STOPAT = 'Apr 15, 1998 12:00 AM'//"Apr 15, 1998 12:00 AM"这个可以写成"2005-01-01 12:00"的格式吗?