Migrating all MS SQL Server Databases

• Niyala

  SSCrazy

  Points: 2778

  More actions

  January 25, 2012 at 3:09 am

  #250199

  Hello everyone,

  I am using MS SQL Server 2005 Standard Edition.

  I am planning to move the entire datases to a new partition. I could move the user databases using detach and attach method. However, I could not figure out a method to move all system databases.

  I would be very gratefull if anyone can give me a clue on how to move system databaes to a new partion.

  Many thanks in advance.

  Kind regards

  Niyala

• umasingh

  Ten Centuries

  Points: 1182

  More actions

  January 25, 2012 at 3:54 am

  #1438157

  no need to move system databases. is there any specific requirement? you can script out the logins , permissions and Sql jobs and deploy it to your new partition.

  Please check this article for migration strategy:

  http://www.sqlservercentral.com/articles/Upgrade/65872/

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  January 25, 2012 at 4:22 am

  #1438159

  no need to move system databases. is there any specific requirement? you can script out the logins , permissions and Sql jobs and deploy it to your new partition.

  Please check this article for migration strategy:

  http://www.sqlservercentral.com/articles/Upgrade/65872/

  That article is about upgrading to a new version of SQL Server, not moving databases.

  I would be very gratefull if anyone can give me a clue on how to move system databaes to a new partion.

  I typed "sql server move system databases" into my favourite search engine and the top result was exactly what I needed. You could try the same.

  John

• Lowell

  SSC Guru

  Points: 323518

  More actions

  January 25, 2012 at 6:02 am

  #1438184

  oops wrong post sorry.

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Summer90

  SSC-Dedicated

  Points: 32891

  More actions

  January 26, 2012 at 5:37 am

  #1438706

  You cannot 'move' master, msdb from SQL2005 to 2008 at all. You will have to script everything out and re-create them in the new SQL2008.