locks preventing backup of database -- sql server (alternate)

ads4sms NO[at]SPAM yahoo.com
1/7/2004 4:59:30 PM

The database is configured for single publisher, many subscribers,
merge replication. The maintenance plan started to fail a couple of
months ago and the database would not get backed up. After clearing
all the locks, I am able to backup the database manually. The locks
return again and I'm not able to backup the database with the
maintenance plan. How can I get around the lock issue or solve it so
that I can backup the database again?

Thanks,

Greg D. Moore (Strider)
1/8/2004 4:37:26 AM

[quoted text, click to view]

How are you trying to back it up? I've never seen locks prevent a db
backup.

[quoted text, click to view]

sql server (alternate) : locks preventing backup of database