January 17, 2008 at 3:55 pm
My company will be replacing a server running SQL Server 2000 with a new box running SQL Server 2005. The plan is to just restore the DB's from backups on the machine, should there be any pitfalls to this? We have already scripted the jobs out so there will be minimum downtime, but should we foresee and compatibility issues?
Thanks in advance,
Jon
January 17, 2008 at 5:04 pm
1) There are some "best practices" articles on this site regarding migration. I suggest you take a look at them.
2) Make sure your logins, jobs, etc. (i.e. the things that live outside the user DB) are scripted as well.
3) Run the Upgrade Advisor (free from Microsoft) to check for any issues.
January 17, 2008 at 8:37 pm
MS has "SQL Server 2005 Upgrade Technical Reference Guide".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply