I was thinking about log shipping...

My intial google - seems like log shipping is kinda a bitch to setup?

Oh okay...but then how could I reference it then?

Thanks everyone for your help

Most appreciated.

does mirroring require primary keys?

Oh sorry...I was a little confused..

So during a hurricane the mirror would become primary..do I have to enable this..or would it failover automatically once I take the primary 'Offline'?

And then...

Thanks Mike..

So (just so I'm clear) I would only have read only access if there was a failure on the primary DB?

If it's read only access, that wouldn't work because...

Yes, our users would be re-directed to the server in the other state when there is a chance of a hurricane (florida).

Do I still want to look at Db mirroring?

Umm yeah...it's an accounting product called 'UltiPro'.

But I can make changes if need be.

Guess I just never heard of sooooooo many triggers being on a DB before.

They/we are having...

The triggers vary they are all types - insert, update, delete

Thanks Guys!

thanks again lowell

you da man

guess we are confused we have a password field (varchar) with an encrypted value of 'mPhZTe370xFPEwZCjniN8Q=='

Am i using this correctly?

USE tempdb;

-- create symmetric key 'AES128SecureSymmetricKey'

-- using the AES_128 encryption algorithm...

thanks you so much lowell.

good karma to you

it's password hint answers...

I have the questions and the key from the devs.

Thanks guys..

sounds like there's no real way to enumerrate...

yeah guess I could always add an extra numeric alias ..but was hoping there was something intrinsic