I have problem with my sql server developer edition.
I began reciving alerts regarding disk space, and found out that the msdb files are 5 GB!!! the data file is full, so I cannot shrink it, but the table usage shows only a few MB used by tables.
its not advisable to shrink the system dbs except tempdb,but in your case just check if any user tables are created in msdb if so just delete the same to free diskspace.... then try shrinking msdb but b4 shrinking ensure you have the latest backup of all the dbs....|||
There are no user tables on this server.
It a local developer version, I use for development and small checks, there is no back up nither.
No comments:
Post a Comment