I've been phasing a problem with my SQL Server for the last 4 months.
The transaction logs of all of my databases keep expanding enormously.
Right now one of my T-LOG files is 30 Giga and its just a small site with a few users
every day. I'm wondering what I'm I doing wrong or if I misconfigured something.
I'm trying to shrink my transaction log files using the following command, but I'm getting errors:
DBCC SHRINKFILE (dbxxx_Log, 1000);
Here are the errors:
Msg 8985, Level 16, State 1, Line 1
Could not locate file 'dbxxx_Log' for database 'dbxxx' in sys.database_files. The file either does not exist, or was dropped.
I'm sure that the particular transaction log name is the one used by the database.