Upgrading SQL 7 Cluster TO SQL 2000 ?
Mar 30, 2004
I am currently running an active/passive cluster NT4 with SQL7 clustered. I am trying to upgrade SQL to a clustered 2000 version. I have a san disk area allocated as a Z: drive. These are the following steps I have taken:
1. Used cluster wizard to uncluster the SQL 7 instance.
2. Using the SQL 2000 Enterprise cd created a new virtual server (with the same IP address and name as the previous SQL 7 server) I have left the install as a default instance.
3. Part way through the install I am asked to browse to the data area. The data area is Z:mssql7data.
On completion of the install I now have the following data path Z:mssql7datamssqldata and all the databases are still SQL7 databases.
My questions are:
How can I get the install to update/convert the databases to SQL 2000 as it doesnt seem to recognise them?
Will the install always suffix the data path with mssqldata
Any assistance appreciated.
View 1 Replies
ADVERTISEMENT
Mar 26, 2008
We have 2 SQL servers in a failover cluster environment. SQL1 and SQL2. Currently SQL1 is the primary in the cluster, and we need to upgrade from Service Pack 3 to Service Pack 4.
Our setup:
Both servers are Windows 2003 Server Enterprise Edition.
Both servers have SQL Server 2000 Service Pack 3.
My question is:
Which upgrade plan do I take? Do I:
1. Upgrade the backup (offline) server in the cluster (SQL2) first, reboot, then failover from SQL1 to SQL2? Then do the other server?
2. Upgrade the primary (online) server in the cluster (SQL1) first and see if it replicates to the backup?
Any advice or tips would be most appreciated.
Thanks.
View 6 Replies
View Related
Jun 6, 2002
We shall be taking a bunch of 7.0 instances and moving/upgrading to a SQL 2000 cluster server. I was thinking of creating new named instances on the 2000 cluster and upgrading each 7.0 server to it's respective named instance. Also thought of using the 2000 copy database wizard; I was told this didn't always work. Anyone hear of problems with this?
Thanks
View 2 Replies
View Related
Dec 28, 2007
We're upgrading a SQL Server 2000 cluster (Active/Passive) running on Windows 2000 Server to a SQL Server 2005 Cluster running on Windows Server 2003. We can't purchase new hardware and we have no spare hardware. We also need to move from Windows 2000 Server to Windows 2003 Server at the same time. We want to keep downtime to a bare minimum.
What we were thinking was the following steps... Anyone try this?
1. Break the link between the servers.
2. Install a fresh copy of windows 2003 server on one side along with SQL Server 2005. While this step is running, the active node would still be live on Windows 2000 Server and SQL Server 2000 serving our customers.
3. Restore a copy of a backup from the active production side to the node we're upgrading and at that point we would bring the active node down, switching the active node to be the newly upgraded server.
4. As a final step, the old active node would now have the link to it broken, we would install a fresh copy of windows 2003 server on it and sql server 2005. At this point we would bring it back into the cluster and the cluster would be complete again.
Thoughts?
View 2 Replies
View Related
May 14, 2008
Friends -
Need your help and guidence for doing upgrading SQL Server 2000 Cluster to SQL Server 2005 Cluster.
Let me explain my current environment.
1. Currently SQL Server 2000 Cluster environment is running on Windows 2000 Server we need to upgrade this to SQL Server 2005 on Windows 2003 Server. >>> Production environment.
My Plans:
1. On Testing Environment Install SQL Server 2000 cluster on Windows 2003 Server and do a restore of databases from the produciton environment.
2. Upgrade In-Place from SQL Server 2000 Cluster to SQL Server 2005 Cluster.
My doubts
1. Can i install SQL Server 2000 Cluster on Windows 2003 Server. Is it possible or not.
Please advise me and correct my steps.
Cheers
VSH
View 1 Replies
View Related
May 15, 2008
Friends -
Could any one of you provide steps for upgrading SQL Server 2000 cluster to SQL server 2005 cluster.
My environment is Windows 2003 server.
Appreciate your support.
Cheers
VSH
View 1 Replies
View Related
Jul 17, 2007
I am going to be upgrading to SP2 on an active/passive cluster currently running RTM. I have read the release notes, but there isn't much cluster specific information there. At what point during the installation are connections to the database no longer available? I am trying to figure out approximately how much downtime we will have during this installations. Are there any precautions, other than a backup, that I should take to ensure the upgrade goes smoothly?
View 5 Replies
View Related
Oct 20, 2007
Hello SQL pro's,
I have a SQL 2005 cluster using 2 HP DL 380 32bit servers connected to an HP MSA500 disk pack via SCSI. I need to upgrade the servers to 64 bit but I am still going to use 32 bit windows server.
My question is, has any tried this before? If so, will it work and what is the best way to go about it. Should I take down the secondary SQL server, then replace it, then add it to the cluster, then fail over to it, then replace the other?
Any information is greatly appreciated.
Dan
View 1 Replies
View Related
Nov 27, 2007
I need to upgrade a trial version on 2005 to Enterprise. Will this work?
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
Does that take care of SSIS and RS?
I see that UPGRADE may only have a value of 'SQL_Engine', so I'm assuming everything relies on the version of the engine. I also see that every cluster install requires certain options that are not specified in my command - which is why I'm a little confused - you can see that info a little below this link - "Parameters Required for Cluster Installations". But I'm thinking this isn't a install, but an upgrade.
http://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade
Thanks for any help!
View 3 Replies
View Related
Sep 12, 2007
Hi,
I've just installed SQL 2005 SP2 Rollup 3 Package (Build 3186) on a 2 node X64 W2K3 Cluster.
Everything went fine, although after the install, the SQLAgent Services of my instances started to complain about delegation not enabled for the domain account used for the SQLAgent Service.
SPN's were already registered, so I've enabled unconstrained delegation & no errors anymore..
Apparently we're obliged to enable delegation as soon as this hotfix is installed
(maybe due to fix 938086 included in it ?)
To make this setup more secure, we would like to enable constrained delegation.
This does not seem to work, as soon as we choose constrained delegation by adding the SPN of the clustername to the domain user account we're running with & restart the sql agent, it fails with the same error as when no delegation was configured:
! [298] SQLServer Error: 22022, CryptUnprotectData() returned error -2146892987, 'The requested operation cannot be completed. The computer must be trusted for delegation and the current user account must be configured to allow delegation.' [SQLSTATE 42000]
! [442] ConnConnectAndSetCryptoForXpstar failed (0).
Summary:
With Unconstrained delegation enabled for computer account & user account, everything goes fine.
As soon as constrained delegation is chosen, by adding the SPN's to the domain user account of SQL Agent, SQL agent fails to start.
We use a domain account for the SQL Agent.
This account has an 2 SPN registered on it
MSSQLSvc/<FQDN SQL instance network name>:1433
MSSQLSvc/<FQDN SQL instance network name>
Connections to SQL go fine, authorization scheme is Kerberos even when SQL Agent fails to start due to this delegation failure.
Domain account has "act as part of operating system" & "impersonate a client after authorzation"
Anyone an idea ?
View 25 Replies
View Related
Sep 14, 2007
Could someone give me an ideal of what it takes to upgrade the memory in my cluster. Is it as easy has upgrading the passive node, switching the nodes, then upgrading the other server. And do I need to re-configure the windows cluster. And will both server need to be down at the same time at any point.
Or is their more to the process? Thanks for any assistance.
btw, I currently have 16mb of RAM in each node.
View 3 Replies
View Related
Jul 4, 2007
I have two Windows 2000 servers (Advance Edition) to form a Windows Cluster. I also install MS SQL 2000 Enterprise Edition on the cluster to form a MS SQL cluster. Now, I want to upgrade the hardware and OS (but keep on using SQL 2000), so I install Windows 2003 server Enterprise Edition on two new servers to form a new Windows Cluster. I am planing to install MS SQL 2000 Enterprise Edition on the new cluster, so the old SQL cluster and new SQL cluster are side by side. I would like to know how to setup a new SQL cluster (I know it has problem to rename SQL Cluster name, so how to fix this problem)? And how to transfer everything (such as system databases, users database, sql user account, password and maintenance plan jobs etc) from old SQL cluster to new SQL cluster? And how to switch over from old SQL cluster to new SQL cluster?
Thanks a lot !
View 8 Replies
View Related
Aug 2, 2006
How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack??
View 1 Replies
View Related
Jul 18, 2001
Has anyone attempted an upgrade from sql7 to 2000? is it a difficult process? what happens to the users. Is there a good site i can go to to get this info ?
Thanks in advance
View 1 Replies
View Related
Feb 13, 2002
Anyone know of any issues I should be aware of when upgrading from sql 7.0 to 2000? Is it a problematic proccess?
liz
View 2 Replies
View Related
Apr 19, 2002
We are currently still running SQL6.0 on NT4 server, and we want to upgrade to SQL2000. My question: how easy is it to upgrade from SQL6.0 to SQL2000?
View 3 Replies
View Related
Nov 2, 2001
Currently running SQL Server 7, and have databases. I want to upgrade to SQL Server 2000. How can achieve it without delete or losing my databases. This is NOT a production server, BUT I still want to keep my databases. Ideally I would like to uninstall and reinstall so that there are no SQL Server 7 files lying around when I have SQL 2000 running. Thanks.
View 1 Replies
View Related
Dec 3, 2004
Hi,
We are trying to upgrade from SQL Server v7.0 to SQL Server 2000. Here's our set up,
Current Server: Win NT, SQL Server v7.0
New Server : Win 2000, SQL Server 2000
Client (my PC): Win XP, SQL Server 2000
The New Server is designated SQL Server machine -- company-wide. That is, all the apps/projects uses this machine as the SQL Server. It only has one instance of SQL Server running.
Different project are assigned a dedicated 'Drive' (logical only) and allocated certain disk size as the work space. We (my team) will be the new entry for this server.
Q: When doing the Copy Wizard (from my PC) to upgrade/copy the existing v7.0 db (from Current Server) to New SQL Server 2000, do I need to specify the physicall 'Data' folder? Or, can I copy the database to the selected path -- which is my dedicated drive?
Thanks in Advance.
_msd_
View 1 Replies
View Related
Oct 3, 2006
Have an old PII server running Windows 2000 and SQL 7.0.
We just got a new box, Windows 2003 and SQL 2000.
Is there some kind of upgrade advisor or anything for me to read so I can prepare for this upgrade?
I'm most curious about how to properly transfer my data from the old box to the new.
View 1 Replies
View Related
Apr 14, 2004
Hi,
I'm planning an upgrade of SQL 7.0 on NT 4.0 to SQL 2000 and of course I will attempt to upgrade the OS to Windows 2000 first.
Can anyone tell me of any issues I may run across during this upgrade?
Can I assume that SQL 7.0 will run ok on Windows 2000?
thanks much,
Robert
View 4 Replies
View Related
Nov 19, 2007
Ok another "I Don't crap about SQL and should read the book" question:
I am purchasing new servers for a company that currently runs SQL 2000 in a Windows 2k3 environment. Not sure why, but they want to upgrade to SQL 2005. The have 4 SQL 2000 Standard editions. Three with 1 processor licensing and 1 with per device licensing. The new servers will have 2 x Quad core processors. Since I know licensing is per "Physical Processor" I need to purchase an additional license for a second processor on each machine that has two. How do I purchase a second one? Can do this online? Whats the cost? Another question I have is: Do I need to buy SQL 2005 Standard (Full Standard Version) install on the new machine and migrate by databases from SQL 2000 over to the new ones? Or is there like an upgrade kit where I install SQL 2000 on the new ones then buy a update to SQL 2005 disc? Please don't laugh at my questions, I am by no means a SQL GURU. Thanks in advance.
View 1 Replies
View Related
Jul 20, 2005
I have a backup of SQL Server 6.5 database, but can no longer locatemy 6.5 server software. I would like to upgrade this backup to SQLServer 7 or 2000 ( i do have this software!) , does anyone know ifthis is posisble without the 6.5 software?If the answer is no, does anyone know where i could find/buy SQLServer 6.5, so that i can do this ?Thanks for any help.Rob
View 1 Replies
View Related
Jul 28, 2006
Hello
After installing Sql server 2000 STD Sp1 on a server with Windows 2003 server, i have upgrade my Sql server to Sp4.
All the setup has been terminated without errors, but if i execute on Q.Analyser : "Select @@version" on the end of line of my query result , i have ....(Service Pack 1)
I donŽt know , if effectively the upgrade has been terminated with sucess.I try to restart my server several time , but the result of my query is always the same "....(Service Pack 1)"
Also, on my firewall server , i Žam create an UDP port 1434, because my ODBC client machine was enable to connect to my server.
Could you give me an explanation about, this question, and if i really done the upgrade to my sqlserver.
Many Thanks
Luis
View 3 Replies
View Related
May 28, 2008
I was with online chat with Microsoft, and the guy said there is no upgrade option between SQL versions like there is from Windows XP home to Pro, or 2000 to XP. Is this true? Has anyone else done this before? I'm wanting to upgrade from SQL 2000 to SQL 2005. I was hoping there was a 32-bit to 64-bit upgrade as well within the versions, but that doesn't seem available either. I will settle for SQL 2005 32-bit if I can upgrade, but if I have to buy a whole other license for it, I might as well get x64. If anyone has done this or has experience in this, any information would be much appreciated!
View 1 Replies
View Related
Aug 7, 2007
Any expert in the house willing to show me how to upgrade from SQL2000 to SQL2005?
Thanks!
View 4 Replies
View Related
Dec 11, 2007
Hi everyone,
I want to upgrade SQL server 2000 to SQL server2005, what are the issues which I have to look at during my upgrading process, what sort of problems might be faced during the upgrading?
Lot of thanx
View 1 Replies
View Related
Aug 8, 2007
Please recommend best learning material for quickly upgrading skill sets from SQL 2000 to SQL 2005
View 5 Replies
View Related
May 21, 2008
Hey all!
I currently am running 8.00.760 which is the Standard Edition of SQL 2000 SP3 (or it might be 3A - no way to tell)
I have downloaded and am preparing to install 9.0.3042.1 SQL 2005 SP2 but when I run the exe file it informs me that "This machine does not have a product that matches this installation package."
Both are 32 bit versions and the precise exe I'm attempting to run is: SQLServer2005SP2-KB921896-x86-ENU.exe
I'm logged on as the server admin.
The server is running Windows Server 2003 Standard Edition SP2.
It has dual Xeon 3.2ghz dual core processors and 4gb of RAM
All of the documentation indicates that this upgrade path is acceptable.
The only thing I have noticed in the Sys Requirements (http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en)
is that the supported OS is Windows 2003 SP1 (and no sign of SP2 in the list!) could that be what the issue is?
Does anyone have any advice on where I should look to tackle this issue? I'd like to explore all free avenues before dropping any money for the paid SQL support services.
Thanks for any help.
Geoff Garcia
March of Dimes
ggarcia@marchofdimes.com
914-997-4275
View 3 Replies
View Related
May 8, 2007
Hi
We are planning to upgrade the SQL Server in our production environment from SQL Server 2000 to SQL Server 2005. This is a 4 Node cluster environment with 3 Databases on 3 Virtual instances. The main requirement is to achieve this with no/minimal downtime.
Could you please suggest or direct me to any documentation for the best practices used to upgrade such an environment?
Thanks
Priyanka
View 2 Replies
View Related
Jan 17, 2005
I am planning on upgrading one of my SQL 7 servers to SQL 2000. This server is currently and will continue to replicate with a SQL 7 server.
I want to view our current replication jobs & schedules in plan text so I can check when I recreate the replication that I haven't missed anything. Does anyone know if this is possible?
Jon
View 4 Replies
View Related
May 15, 2008
Having some trouble running the SP4 upgrade on a MSDE 2k named instance.Its working for one instance but give me error for the second instance.
- MSDE 2k sp3 currently installed
- Windows XP Pro
- Non-null SA pw
- Executing setup.exe /UpgradeSP SQLRUN
The install runs for a bit and then disappears. Here's what the very
bottom of the log reads:
=== Logging stopped: 08/05/15 11:44:29 ===
MSI (c) (64:F8) [11:44:29:698]: Note: 1: 1729
MSI (c) (64:F8) [11:44:29:698]: Product: Microsoft SQL Server Desktop Engine -- Configuration failed.
MSI (c) (64:F8) [11:44:29:713]: Grabbed execution mutex.
MSI (c) (64:F8) [11:44:29:713]: Cleaning up uninstalled install packages, if any exist
MSI (c) (64:F8) [11:44:29:713]: MainEngineThread is returning 1603
=== Verbose logging stopped: 08/05/15 11:44:29 ===
the only other error I can see is this:
Action start 11:44:29: RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B.
MSI (s) (A8:B4) [11:44:29:651]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI19E.tmp, Entrypoint: RestoreSetupParams
SOFTWAREMicrosoftMicrosoft SQL Server Setup.{FE7E950B-220A-4182-B5CA-19397244DCFD}
Entering Function MyMsiEvaluateCondition
MsiEvaluateCondition for SQLMSDEInstalled returned TRUE
End Function MyMsiEvaluateCondition
Error reading setup parameters
Action ended 11:44:29: RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value 3.
Action ended 11:44:29: INSTALL. Return value 3.
SYNTAX Used is : setup.exe /upgradesp sqlrun INSTANCENAME= SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=MyPwd BLANKSAPWD=1 /L*v D:MSDE.log
Please note that I am using BLANKSAPWD=1 because BUILTINAdministrators right is not present, the above syntax is working for one named instance but is failing in second named instance.:eek:
I'll post the full log if that helps. Any ideas?
Thanks,
Onkar
View 10 Replies
View Related
Jul 20, 2005
Has anybody had any experience of this??We have over 2000 stored procs to convert from Watcom SQL to SQLServer 2000. Any automated tools would be much appreciated!!Also any known issues.
View 1 Replies
View Related
Nov 29, 2006
I restored a 2000 database back up in to my 2005 database and it works fine. THe only problem is that I cannot create diagrams.
I get the following message:
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
I have checked the db_owner and that is a valid owner.
I changed a few times to different owners and still could not install the diagrams..
Any ideas?
thanks
View 1 Replies
View Related
