My ERP production database went down over the weekend. The cause is because of the drive that holds my DB is out of space.
After investigating, I found that my log files have grown from 600mb a piece to 100 gigs each (qty 2).
I have followed all the correct steps to shrink my database but i cannot.
after some further investigation i found out that the cause is because
'log_reuse_wait_desc = replication,'
WE HAVE NO REPLICATION on this server.
One of the steps i read i should take is to enable a replication publication and then delete it, (http://www.sqlservercentral.com/Forums/Topic695034-357-1.aspx
but, the problem is that I cannot create a publication, when i try, i get an error message saying
"Invalid object name: dbo.syspublications"