Moving DB to new drive

• water490

  SSC Eights!

  Points: 967

  More actions

  December 17, 2024 at 7:25 pm

  Go to Answer

  #4499771

  Hi everyone

  I am planning on buying a new SSD to store my SS DB.  I plan to leave the actual SS on the old drive and just move the DB to the new drive.  I found the steps to do this online:

  https://learn.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases?view=sql-server-ver16

  I have a few questions:

  1. Should I move the SS to the new drive too?  Both the new and old drives are NVME SSD so in terms of speed both are comparable.
  2. I have SSIS package that calls and updates the DB.  Do I need to make any changes to the SSIS package if only the DB is moved to the new drive?

  Thank you

• ScottPletcher

  SSC Guru

  Points: 101117

  More actions

  December 17, 2024 at 7:34 pm

  Answer

  #4499775

  1. No
  2. No

  And, that is the correct method for moving dbs to a new drive.

  SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

• water490

  SSC Eights!

  Points: 967

  More actions

  December 17, 2024 at 7:37 pm

  #4499776

  ScottPletcher wrote:

  1. No
  2. No

  And, that is the correct method for moving dbs to a new drive.

  Thank you for the prompt reply.