Restoring a Standby Database | SQL Server Performance Forums

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:547
Expression: 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