Hello

I'm trying to setup a LOG SHIPPING option in MS SQL 2000 Enterprise Edition
and while I'm doing that I end up with following error

Error 14261: The specified primary_server_name.primary_database_name ('(')
already exists.

I even found this

http://support.microsoft.com/default...NoWebContent=1

that supposedly it explains that this is a bug and gives work around, which
I do and it doesn't return me any errors while I'm doing that but when i
re-run maintaince wizard I still end up on same error as I had before.

can someone help me?

Thanks in advance

Hello,

It appears that the manual log shipping cleanup was not successfull. Can
you give detail steps that you took to run the stored procs in the KB. Pl.
write the exact syntax and parameters that you used and the server that you
ran the command against.

Also, check if there are any logshipping jobs that needs to be cleaned up ?

Regards,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

I went to

http://support.microsoft.com/default...NoWebContent=1

and i ran

exec sp_delete_log_shipping_primary
@primary_server_name='db2c',
@primary_database_name='test'
exec sp_delete_log_shipping_secondary@secondary_server_ name =
'db2d',@secondary_database_name = 't'exec
msdb.dbo.sp_remove_log_shipping_monitorand i re-run wizard, and I end up at
the same thingError 14261: The specified
primary_server_name.primary_database_name ('(') already exists.Please
advise, Thanks in advance.
"Uttam Parui[MS]" <uttamkp (AT) online (DOT) microsoft.com> wrote

If there is no log-shipping set then you should not have any rows in the
following tables :

log_shipping_primary
log_shipping_secondaries
log_shipping_monitor

These tables are in the msdb database.

If you have some rows in the tables then it means that information about
logshipping is still there and it needs to be cleaned using the stored
procs in the KB 298743

Ex. To make sure that there are no rows in log_shipping_primary, I will run
"select * from msdb..log_shipping_primary"

Say, it returns a row with primary server name "xyz" and primary db name
"testdb" then I will run

EXEC sp_delete_log_shipping_primary @primary_server_name = N'xyz',
@primary_database_name = N'testdb'

Then I will run "select * from msdb..log_shipping_primary" and make sure
that row is deleted.

Similarly, I will proceed with the other tables.

HTH,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.