Ah that's ok then, you're running SQL server 2000 on this box?

Which OS\service pack?

As already mentioned, take this opportunity to ramp up the CPU and RAM.

Aside from that, would there be any mileage\possibility consolidating the remaining instances?

best way, the way i use, is a WMI command line query, this will catch logical drives and mounted volumes too as it looks at the volume level 😉

You can...

Vertigo44 (6/6/2012)

---

What would be better for two independent systems to be kept in sync and can they be an active / active configuration without clustering the SQL instance? The...

do not do this!

the msdb holds information relative to the sql server...

Note, this does not affect...

it's hosed already so it won't make an ounce of difference 😉

They'll likely only grow again, are you aware of the ramifications of this?

How many network cards are installed and what configuration?

SQLSACT (6/6/2012)

---

Hi Perry

I ran the Verification and there are no errors reported

There is one warning for "Validate Network Communication"...

charipg (6/6/2012)

---

I Checked the database in MS Query Analyser. I am getting the following error when trying to sort a column in the 'table1' in 'proddb' database o

"SQL Server...

run your cluster verification and ensure there are no errors

SQL Server has a TABLEDIFF.exe that you may use to compare objects, check BOL for more info

zsafakhah (6/6/2012)

---

Dear Friends,

I Created a Backup from Databases on Sql2000 and Restore in sqlserver2008 r2.

but i worry about which not granteed in sqlserver2008 r2?

how can i find list of which...