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 😉

lcibert (5/12/2010)

---

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) = 2005 SP1 RTM

And I cannot upgrade it because it's not supported by the application vendor for what I'm...

Icibert

what version and SP of SQL Server 2005 are you using? (e.g. 9.00.1399, etc)

Hi

For SQL Server 2005 move the master first using the following

Edit the SQL server service and change the paths for the MASTER data and log files to the new location....

sqlquery-101401 (5/12/2010)

---

thanks , actually i need some concrete link to prove H/W raid performance advantage over S/W but did not find much on internet that really stop to opt my...

your welcome

have you rebooted after installing the hotfix?