SQL2000: Issue on Restoring - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL2000: Issue on Restoring

Author

Topic

dewacorp.alliances

452 Posts

Posted - 2006-08-20 : 17:29:46

Hi there

I need help on trouble shooting of my restore database task. I am using SQL2000.

I have two servers one is PRODUCTION and the other one is STANDYBY. I run a TSQL job from PRODUCTION server to do a local backup and a restore a remote database.

In the log of the restore it said: RESTORE DATABASE successfully procesed xxx pages in xxx seconds.

But when I went to the STANDYBY server, the database is still in LOADING mode.

What is wrong with this?

I'm appreciated your help.

Thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-20 : 17:44:39

this is normal.

I suggest you read up on log shipping to get a better idea of what it is doing. Basically, the standby system stays in read-only or no-recovery mode (like yours is) until you perform a failover and make the standby the primary system.

Check BOL for details on log shipping, or google on those terms and you should find dozens of articles.

-ec

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-08-20 : 17:53:12

It sounds you used the NORECOVERY option instead of the STANDBY option when you restored the database to the standby server.

using NORECOVERY, it should be in loading state
using STANDBY, it should be in read-only state

To recover the database use;
RESTORE DATABASE xxx WITH RECOVERY

rockmoose

dewacorp.alliances

452 Posts

Posted - 2006-08-20 : 18:01:17

Thanks. Actually you right I did put a WITH NORECOVERY on restore database.

If this already happen, is there anyway to set the status back to normal mode again?

Thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-20 : 20:20:00

quote:
Originally posted by valdyv

Thanks. Actually you right I did put a WITH NORECOVERY on restore database.

If this already happen, is there anyway to set the status back to normal mode again?

Thanks

this is answered in the other thread you started.

http://sqlteam.com/forums/topic.asp?TOPIC_ID=70761

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources