Home > IT Answers > SQL Server > Help upgrading from SQL Server 1997 to SQL Server 2005
ITKE
16,755 pts.
 Help upgrading from SQL Server 1997 to SQL Server 2005
SQL Server, SQL Server 2005, SQL Server 2005 upgrade, SQL Server migration, SQL Server Upgrade
When upgrading from SQL Server 97 to SQL Server 2005, what needs to be done? Can I restore 97 backups to 2005? Do I need to install any other software? Is this an easy process? We have 6 databases with about 300 GB of data currently.

Software/Hardware used:
SQL Server 1997, SQL Server 2005
ASKED: July 22, 2010  8:01 PM
UPDATED: July 23, 2010  6:23 AM
RELATED QUESTIONS
Answer Wiki:
Well, first there is no such thing as SQL Server 1997. There is SQL 7 and SQL 2000. Assuming that your SQL Server is one of those, yes you can simply restore the database backups to SQL Server 2005. Or you can detach the database and attach it to the newer version. You'll need to export the logins, jobs, DTS packages, etc that need to be moved so they can be moved into the new instance.
Last Wiki Answer Submitted:  July 23, 2010  6:23 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _