There is a known issue with using the rolling upgrade from SQL 2005 to SQL 2008 R2 documented here.

I'm not certain if the same issue applies to SQL 2008 to...

It does take slightly longer to upgrade the database when they are larger but not a huge amount of time. I recently upgraded a 1.5TB database from SQL 2005 to...

Looks like you hit most of them. Here is my post upgrade list.

1. Change db compatibility to 100

2. Change page verify from torn page detection to checksum

3. Run DBCC UPDATEUSAGE

4....

No, Enterprise only. Check out the link below for the feature list of 2008R2.

http://msdn.microsoft.com/en-us/library/cc645993.aspx

On the download screen there is a link " Show hotfixes for all platforms and languages "....

Tara-1044200 (12/9/2010)

---

I am just wondering if 2008 R2 standard has Data compression and Backup compression. I know its not available in SQL 2008 but guessing R2 should have as it...

Tara-1044200 (12/9/2010)

---

Can i install R2 CU 4 directly without 1,2 and 3? or can i also directly start using it without cumulative upadtes?

can we directly download them from MS support...

The 64 bit version of SQL 2000 is only available for the Itanium processors IA64 and not for x64 processors.

That would only help if you SQL 2000 Enterprise. They won't help with standard edition.

thang_ngo_2002 (12/5/2010)

---

Recently it runs slowly. Sqlserv.exe always has memory near 1.8GB RAM (it seems a limit of memory), but CPU only some percent. Even I configure to SQL Server use...

No, you don't need it unless you plan on creating some local file shares.

Running the query below with results to text will generate the script to change all SQL login passwords.

SELECT 'ALTER LOGIN '+'['+name+']'+' WITH PASSWORD = ''<yourpasswordhere>'';'

FROM sys.server_principals

WHERE type = 'S'

Glad to hear everything worked out.

Happy to help.

select d.name ,mirroring_state, mirroring_state_desc

from sys.database_mirroring dm

inner join sys.databases d

on dm.database_id = d.database_id

where d.name = '<your db name>'