July 10, 2012 at 5:17 am
I created the primary file with 100 GB with no growth.Now how I can change the size of file?
Best regards
July 10, 2012 at 5:48 am
That depends.
Do you want to shrink or grow the file?
Is there any data in it?
Assuming the database is empty and the space allocation was a mistake, go to propertries of the database and under 'files', change the 'initial size' to the smaller size required.
BUT!!!!!
a) the space must be available.
b) any data may get fragmented so you may need to run a cleanup.
HTH.
Adam Zacks-------------------------------------------Be Nice, Or Leave
July 10, 2012 at 5:52 am
I'm assuming that you want to increase the file's size. You can do it with Alter database statement. You can read about it and see an example in this url – http://msdn.microsoft.com/en-us/library/bb522469.aspx%5B/URL%5D.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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/
July 11, 2012 at 11:11 am
Hi
Thanks a lot. Actually it has data and I wanted to decrease the size. So shrink worked nicely.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply