Ditto :blush:

Brandie Tarvin (6/3/2010)

---

You can log ship to a server that has no instance?

I thought log shipped databases were in a state of Recovery? I thought they needed an instance to...

GilaMonster (6/3/2010)

---

Active/active has minimum 2 instances installed and has at least one instance running on both nodes. Active passive has instance only running on one node, installed but not running...

Thanks for the tutorial. I know what we have as i built them. They are two seperate a/p clusters and we mirror and log-ship to our scf dr server.

why would you need to set to a/a? we have a/p and mostly use mirrors to our scf site but have used ls aswell.

Yes this is easily done.

Personally i would g o with database mirrioring (without witness), its easier to setup and administer.

Failed logins arent held in their own log perse. They are all in the SQL Server log.

If you want to get all the failed logins, your best bet is to...

GilaMonster (6/2/2010)

---

What does CPU at 100% have to do with logs growing? Sorry, but there's just not enough info here to really say much

btw, if the log files are shrinking,...

Mr James Howard (6/3/2010)

---

Take a look at the scripts section of this site. There are tonnes of different monitoring scripts there which you can pick and choose from to build...

You need...

I created a USP that I gave execute permissions to a service account and then usinf a mixture of proxies and credentials gave the user access to execute the USP...

The only way to...

Tara-1044200 (3/31/2010)

---

I was thinking of having additional identical server may be a stand by server but how can I swith server names with in no time by which even users...

We have done this using credtials and some server roles....

so each partition has a filegroup of its own?

As long as you can ensure that there are no tables, views, objects in the partition and that the schema is such...