Hello Jon, If you have to just upgrade a *database *to the newer version, I recommend you to use the Copy Database Wizard [1], available in SSMS. If you have to upgrade a SQL Server 2000 *istance *to SQL Server 2005, you could make an in-place upgrade [2]. Afaik SQL Server 2005 database backup format is incompatible with previous versions, so backup/restore shouldn't work for you. Attaching and detaching the database files shouldn't work too.
[1] http://msdn2.microsoft.com/en-us/library/ms188664.aspx [2] http://www.sqlservercentral.com/columnists/rpearl/installingandupgradingtosqlserver2005.asp HTH, Efran Cobisi http://www.cobisi.com Jon Rothlander wrote:
I'm trying to import my SQL 2000 database into 2005. How do you do this? I cannot find any documentation on this and it doesn't look to be a simple matter of creating and restoring a backup. There must be more to it but I cannot find anything on the Internet in regards to how to upgrade. Any suggestions? References? Best regards, Jon Rothlander =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
=================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
