This morning, it was discovered that the objects for a new application had been installed in the master database instead of the user database, resulting in the master datafile growing to 4Gb.
I dropped all the user objects and then shrank the master database to a more reasonable size.
Unfortunately, running DBCC SHRINKFILE with the TRUNCATEONLY to not perform any page movement did not result in the data file shrinking, so I had to omit this option to shrink the file.
I am now concerned that the system tables could be highly fragmented, which might cause performance problems. But as system tables cannot be analyzed to determine fragmentation levels and indexes on system tables cannot be rebuilt, I have no way of determining if there could be a problem with fragmentation.
Any suggestions ?
SQL = Scarcely Qualifies as a Language