USE [master]
GO
ALTER DATABASE [model] MODIFY FILE ( NAME = N'modeldev', SIZE = 5242880KB )
GO
Before restart SQL instance, I have sized tempdb datafiles size to 512 MB
Then I restarted SQL instance and agent. It takes a while to connect to SQL server via SSMS.
Tempdb.mdf file is recreated with 5 Gbs which takes on Model database initial size.
According to MS KB, tempdb should not take on Modeldb.
https://support.microsoft.com/en-us/kb/307487
No comments:
Post a Comment