Viewing 5 posts - 1 through 6 (of 6 total)
I was able to remove the replication using the SP sp_removedbreplication and it did drop down the size of the ldf file but I'm still curious to know what might...
December 24, 2012 at 8:52 am
Ok, based on the queries suggested in the article, I do not see any replication tasks or CDC going on in my DB. The article says that on a 2005...
December 21, 2012 at 3:28 pm
CDC is not enabled on this db. Verified using the following query:
SELECT [name], database_id, is_cdc_enabled
FROM sys.databases
December 21, 2012 at 3:15 pm
I'm dont think there were any snapshot replications that were done on this db but I did run the following query:
SELECT name, recovery_model_desc, log_reuse_wait_desc
FROM sys.databases
and the...
December 21, 2012 at 2:08 pm
Forgot to mention that the size of MDF is just around 2GB and also this seems to be taking up a lot of space on the data drive.
December 21, 2012 at 1:47 pm
Viewing 5 posts - 1 through 6 (of 6 total)