What edition\version of VMWare are you using to host the VM?

How many virtual CPUs are assigned to the VM?

Have you assigned the lock pages in memory policy to the sql...

Are you referring to the Verify Backup or Perform checksum checkboxes? Theses aren't the same as a consistency check, are they?

Ninja's_RGR'us (12/17/2010)

---

paul.knibbs (12/17/2010)

---

Ninja's_RGR'us (12/16/2010)

---

You can download sql express and install it on your pc. That's always a good start. If that's a no go because the DB is over...

We have a similar setup and encountered a similar situation. What happened was I scheduled a backup of a 200GB DB during a time window when there were no...

The SQLServer instance is configured with 1433 on IPall. In Windows Firewall I have a Exception for TCP Port 1433 and an exception for sqlservr.exe. ...

OK,

I try to connect to the server by machinename\SQLEXPRESS or by IP\SQLEXPRESS.

When I power up the VM, the VM can ping other machines on the network - the DSL Router,...

It is VMWare. The network setting is bridged, which means the VM has it's own IP and is supposed to act like it's own machine on the LAN....

A little more information:

Here is the error log from the MSSQL folder:

2009-02-25 17:42:46.60 server Copyright (C) 1988-2002 Microsoft Corporation.

2009-02-25 17:42:46.60 server All rights reserved.

2009-02-25...

That should have been a clue. And the answer is that this table has an update trigger that updates data in another table. That apparently returns another result...

Fixed.

Here's the fix:

The KB said it could be a missing CLSID from a custom task, so I searched the CLSID section of HKEY_CLASSES_ROOT for "DTS." I found a reference...

I moved it initially by opening it on the old server and selecting SAVE AS and saving it directly to the new server.

The other SAVE AS options are a visual...