Increase Datafile .mdf

• Junior_DBA

  SSCrazy

  Points: 2002

  More actions

  July 16, 2008 at 11:36 am

  #129926

  Hi All,

  I am running out of space with my Datafile .mdf, I don't have enough free space on my C:\Drive, how can I do to move files onto my D:\Drive....also is there any posibility to create a new Datafile??..can I do that when I get out of space?

  Please any help???

  Thanks

• Todd Engen

  SSCrazy Eights

  Points: 9869

  More actions

  July 16, 2008 at 12:15 pm

  #843987

  There are a few methods you could use: sp_detach_db/sp_attach_db, BACKUP/RESTORE or ALTER DATABASE.

  The steps to move the datafile using ALTER DATABASE would look something like this.

  1) ALTER DATABASE myDB SET OFFLINE

  2) Move MYDB.MDF to the D:\DATA\MYDB.MDF.

  3) ALTER DATABSE myDB MODIFY FILE (NAME = 'myDB', FILENAME = 'D:\data\mydb.mdf')

  4) ALTER DATABASE myDB SET ONLINE

• SrikanthSv

  Ten Centuries

  Points: 1197

  More actions

  July 18, 2008 at 5:42 am

  #844935

  Rightclick on the database..Select option to detach the database..

  move the file to D Drive

  Attach it back

  Regards
  Venkat
  http://sqlblogging.blogspot.com[/url]