先完整备份
BACKUP DATABASE pubs
TO Disk='d:\test1.dat'
WITH INIT再增量备份
BACKUP DATABASE pubs
TO Disk='d:\test1.dat'
WITH DIFFERENTIAL查看到此备份文件的逻辑文件名
RESTORE FILELISTONLY FROM DISK = N'D:\TempBackUp\test1.bak'
查看到此备份文件的逻辑文件名:pubs,pubs_Log恢复:
restore database pubs
from disk=N'D:\TempBackUp\test1.bak'
WITH FILE = 2, REPLACE,NOUNLOAD , STATS = 10, RECOVERY ,
move 'pubs' to 'C:\Program Files\Microsoft SQL Server\MSSQL\data\pubs.mdf',
move 'pubs_Log' to 'C:\Program Files\Microsoft SQL Server\MSSQL\data\pubs_log.ldf'报错:
Server: Msg 3101, Level 16, State 1, Line 2
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.我重启SQL服务和重启机器都还是这样.
请问这是怎么回事,救命啊
BACKUP DATABASE pubs
TO Disk='d:\test1.dat'
WITH INIT再增量备份
BACKUP DATABASE pubs
TO Disk='d:\test1.dat'
WITH DIFFERENTIAL查看到此备份文件的逻辑文件名
RESTORE FILELISTONLY FROM DISK = N'D:\TempBackUp\test1.bak'
查看到此备份文件的逻辑文件名:pubs,pubs_Log恢复:
restore database pubs
from disk=N'D:\TempBackUp\test1.bak'
WITH FILE = 2, REPLACE,NOUNLOAD , STATS = 10, RECOVERY ,
move 'pubs' to 'C:\Program Files\Microsoft SQL Server\MSSQL\data\pubs.mdf',
move 'pubs_Log' to 'C:\Program Files\Microsoft SQL Server\MSSQL\data\pubs_log.ldf'报错:
Server: Msg 3101, Level 16, State 1, Line 2
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.我重启SQL服务和重启机器都还是这样.
请问这是怎么回事,救命啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货