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 2005 Forums
 SQL Server Administration (2005)
 Expand DB in SQL Server 2005

Author  Topic 

MasterKen
Starting Member

1 Post

Posted - 2009-11-24 : 09:10:34
Hi All,

Just joined so hello to everyone..

I have just been asked to increase the size of our DB on our server running win2003 and SQL server 2005.

The DB was pre allocated it's size which is running out space hence the reason why it needs to be increased.

Many thanks inadvance

Ken

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-11-25 : 01:56:54
If you are in SSMS,

expand databases, right click on the database-->Properties-->Files

Now you can increase the data and log files

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -