"The session loses quorum.

If all the server instances become disconnected from each other, the session is said to have lost quorum. As server instances reconnect to each other, they regain...

You should put it on the shared storage.

I never done this before, but my gut feeling is, you cannot do it.

There is a big difference between 2012 and 2000....so, its better not to set it up.

No, I would still script out and recreate in DR.

Basically it's telling you to remove the existing log-shipping and configure new one.

If you grant exec permission to that user for that SP, wouldn't that work?

Are you saying, you want to go from cluster env to stand-alone env?

It means there is still an active transaction in that ldf.

So, take couple of log backups and try to shrink again with empty file option and then delete it.

Let me...

Backup plan you create depends on the application requirements... Basically, depends on your application RPO & RTO.

As Grant suggested, did you check for any growth restrictions for ldf file?

Next time if same happens and you know which db log is getting full, try to create a...

Hi Brandie,

"I've created a job to initiate failover of the mirrors in case of database failure"

Do you mind sharing how you setup the job?

It's 2008r2, enterprise edition on Windows 2008.

If there is cluster index on the purge table, recreate the cluster index and then shrink the database, that should release the space to OS.

Hi, you didn't mention anything abt diff backups? That would have save a lot time as i you mentioned you had to roll forward 10 days.

What is your current...

Thanks Gail for correcting...I'm way off then...sorry.