question

prem 1 avatar image
prem 1 asked

Migrating multiple data bases

how can we migrate multiple databases of server 2000 to server 2005 spread across various servers in single shot. asked in an interview

databasemigration
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Say thanks to the interviewer, then walk away :)
1 Like 1 ·
define 'a single shot'......
0 Likes 0 ·

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered

Upgrades are done one of two ways, you upgrade the server itself, or you move the database through backup & restore or detach & attach. You can script the install of 2008 and fire the scripts off on multiple 2000 servers, but, it's likely to run into issues. The mitigation would be to run the Upgrade Advisor and fix any issues that this tool raises.

But, upgrading servers in place, is dangerous. Most of the upgrades I do, I use the backup & restore mechanism so that I can leave the 2000 server available in case there's a problem.

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

+1 - whole server seems a reckless way to consider upgrading unless there are mitigating circumstances. Not sure on what the interview question was trying to discover, should you jump up and say NO WAY! or are they hoping to get someone to everything as fast as possible. My recommendation would be to do it db by db with the 2000 server online until hte last db is successfully upgraded and working.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.