SQL Server upgrades

SQL Server Upgrade and Server Move

I have an old Windows 2000 server running SQL 2000 and need to retire the server and move my SQL databases to a new server. The new server is a fresh install of Windows Server 2003 and SQL Server 2005.I am having a hard time finding a procedure for this complex conversion. Is this something that...

View Answer   |  Sep 5 2008   3:23 PM GMT   |  asked by RussGunther
SQL Server upgrades, SQL Server 2005, Windows Server 2003

What are the benefits of SQL Server 2005 over SQL Server 2000?

If i am satisfied with SQL 2000 then why I should go for SQL 2005

View Answer   |  Aug 22 2008   8:20 AM GMT   |  asked by Itramkrishna
SQL Server migration, SQL Server upgrades, SQL Server 2005

Upgrading Microsoft SQL 2000 to SQL 2005

I have one server running SQL Server 2005 and about five servers running SQL 2000. Does anyone know what is entailed as far as upgrading from SQL 2000 to SQL 2005? The majority of the servers are running Win2k Server.

View Answer   |  Aug 19 2008   6:04 PM GMT   |  asked by Mr D
SQL Server upgrades, SQL Server 2005, SQL Server 2000

Can’t Upgrade to SQL Server 2005

I am trying to upgrade a SQL Server 2000 SP4 standared edition running on 64bit Windows 2003 to SQL 2005. Since I am trying to upgrade, I am updating the Default instance. After selecting default instance, the wizard takes you to what components to upgrade; but the Database services is locked so...

View Answer   |  Aug 11 2008   9:41 PM GMT   |  asked by Randym
SQL Server upgrades, SQL Server 2005, SQL Server 2000

Advantages of SQL Server 2005 over SQL Server 2000

What are the benefits of upgrading to SQL Server 2005 from SQL Server 2000?

View Answer   |  Aug 7 2008   4:14 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2005, SQL Server 2000, SQL Server upgrades

Upgrading from SQL Server 2000 SP3 to SQL Server 2000 SP4

We have SQL Server 2000 SP3 running on Windows 2003 Server. Every week, after running our optimization and integrity checks on Sunday, we get this error:Time out occurred while waiting for buffer latch type 2...This happens several hours into the day every Monday. Would upgrading to SQL Server...

View Answer   |  Jul 22 2008   7:58 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2000, SQL Server 2000 SP4, SQL Server upgrades

i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

View Answer   |  Jul 5 2008   5:55 PM GMT   |  asked by Pandu
VB6, Visual Basic 6, SQL Server 2005

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 upgrades, 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 upgrades, 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 upgrades, 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 upgrades, 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 upgrades, 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 upgrades

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 upgrades, 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 upgrades, 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 upgrades, 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 upgrades, SQL Server installation, SQL Server replication