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 |
chris_wood99
Yak Posting Veteran
70 Posts |
Posted - 2005-07-29 : 12:04:14
|
After I have been through the configuration of log shipping and the process starts I am receiving the error 'unable to copy initialization file to the secondary server '<servername>'. I have configured the log shipping to set up a new database on the secondary server.Then if i try something different and run it again i get :'error 14261 - the specified primary_server_name.primary_database_name ('M') already exists' Does anyone know the table to delete this record? |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-29 : 14:58:01
|
Yes. Delete the rows in the msdb.dbo.log_shipping* tables on both servers. If you still run into the unable to copy initialization file problem, then you can setup the database on the secondary server manually by using RESTORE DATABASE with an undo file. Then in the log shipping setup, you tell it that the database already exists.Tara |
|
|
|
|
|