Increase file space - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Increase file space

Author

Topic

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2012-03-19 : 10:10:13

How to increase the primary data file and log file space which is showing less 10 percent.

Thansk for your help

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-19 : 12:22:35

What are they set to now? Have you run out of space on the drive? Or do you want to increase the file size?

Do you have Autogrowth set on? To a set size or unrestricted growth?

Try this?

ALTER DATABASE [<dbname>] MODIFY FILE ( NAME = N'<dbname>', SIZE = 5120KB )
GO

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources