SQL Server Performance Forum – Threads Archive
Restoring a Standby Database
We had a standby database on one of our SQL Server and we changed the name of the NT box where the Standby database was residing. After changing the name and running the sp_dropserver and sp_addserver ‘new name’,’Local’, we tried to restore the standby database and we ran the command ‘restore database ..with Recovery’ and this is what we are getting: Location: warmstan.cpp:547Expression: IS_ON (DBT_INLDDB, m_dbt->dbt_stat)
SPID: 51
Process ID: 2496 Connection Broken
Any Help ?
Check are there any other messages logged in ERROR LOG, as this doesn’t gives much information to assess.
Check SQL error log thoroughly., _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>