I understand your point and I already have the Ola Hallegren scripts in place. Just undertand this.

I do have Sql Server Standard Edition and I can't do index...

Agree with the previous answer, but also you can have an standard edition and use mirroring. The only thing you can't use some of the best features like, partitioning, online...

I already have the mirroring in place.

But in order for me to do maintenance i need to break mirroring and keep both databases open.

One database will be live receiving...

The Merge replication creates a new column and that is making the new inserts to fail.

What i wanted is to create transactional replication.

The steps are as follow

Break Mirroring. Open...

This is what exactly we are doing with an store procedure. Deleting in batches of 1500 rows looping 5 times and then when traffic is slower we do it...

It has to be always active. we are doing the deletion right now and is taking forever which affect performance, logs,mirroring etc.

Than means if i did an update I can not rollback if i did not specify that Begin Transaction.

Thanks for such quick response.

That put me in the right direction.

Paul Vidal

DBA

I was researching and i find out that the mirroring offers exactly the same as oracle Dataguard.

But also found that is going to be deprecated soon, but is still available...