Need a leg up on migrating from SQL 7 to SQL 2005 (HOW TO?)

I have a SQL7 server that runs one database for our company. The rest of the datastore is on a SQL2005 server. How best can I transfer the SQL7 database to SQL2005??

There are a variety of ways, but the most straightforward is to simply back up the SQL 7.0 database, and restore it onto a SQL 2005 instance...

--
Adam Machanic
Pro SQL Server 2005, available now
http://www..apress.com/book/bookDisplay.html?bID=457
--

|||I have tried to do that, but the SQL 2005 server balks at the backup. Is there anything special one has to do in order to get the backup to restore properly?|||?

Is your SQL 7 server patched to the last SP (4, if I recall properly)? I believe that is a prerequisite. If it is, what is the exact error you're getting?

--
Adam Machanic
Pro SQL Server 2005, available now
http://www..apress.com/book/bookDisplay.html?bID=457
--

|||

I applied SP3 and SP4. Afterwards, I was able to produce a useable backup that I was able to restore to SQL 2005

Thanks for your help