Move .mdb from clustered o/s to non-clustered o/s

• andyskead

  SSC Journeyman

  Points: 78

  More actions

  February 26, 2007 at 12:45 pm

  #68281

  Hi all,

  Looking at method for moving clustered .mdb/.ldf to non clustered O/S. (don't ask... moving datacenter) I assume we can just use sp_detach/sp_attach method to new server without issue? Ran initial test - appears ok, just want to be sure I'm not missing anything. Thanks.

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  February 26, 2007 at 3:43 pm

  #691911

  clustering has no effect on moving databases about. Check out KB224071  for moving system databases.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/