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.
| Author |
Topic |
|
ashish_smu
Starting Member
5 Posts |
 Posted - 2011-05-12 : 07:06:12
|
| Under secondary database setting after providing all the entries on 1)Initialize secondary databse2)Copy files3)Restore Transaction Logs.I am clicking on OK and getting the following errorDatabase [servername.DBname] is already a secondary databse for this log shipping configuration.Please HelpRegards,Ashish |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-05-12 : 07:17:35
|
| Ok are you configuring log shipping on same InstanceIn Love... With Me! |
 |
|
|
ashish_smu
Starting Member
5 Posts |
Posted - 2011-05-12 : 07:19:24
|
| No, on different servers |
|
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-05-12 : 07:36:49
|
| Ok then may be your database already configured for some other instance Logshipping.Check using this SPsp_help_log_shipping_secondary_database 'Database_Name'In Love... With Me! |
|
|
|
ashish_smu
Starting Member
5 Posts |
Posted - 2011-05-12 : 07:55:28
|
| Hello,Thanks for your reply. There is no other logshipping. I also tried running the SP provided by you. It is not returning anything.Regards,Ashish |
|
|
|
ashish_smu
Starting Member
5 Posts |
Posted - 2011-05-12 : 07:56:58
|
| I think, I might have missing any setting or something:-(regardsAshish |
|
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
|
|
ashish_smu
Starting Member
5 Posts |
Posted - 2011-05-13 : 01:59:20
|
| Thank you for your help, its working fine now. I just did all the configurations again and also followed the link provided by you.Thanks again,Ashish |
|
|
|
|
|
|
Please Help on LogShipping