December 14, 2009 at 3:06 pm
When alter the data file size for example;
USE [master]
GO
ALTER DATABASE [your database name] MODIFY FILE ( NAME = N'Databasefile_data', FILEGROWTH = 512000KB )
GO
Does the sql services needs to be restarted in order to take the effect?
December 14, 2009 at 3:09 pm
hydbadrose (12/14/2009)
Does the sql services needs to be restarted in order to take the effect?
NO! SQL Server does not need to restart.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2009 at 3:09 pm
No.
December 14, 2009 at 3:11 pm
Thanks
December 14, 2009 at 3:14 pm
Welcome!
Are you from Hydbad?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply