shew (5/20/2010)

---

Issue #1:

We are running Microsoft Failover Clustering on Windows Server 2008 R1 with SQL Server 2008 R1. We have one named instance installed and need to add a second...

In most cases Standard edition is suitable for what most people require. Unless you plan to have multi node clusters, require IA64 support, get heavily into partitioning, require compression and...

TRUNCATE requires ALTER permission on the table which you will also need for adding the constraint. You will probably also require ALTER on the schema too!

no its nothing like Office. Pick your self up a copy of the SQL Server 2008 training kit you can get it reasonably priced from Amazon, this is your best...

OK this slightly worries me. How can you expect a stable installation if you do...

Franco

transferring logins to SQL Server 2008 uses the same script that you have for 7\2000 to 2005

Hi Scott

i didnt...

Thank you, glad they are able to help you

on the failure notification it gives you the log location?

honestly i cannot any of this would generally be an issue. I do not enable CDOC, as the KB says you must be fully aware of the security implications. If...

Hi

welcome to Windows clustering. Which version of Windows clustering are you planning to use 2003 or 2008. Just for clarification what version of SQL Server do you plan to use,...

Hi

try installing the following file first then re run setup

'E:\Software_Installations\SQLServer_2008\x64\setup\sqlsupport.msi

you have the option to provision accounts during the install, why not use that?

use the following to ascertain backup sets that have been initaited against the database. Check the output to see if there are any unexpected\manual backups outside of the regime you...

No, but lock pages in memory probably should be!

If you start seeing the following in the SQL Server...