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...

i couldnt agree more, that would be my concern!

BharatBhushan (5/13/2010)

---

I have sql server 2005 sp3 on windows server 2003 sp2. I am curious if I have free memory available on OS level and I want to increase SQL...

if you have unreliable band width then this is not the best solution

Is it that much of an issue if it takes an hour and a half. How much...

something along the lines of the following should work

use yourdb

select t.name as TableName, c.name as ColumnName from sys.tables t

inner join sys.columns c on t.object_id = c.object_id

where c.name = 'Yourcolumnname'

What version\service pack are you using?

If the SAN goes down chances are the whole business is down too, while it's a good scenario to plan for it's more realistic that a disk in your array...

Grant Fritchey (5/12/2010)

---

You can backup & restore msdb between servers. Assuming the drives are the same, your Agent jobs should be ok. If the drives & whatnot are different, you'll...

Have any other hotfixes been applied at all?

no, i would try posting in the sql server 2000 forum in the future 😉