AWE is not needed on x64 OS with a x64 SQLinstance. ( it already has the ability to address all your ram )

Did you perform full db maintenance after your...

Did you have a look at http://support.microsoft.com/kb/244980

This is the script I use ( sql2005 for the moment )

/*

* DB Mirroring : followup

*

*/

/* show mirrored databases and their mirror-state */

Select db_name(database_id) as dbName

, *

from...

Have a look at http://msdn.microsoft.com/en-us/library/cc645993.aspx

Books online...

please provide full error information ( sqlserver errorlog )

Brandie Tarvin (4/19/2011)

---

I'm going to violate the rule and add a "technical" question to The Thread under the caveat that I don't really need an answer for a problem so...

Koen Verbeeck (4/19/2011)

---

Thanks, this will be stuck in my head for the...

My bank account is crying so loud, I can't even hear London calling ....

( altough it reminds me of a great song some...

Stefan Krzywicki (4/18/2011)

---

ALZDBA (4/18/2011)

---

Does Zip still have the 4GB limit ? :ermm:

I used the open source :blush: 7zip free solution. ( I don't know if RAR is actually free)

It is...

Does Zip still have the 4GB limit ? :ermm:

I used the open source :blush: 7zip free solution. ( I don't know if RAR is actually free)

It is able to compress...

Can you post your @@version information ?

john.daisley (4/15/2011)

---

@ALZDBA -...

is this your first alert ?

Did you restart sqlagent after installing the alert ?

john.daisley (4/15/2011)

---

ALZDBA (4/11/2011)

---

No doubt about it: apply at least SP3, better even SP4

If you want your instance to use more than 1.7GB RAM, you'll need to do two actions:

1) add...

your instance has a number of connections to be able to run (for system processes)

These are mostly connected to master

in sys.processes system processes will have a number lower than...