Solved

restarting Warm StandBy for MS-SQL 2000

Posted on 2008-10-13
4
423 Views
Last Modified: 2010-04-21
I'm new to the DBA position and I need to restart the Warm StandBy setup. We did a DR drill recently and in order to get the Warm StandBy server up and running I restored the databases. Now I don't know how to get them back into the WS mode ?

I do know that we use a modified log shipping process to accommodate our requirements and constraints. It insert data into msdb..usp_logshipHst table on DR server based on the transaction dumps done at production database. An independent job running at DR server will pickup and apply the transaction logs systematically at DR site. Again the transaction dump is independent to either log shipping or log marking, so that we will always have transaction dumps, irrespective of adverse situations.
0
Comment
Question by:IDCSSupport
  • 2
  • 2
4 Comments
 
LVL 10

Expert Comment

by:TAB8
Comment Utility
You will want to Change the Database Recovery Mode


http://www.dbarecovery.com/changemode.html
0
 

Author Comment

by:IDCSSupport
Comment Utility
TAB8,

I'm not sure what you mean, the Recovery Model for these db's is Full ?

What other steps are needed to resart WS ?

Andy
0
 
LVL 10

Accepted Solution

by:
TAB8 earned 250 total points
Comment Utility
opps wrong link ....

http://www.devx.com/getHelpOn/10MinuteSolution/16503/1763/page/3

look at the NORECOVERY option for your database ...
0
 

Author Closing Comment

by:IDCSSupport
Comment Utility
thanks
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Selecting specific rows 3 33
how to fix this error 14 45
Help with SQL Query 23 39
t-sql month question 8 40
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now