How to move tables, indexes & Logs from one disk to another disk drive

• d.qureshi

  Mr or Mrs. 500

  Points: 536

  More actions

  September 15, 2010 at 6:48 am

  #227783

  Hello,

  I am new to SQL Server so would greatly appreciate any help.

  I am running SQL Server 2008 on my machine, can anyone explain a step by step procedure to move tables, indexes and transactions logs from one disk drive to another disk drive.

  This is to avoid taking down SQL Server on my machine.

  Thank you.

  Danesh

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  September 15, 2010 at 7:10 am

  #1221300

  Please don't cross post. It just wastes peoples time and fragments replies.

  No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic986215-357-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass