clustered sql 2000 to sql 2005 upgrade
What can I expect when upgrading a clustered SQL 2000 box to SQL 2005?
Answer Question
| Jun 24 2008 9:41 PM GMT
| asked by
Ajf
SQL Server upgrade, SQL Server clustering, SQL 2005
Need to upgrade sql server
Hi right now my database server running on sql server 2000 & my application is also running from the same server for heavy load on server i m going to seperate my database server & application server i need a help bocz my database size is all most 3 GB. also i need to upgrade my database on new...
View Answer
| Jun 9 2008 7:44 AM GMT
| asked by
Ravijoshi20
SQL Server upgrade, SQL Server 2005, SQL Server 2000
how to upgrade server to SQL 2005
I have a system with MS SQL Server 2005 installed and am running the MS SQL Server Management Studio Express but when I query the database version it comes back as SQL 2000 - 8.00.194. How do it change to using SQL 2005?
View Answer
| Jun 5 2008 11:08 PM GMT
| asked by
Cjdechris
SQL Server 2005, SQL Server upgrade, SQL Server Management Studio
Error when upgrading SQL Server 2000 to SQL Server 2005
I am upgrading SQL Server from 2000 to 2005. While upgrading I have received the below mentioned error. Kindly review and advise me on this. By the way, I have sufficient disk space on my server."TITLE: Microsoft SQL Server 2005 SetupSQL Server Setup has encountered the following problem:...
View Answer
| May 7 2008 3:29 PM GMT
| asked by
SQL Server Ask the Experts
Upgrades, SQL Server upgrade, ERROR MESSAGE
Looking for best approach to upgrade SQL Server 2000 databases to SQL Server 2005
I will be upgrading a number of SQL Server 2000 databases to SQL Server 2005 and was wondering what database objects I have to worry about? I believe to run Data Transformation Services (DTS)in 2005, I will have to have legacy installed. Is that correct? Other than that, should there be any...
View Answer
| Apr 30 2008 5:51 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server upgrade, DTS, SQL Server 2005
How to consolidate databases from different SQL Server versions to one SQL Server 2005 database
We have 52 SQL Server databases on different SQL Server versions (6.5,7.0,2000). We need to consolidate all the databases into a single SQL Server 2005 database. The structure is almost the same for all the databases, i.e.,tables/datatype. The actual data is different in all the databases. Could...
View Answer
| Apr 28 2008 3:45 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server database consolidation, SQL Server upgrade
What’s a safer upgrade, SQL Server 2005 or the new SQL Server 2008?
Do you think that as of next January (2009), SQL Server 2008 will be too new and we should instead go with SQL Server 2005? FYI, we are not a big installation.
View Answer
| Apr 18 2008 12:57 AM GMT
| asked by
SQL Server Ask the Experts
SQL Server upgrade, SQL Server 2008
Upgrade to SQL Server 2005 resulted in 100% CPU utilization and application timeout error
My server is DL580 running on Intel Xeon Dual core Dual CPU. I have recently migrated from SQL Server 2000 to SQL Server 2005. The server is dying and showing 100% CPU utilization and applications are getting Server Timeout expired error. What can I do?
View Answer
| Apr 4 2008 1:46 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server upgrade, SQL error messages, SQL Server performance
How to transfer encrypted data between SQL Server 2005 and SQL Server 2000
We are a retail/web/phone order store. We process credit cards for all three stores at our retail location. We have our web data stored offsite on the web server, using SQL Server 2005. We have our retail/phone order data stored onsite in SQL Server 2000. I'd like to add a function to our MS Access...
View Answer
| Mar 16 2008 10:22 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server security, SQL Server upgrade, SQL Server 2005
Do you have to break the replication after you install a service pack in SQL Server 2005?
In SQL Server 2005 when you install a service pack - do you have to break the replication as you did in SQL Server 2000 - and then reestablish the replication?
View Answer
| Mar 11 2008 10:08 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server upgrade, SQL Server installation, SQL Server replication
