January 5, 2005 at 3:45 am
Dear Gurus
I am Dharmendra Back with some of the problems. Well the Questions is I Have a Primary Server and a Secondary Server where my Log Shipping is there. MY Procedures are taking care of transfering the the Backup and Log file from Primary Server to Secondary Server. ok But if some reason my Primary Server has failed due to some Hardware Problem. Then i have changed the IP address of My Secodary Server to the IP address of Primary Server. but there is one more command which i have to run to start the Secondary Server.
Any help would be greatly appreciated. Thanx in advance
Regds
Dharmendra
Thanks & Regards
Dharmendra S Mudaliar
( OEM India RSA )
Hello - +91 40 66934555 x 34555
Mobile - 9885408049 | IM - v-dharmu@microsoft.com
January 5, 2005 at 12:20 pm
You have to bring the database(s) out of standby mode and unless you have replicated the the master database you will need to rechain the SID for all db user accounts.
January 5, 2005 at 1:59 pm
If you change the server IP address and you are connecting using the server name also make sure that the DNS entries are updated accordingly.
January 6, 2005 at 1:28 am
Thanx Nicholas and dzwahlen
Thanx for ur reply. I have restored the master database to the secondary server. But wht abt the Server Name which i am using to connect the SQL SERVER. Do i need to change it. Or what to do with it.
Pls help me out. Thanx for help
Regds
Dharmendra
Thanks & Regards
Dharmendra S Mudaliar
( OEM India RSA )
Hello - +91 40 66934555 x 34555
Mobile - 9885408049 | IM - v-dharmu@microsoft.com
January 6, 2005 at 5:57 am
If you have restored the master database from another server you will need to make sure that it knows that it's on a different machine, run
sp_dropserver <old_name>
go
sp_addserver <new_name>, 'local'
go
unless of course the machine that you restored the database on has the same name as the original server.
January 8, 2005 at 12:16 am
Thanx Nicholas Cain
That helped me out. It worked fine and at last I restored my Master database from Primary Server to Secondary Server and droped the existing name of the server and added the new name by using system Procedures. Thats what i wanted.
Thanx for it
Regds
Dharmendra
Thanks & Regards
Dharmendra S Mudaliar
( OEM India RSA )
Hello - +91 40 66934555 x 34555
Mobile - 9885408049 | IM - v-dharmu@microsoft.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply