That makes things a whole lot easier. Just set mirroring up as defined in BOL. I...

Start a new thread giving details of your issue where people will be...

Generally when passing multiple parameters to a dynamic SQL string you would declare and pass the parameters as the link specifies, Michelle's script doesn't but then it's only passing a...

Is the stand alone server part of the same domain as the cluster or is it in a workgroup.

you're now confusing...

just to re iterate, you only need a backup of the certificate and its private key and a backup of the database itself

With the current exchange rates that wouldn't be a bad thing 😉

With my FU money I'd take my commercial pilots licence and buy myself a small jet 🙂

MarkThornton (1/13/2012)

---

Hi Perry,

Thanks for helping. I ran Paul's code and got this result:

session_idstart_time status ...

It's not just me then 🙂

fragmentation should be as low as possible not as high as possible!

this is a known issue, truncate clears the table as all pages are de allocated. When deletes occur the ghost delete process fires to remove pages, with LOBs this takes...

Do you have any databases mirrored on this instance already or is this the first one you are attempting?

Ah right ok.

Try switching compression on using the command above see if it throws an error message, this may give a clearer indication.

Can you go to the Transaction log backup...