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.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2009-02-26 : 07:02:52
|
| Dear All,in a log shipping environment, in sql server 2005, if primary database fails, then how can we make the stand by server as production server?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-02-26 : 07:23:06
|
| [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx[/url][url]http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx[/url][url]http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1309728,00.html[/url] |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-26 : 09:06:36
|
quote:
Originally posted by sunsanvin
Dear All,in a log shipping environment, in sql server 2005, if primary database fails, then how can we make the stand by server as production server?ArnavEven you learn 1%, Learn it with 100% confidence.
Disable Log shipping jobs and Restore last Log backup in Recovery Mode in Secondary Server.Point your apps in New Server. |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-02-26 : 13:38:57
|
quote:
Originally posted by sunsanvin
Dear All,in a log shipping environment, in sql server 2005, if primary database fails, then how can we make the stand by server as production server?ArnavEven you learn 1%, Learn it with 100% confidence.
also make sure that u transfer ur logins and jobs on the secondary sever..Regards,Ahmad Osama |
|
|
|
|
|
|
|
|
how to do the fail over in log shipping?