[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

SQL 2000 -> SQL 2005 assistance

I am in the process of moving databases from a SQL 2000 server to a SQL 2005 server with the backup/restore method, but the process iserroring out. Does anyone know how to convert/move databases?
0
sandorka
Asked:
sandorka
1 Solution
 
sandorkaAuthor Commented:
I have 2 separate servers, a SQL 2000 and an SQL 2005 with SP 2 and the latest patches.
0
 
spprivateCommented:
Backup the database in SQL server 2000,copy the .bak file into the new server.Restore it from the management console.It is pretty straight forward.By the way,what is the error you are getting.
I have done this many times in my company
0
 
lexiflexCommented:
There should be no problem. Without knowing the errot message it's hard to speculate what might be wrong.

Did you run the Upgrade Advisor to see if there might be incompatibility issues? (http://www.microsoft.com/downloads/details.aspx?familyid=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en).
0
 
imitchieCommented:
an alternate way is to stop 2000, copy the mdf, ldf files (both) and any other files (ndf) and use
sp_attach_db from 2005.  similarly to backup/restore, sql will automatically upgrade the databases and introduce the sql 2005 sys. tables on attachment/restore
0
 
ptjcbCommented:
What are your error messages?
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now