August 21, 2002 at 2:50 am
Folks,
Im moving production databases from a SQL 7 cluster to a SQL 2000 cluster. Any advice, gotchas etc would be appreciated
Thanks
Mick
August 21, 2002 at 7:29 am
We did this recently (about a month and a half ago). What we did was add two more clusters so we transfered all our databases to those and then erased the two SQL Server 7.0 clusters and rebuilt those machines as SQL Server 2000 clusters. I got the impression from our DBA (who actually planned the changes) that it was best to start over rather than try to upgrade from SQL Server 7.0. We had no problem restoring 7.0 backups on a 2000 server.
We did find that a number of our stored procedures ran slower on SQL Server 2000 than on SQL Server 7.0.
Another problem we faced is that we used the word Function as a column name in SQL Server 7.0 and didn't have it enclosed by brackets []. That was fine for SQL Server 7.0 but SQL Server 2000 didn't like that so we had to change all occurances of Function to [Function] to get those stored procedures to work.
I can get a few more details about our switch from SQL Server 7.0 clusters to SQL Server 2000 clusters once our DBA comes in.
Robert Marda
SQL Server will deliver its data any way you want it
when you give your SQL Programmer enough developing time.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
August 21, 2002 at 8:31 am
Cheers Robert
Id appreciate it
August 21, 2002 at 9:06 am
I spoke with our DBA and he said that what they did was to uninstall SQL Server 7.0 and then install SQL Server 2000. He said this was done as a precaution to make sure that everything went smoothly. He also wanted to make sure that the name used for the installation was clusterserver1\clusterserver1 (computer name \ instance name) and not end up with just the computer name as the SQL Server name.
He told me that doing the upgrade this way went smoothly and we got exactly what he planned us to get.
I'm sure this is not the only way to do this but it is the way we did it.
Robert Marda
SQL Server will deliver its data any way you want it
when you give your SQL Programmer enough developing time.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
August 22, 2002 at 4:51 am
Thanks Robert
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply