cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

Moving SQL from 2000 to 2005

Kirk_MacDonald
Level 3

‎12-05-2006 12:42 PM

I have found instructions on moving from one SQL server to another, but I was wondering if there were any extra steps to move from 2000 to 2005. If anyone has made this move please let me know the results you had.

Thanks,

Kirk
0 Kudos
4 REPLIES 4

Terence_Marques
Level 3

‎12-05-2006 11:48 PM

Hi Kirk

To be honest with you ive done this move 3 times before and all that was really required was to detach the database and add it to the SQL database and change the SQL server name in the directory SQL server to point to the new SQL server
0 Kudos

Kirk_MacDonald
Level 3

‎12-06-2006 08:16 AM

Well that is good to hear. I didn't want to start moving it and find out there were problems moving from 2000 to 2005.
0 Kudos

Micah_Wyenn
Level 6

‎12-06-2006 08:49 PM

yeah,
the only issues you'll have is if you're changing auth modes, or if you've got a 2005 cluster that need dependant resources.

micah
0 Kudos

Luis_Feitor
Not applicable

‎12-14-2006 05:54 AM

Hi Kirk,

I also have moved from SQL 2000 to 2005 without any kind of problems.
I think that one of the solutions, and easy one, it's to dettach and attach the databases and change in VAC the pointers to the SQL Server. I also installed the SQL 2005 SP1 and it is working without any kind of problems.

Regards,
Luis Feitor
0 Kudos