had a sql server (2000 I think) built on enterprise 2003 die. Got new hardware and am beginning the guessing game. any good reference articles, step by step of how to build new and restore backups from external hd. Old server won’t even boot.
Answer Question | June 15, 2011 12:56 PM
Backup, SQL Server, SQL Server 2000, SQL Server 2000 SP4, SQL Server backup and restore
Did anyone experience problems with SQL Server 2000 SP4 and consistency errors on o 2003 R2 x64 guest OS. CHECKDB shows databases corrupt, the next run they are clean, then they might become corrupt again. We are banging our heads against the wall to find a solution for this problem. We have this problem with [...]
Answer Question | May 19, 2010 5:46 PM
ESX 3.5, ESX Server 3.5 Update 4, Microsoft SQL Server 2000, SQL 2000, SQL Server 2000 SP4, Virtualization in 2010
SQL 2000 (sp4) instance with databases at compatibility level of 65 and 80. Is changing the compatibility level from 65 to 80 actually upgrading the database to 80? What should be done before and after changing the Compatibility level?
Answer Question | January 11, 2009 6:06 PM
SQL Server 2000, SQL Server 2000 SP4, SQL Server Compatibility Level, SQL Server database
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 2000 SP4 resolve this issue?
Answer Question | July 31, 2008 7:58 PM
SQL Server 2000, SQL Server 2000 SP3, SQL Server 2000 SP4, SQL Server errors, SQL Server upgrades
I currently have two instances of SQL 2000 running on the same SVR. recently I commissioned a new CRM SVR and as I’m sure your all aware that the minimum requirement for the CRM to work correctly is SQL 2000 SP4. I downloaded and installed SP4 on the SVR running SQL 2000, however, my problem [...]
Answer Question | February 22, 2008 4:47 PM
SQL Server 2000, SQL Server 2000 SP4