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 |
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
 Posted - 2009-05-05 : 13:55:10
|
| I have removed replication publication from a database but the sys.databases.log_resue_wait_desc is showing that the log file is still waiting on replication. I verified that the two subscribers also had the publication removed. How can I rectify the status on this database?Many thanks.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-05-06 : 09:58:39
|
| Create a publication in that DB. Remove the publication. That usually fixes things.--Gail ShawSQL Server MVP |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-05-06 : 12:34:07
|
| Exactly right. Thank-you.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
|
|
|
|
|
|
No Replication But Log File Pending on Replication