I am trying to move my overgrown transaction log from one drive to another.
-I can't get the shrink command to work.
DBCC SHRINKFILE(NAG_CDR_Audit_Log, 1)
I also tried to run the detach command
but I get the error: "Cannot detach the database 'Kit' because it is currently in use." even though I don't have any apps using it.