Move sql 2005 to new box.

[joejack0330]

We'd like to take our SQL 2005 sp2 on Windows 2003 and move it to a new faster box. I did it a few times under 2000 and seemed to work well if everything was configured and installed in same location. Is it the same under 2005?

Thanks,
Joe

 

[mrdenny]

Yep.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[ptheriault]

I'm doing that right now for SQL 2k5 x64. I tested earlier this week on my VM servers without any problems. Even the db mirror restarted.


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ptheriault]

I migrated my server this weekend to newer hardware. The move went very smooth except for one issue. If your server runs on a local account and not a domain account you may run into a problem with the SMK (service master key).

Before you start your migration backup your SMK.
(You should backup this key anyway.)

[COLOR=blue]BACKUP[/color] SERVICE MASTER [COLOR=blue]KEY[/color] [COLOR=blue]TO[/color] [COLOR=blue]FILE[/color] = [COLOR=red]'path_to_file'[/color] 
    [COLOR=blue]ENCRYPTION[/color] [COLOR=blue]BY[/color] PASSWORD = [COLOR=red]'password'[/color]

Once your move is complete and you have started services check for the log file forthe following error.

Message
Error: 15466, Severity: 16, State: 1.
Message
An error occurred during decryption.

If you get this error restore the backup of the SMK. You can get the syntax from BOL, lookup Service Master Key.

Another work around is to force the SMK to regen.

ALTER SERVICE MASTER KEY FORCE REGENERATE

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[joejack0330]

Thanks for the info. We'll be trying this over the next few weeks.