今天恢復(fù)某個(gè)數(shù)據(jù)庫時(shí)出現(xiàn)如下的錯(cuò)誤:

Msg 208, Level 16, State 1, PRocedure sp_MSrestoredbreplication, Line 72Invalid object name 'master.dbo.MSreplication_options'.Msg 3165, Level 16, State 1, Line 1Database 'MYDBNAME' was restored, however an error was encountered while replication was being restored/removed. The database has been left offline. See the topic MSSQL_ENG003165 in SQL Server Books Online.Msg 3167, Level 16, State 1, Line 1RESTORE could not start database 'MYDBNAME'.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.

恢復(fù)的數(shù)據(jù)庫此時(shí)處于脫機(jī)狀態(tài)

---------------------------------------------------------------------------------------------------------------

聯(lián)機(jī)叢書搜索MSSQL_ENG003165

找到如下解決方案：

1. 執(zhí)行 ALTER DATABASE 以使數(shù)據(jù)庫聯(lián)機(jī)；例如：ALTER DATABASE AdventureWorks SET ONLINE。 有關(guān)詳細(xì)信息，請(qǐng)參閱 ALTER DATABASE (Transact-SQL)。 如果要保留復(fù)制設(shè)置，請(qǐng)轉(zhuǎn)到步驟 2。 否則，轉(zhuǎn)到步驟 3。

2. 執(zhí)行 sp_restoredbreplication (Transact-SQL)。 如果此存儲(chǔ)過程成功執(zhí)行，則還原完成。 如果此存儲(chǔ)過程未成功執(zhí)行，請(qǐng)轉(zhuǎn)到步驟 3。

3. 執(zhí)行 sp_removedbreplication (Transact-SQL) 以刪除所有復(fù)制設(shè)置。 如果需要，請(qǐng)重新配置復(fù)制。 如果您根據(jù)建議將復(fù)制拓?fù)渚帉懥四_本，請(qǐng)使用腳本來重新配置該拓?fù)洹?

我執(zhí)行到第2步的時(shí)候成功刪除復(fù)制設(shè)置了，腳本如下：

ALTER  DATABASE MYDBNAME SET ONLINE USE MASTER DECLARE @srv_orig AS sysname = 'MYINSNAME' DECLARE @db_orig AS sysname ='MYDBNAME' EXEC sp_restoredbreplication @srv_orig,@db_orig ALTER DATABASE MYDBNAME SET MULTI_USER;