Expand DB in SQL Server 2005

• ken.nessworthy

  Newbie

  Points: 8

  More actions

  November 24, 2009 at 7:03 am

  #135421

  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

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 24, 2009 at 8:04 am

  #1083471

  Get to know Books On Line (BOL) it is your friend. You expand databases using the ALTER DATABASE statement. Something like this:

  -- determine file name and current size

  SELECT

  [file_id],

  type_desc,

  [name],

  physical_name,

  state_desc,

  size,

  size * 8 / 1024.00 AS size_in_mb

  FROM

  sys.database_files AS DF

  -- resize

  ALTER DATABASE tempdb MODIFY FILE (NAME = 'TempDev', SIZE=150MB )

  for details go here which is the on-line BOL.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738713

  More actions

  November 24, 2009 at 8:10 am

  #1083474

  You can also do this with SSMS

  Here's a link: http://msdn.microsoft.com/en-us/library/ms175890%28SQL.90%29.aspx

• ken.nessworthy

  Newbie

  Points: 8

  More actions

  November 24, 2009 at 8:46 am

  #1083502

  Thanks Jack, seems an easy way to do it.

  Ken