Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
I have filled the model database's log and now SQL won't start with a 1105 error - what can I do?
Neil Pike
September 28, 1999
1 Min Read
A. This is because tempdb gets created with model's attributes at SQL startup. To overcome this :-
1. Start SQL Server with the -T3607 trace flag. See the books online for how to do this.
2. Login to SQL Server as sa with ISQL or ISQLW.
3. Do a DUMP TRANSACTION model WITH NO_LOG
4. Stop SQL Server
5. Remove the trace-flag
You should now be able to restart SQL again.
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)