Log Shipping to another instance on the same server w/2005

Question

Log Shipping to another instance on the same server w/2005

John Najarian-387971

SSC Enthusiast

Points: 173
More actions
June 27, 2007 at 12:56 pm

#173128

I have implemented log shipping to different servers in 2000 and 2005. I tried to implement log shipping from 1 instance to another but on the same server. I've read this is possible but I haven't been able to do it. It keeps failing on the restore to the secondary instance.
Any help would be appreciated. Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

philcart SSC-Forever Points: 47794 More actions · Answer 1

John, what errors are you receiving. I've setup log shipping to both a second instance and a different database on the same instance.

--------------------
Colt 45 - the original point and click interface

Deepak-405225 SSCertifiable Points: 6120 More actions · Answer 2

Hi John,

Refer the below link,seems to be similar jus revert back if you need any help..........cool

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=376461

[font="Verdana"]- Deepak[/font]

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

John,

Could you please post the error for the same.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

John Najarian-387971 SSC Enthusiast Points: 173 More actions · Answer 4

Hi Sugesh, Phil and Deepak,

I'm new to posting here and put this under the 2000/7 and not 2005 Administration. I will look over the thread in 2005 and get back to you. BTW: This is running on XP Pro if that matters. Thanks for all the help.

John Najarian-387971 SSC Enthusiast Points: 173 More actions · Answer 5

I found out the problem. I first did this by backing up the database and restoring it to the Secondary instance THEN going to set up log shipping. You're supposed to be able to do this.

It tried norecovery, not standby state as before and it worked.

So I blew away the database and used log shipping gui to start this up from scratch and it worked in standby. No permission or user changes.

One warning though, with standby mode if it isn't set to log off connections during the restores, if there are any other connections the restore will fail.