Yep it is RPO, dont know where I got RTP from, must be a combination of RTO and RPO.

You cannot purchase SQL 2005 or SQL 2008 licenses any more, you have to follow the SQL 2012 rules, and ensure you get the downgrade rights if you want to...

RTO = Recovery time objective - How long do you have to recover service?

RTP = Recovery time point - How much data can you afford to loose?

If a server dies...

Not a problem, glad all is working for you.

I found PBM to be a bit tricky first time I started using it, but you soon learn the ways of doing...

Check the SIDs of both users on each server, I suspect they are different.

If they are you need to add a mapping on the linked server configuration to mapp LL_LOGIN...

The training partner where I did all the training with was QA, they are pretty good in all honesty and got plenty of sites in London.

Well it all depends on your RTO and RTP as to which to choose and if you want hot, warm or cold standbys.

If you know this information then you can...

@Update or @Insert should be = True and @Name should be LIKE 'TRI%' or 'TRU%' depending on the trigger. They will need to be evaluated in the same condition

@Update...

2 CPUs, each with 4 cores, would mean you need to purchase 8 core licenses for SQL.

I have attached the QRG which contains some pricing, but to get latest prices,...

Not used litespeed in a while, but are you using the dynamic compression feature where it determins the best compression level or have you just set it to the max...

From reading, but this might be totally wrong.

As a checkpoint rights information relating to the transaction log as well as dirty pages to disk, if the transaction is not commited...

Would want to use the trigger facet, with name and either insert or update depending on the trigger as the conditions

If you run the copy manually then run the pkgmgr on its own does it still error?

Please explain a bit further.

Are you talking about tools to manage and query SQL? If so give them SSMS and limit what they can do to the database via...

As with anything licensing, speak to Microsoft or your reseller direct.

I have attached the QRG for SQL 2012 licensing.

Typically mirrored servers dont require licensing as long as no user activity...