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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-07-15 : 10:36:17
|
| Bryan writes "HiI was wondering if anybody had seen this problem before. I have two Windows 2000 machines both running SQL 2000 Enterprise Edition with SP3.I am trying to log ship 4 Databases from the primary to the secandary. The Databases that I want the logs shipped to on the secandary server are databses with different names than those of the primary.I do a restore on the secansry server using a WITH MOVE and REPLACE as well as a STANDBY, the DB restore works fine.When I try set up the log shipping though and get to the select target DB I can not select my newley created DB if I select the allow database to assume primary role, it defaults the Database Name back to what the database is called on the primary server and greys the drop down box out disallowing me to change my selection.I have tried to select the create new DB option and typed in a different name there and as soon as I select the primary role check box same thing happens.Weird thing is, that I have had this working before between 2 DB's with different names and really am at a loss as to why it wont let me do it now. All the documentation I can see at the moment really skip over this step making it out to be a straight forward step.Any ideas or help would be most appreciated.RegardsBryan." |
|
|
MuadDBA
628 Posts |
Posted - 2004-07-15 : 11:11:15
|
| If you tell it to assume the role of primary, I can see why that would cause you problems, because it would try to take over functionality of the primary database, which has a different name.I recommend you set up the process using your own stored procedures (check Tara's blog or the script library or search on log shipping) to do this. It will help you learn a heck of a lot more about what's going on, about the commands you are using, and allow you to do what you want to do instead of what the software THINKS you want to do. |
 |
|
|
|
|
|
Log Shipping