How do I change the file path from C: drive to E:

• mw_sql_developer

  SSCoach

  Points: 19445

  More actions

  October 22, 2015 at 9:47 am

  #305796

  See attached

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  October 22, 2015 at 9:49 am

  #1834954

  ALTER DATABASE

  John

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  October 22, 2015 at 10:50 am

  #1834975

  mw112009 (10/22/2015)

  ---

  See attached

  Use the ALTER DATABASE ... MODIFY FILE statement. For help on this check BOL. Also see my guide at this link[/url]

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉