Solved

Putting database from normal to standby

Posted on 2008-10-17
3
298 Views
Last Modified: 2012-05-05
This is Primary - standby configuration

when the database was in standby in Management Studio DBNAME(standby)

performed recover database <database name > with recovery

Now is it possible put it back on standby. If so can anyone give a T-SQL

Thanks
0
Comment
Question by:Greens8301
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
PIERCGG earned 500 total points
ID: 22744113
The ONLY way I know to place the database in standby mode to do it as part of the restore.  You must do the RESTORE WITH STANDBY option when you restore the database; not after the database is already restored.
0
 

Author Comment

by:Greens8301
ID: 22744270
The primary is being accessed by users. Therefore it not switched over

In oracle , we can put the STANDBY database on Managed Recovery mode and take it off from Managed recovery mode.

Is there a way to find what mode is the database ON and switch to standby mode

Thanks
0
 

Author Closing Comment

by:Greens8301
ID: 31507230
Thanks.
These questions for my own theoretical knowledge.
The actual command are typed another dba
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
how many extra RAM for SQL server is needed 23 49
Why is the output of this function is like this? 4 47
Caste datetime 2 73
Database maintenance 36 140
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

739 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