How bring STAND BY to ACTIVE - 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

General SQL Server Forums

New to SQL Server Programming

How bring STAND BY to ACTIVE

Author

Topic

saivyshnav
Starting Member

17 Posts

Posted - 2006-07-15 : 14:20:29

Hi all

My management ask me use logshipping in the part of Disaster Recovery plan,as per i know i have put target database in STAND BY mode in logshipping
if ACTIVE MODE fail's how can i bring back the logshipped DB to active

Thanks in Advance
saivyshnav

saivyshnav
Junior DBA

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-15 : 14:37:35

just restore with recovery.
Then you will have to point all the users to the new server and make sure that everytything non-database related is there (logins, jobs, connectivity ...) but I assume you have already planned for that.

Why are management telling you to use log shipping? Do they know what they are talking about? Sounds like they are defining the BCP in detail so will already have considered these things.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

saivyshnav
Starting Member

17 Posts

Posted - 2006-07-15 : 15:14:46

Thanks nr

that means ALTER DATABASE <DB NAME> RESTORE WITH RECOVERY is it

Here thing is I have to submit Disaster Recivery plans,Plan Cost , and Down time and to do test

as i know

Recovery plnans
1.Backups(Full backup,Diff back ups,Transactional Back)
2.Replication(Transaction Reploication,Snap shot,Merged)
3.Logshipping
5.Moveing .MDF and .LDF 's

But i worked up Backups and Transaction Replication i don't about other methodes like Logshipping,moving data files

Can you explian real time scenario please

saivyshnav
Junior DBA

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-15 : 15:20:23

Norestore database mydb with recovery

Have a look at
http://www.nigelrivett.net/SQLAdmin/LogShipping.html

Bit confused - you are defining the DR plan but they are telling you it has to include log shipping? Sounds like you should be asking why.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

saivyshnav
Starting Member

17 Posts

Posted - 2006-07-15 : 16:30:20

Hi nr
Thanks very much

Iam working in product based company,earler our product was developed for Oracle,now they want that same product into ms-sql server,before starting dev/modification prodcuct,DBA people suppose to show how and what ways we save data what are the advantages of ms-sql server. for that i need all this things

saivyshnav
Junior DBA

sponguru_dba
Yak Posting Veteran

93 Posts

Posted - 2006-07-17 : 02:50:24

Hi savyshnav
what nr says is coreect

RESTORE DATABASE <DB NAME> WITH RECOVERY

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-17 : 04:08:14

you need to reverse the role if you are going to use the logshipping feature of sqlserver: read 'log shipping, role changes' in books online

--------------------
keeping it simple...

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-17 : 04:56:12

Oops

quote:
Originally posted by jen

you need to reverse the role if you are going to use the logshipping feature of sqlserver: read 'log shipping, role changes' in books online

--------------------
keeping it simple...

That's only if you are using the microsoft log shipping (which I don't recommend) and only if you want the other server now to become the standby.
Often the two servers are not identical and when the old one is fixed it becomes the production server again.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-17 : 05:31:58

ok twilight zone feeling... did i post that?