April 7, 2009 at 2:38 am
Hi,
we have primary server and standby server, the primary server has failed,how to bring the standby server online as primary server manually,
Is there any command to bring the standby server to primary?
Regards
koteswarrao.y
April 7, 2009 at 2:51 am
It would really help if you would tell us what technology you use for updatig your standby server.
Is it logshipping? Then restore the last backup using the RECOVERY option.
Is it mirroring? Then it depends on the way mirroring is configured. Do a ALTER DATABASE either with FAILOVER or FORCE_SERVICE_ALLOW_DATALOSS option.
[font="Verdana"]Markus Bohse[/font]
April 7, 2009 at 2:55 am
incidentally, if it is log shipping and you dont have any further backups to restore but want to bring online simply issue
RESTORE DATABASE [mydatabase] WITH RECOVERY
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2009 at 3:07 am
Hi,
I assume you are using log shipping?
Hope this helps!
Phillip Cox
April 8, 2009 at 5:02 am
Yes we are using log shipping
Thanks
Koteswar Rao.Y
April 8, 2009 at 5:07 am
y.koteswarrao (4/8/2009)
Yes we are using log shippingThanks
Koteswar Rao.Y
in that case the posts above by Markus and myself are sufficient enough to help you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply