November 7, 2015 at 4:42 am
I re-started the SQL Service.
I did numerous commands with no luck
.
Shrink DB, Shrink files and shrink DB.
I tried the GUI but it bombes out.
What can I do to resolve this issue?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 7, 2015 at 6:48 am
If you restarted the SQL Server service then that resets the tempdb to its initial size. If it didn't change, have you checked the initial size of tempdb? If it's at that point, then SQL is doing what it's being told to do.
November 7, 2015 at 1:37 pm
Follow https://support.microsoft.com/en-us/kb/307487
Another gotchya from it "A limitation of DBCC SHRINKFILE is that you cannot make the database smaller than the size of the model database."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply