The stored procedure is interesting. However it does require a lot of prerequisites and open security holes that PCI-DSS would not allow (for example like distributed transaction).

Moreover, the stored procedure...

Just a quick comment:

I have to deal with large deletes as well and even with setting up rowlock and limiting the size of my deletes batch, I end up with...

A client request.

The client wants to be able to do rebase of the production database onto a development box.

They have already the database in a clustered server but they...

Add the subfolder and see if it helps.

cool. Tanks.

grea answer! This is a good news. I never thoughtI can do a snapshot on a database "in-recovery".

I am going to check this. cool.

Thanks

oh yes I forgot. My application server is also mirror-aware.

Thank you very much for this answer.

When ou talk about snapshot, are you considering snapshots on mirrored databases ? because the mirrored databases are in recovery state, so I thought...

I agree with blandry.

My answer a couple of answers above, was not an answer.

It was kind of trying to find a solution so that your production servers are sizeable.

Saying...

The questions are:

1. Is my solution ok or stupid? Before setting this up, I would like some thoughts from experienced gurus 🙂

2. what does SQL clustering will add to this...

I do not need to replicate any changes for one principal server to another principal one as it only contains different sessions and "transactions"*. I would use database mirroring only...

Thanks for the quick reply. I apreciate your answers.

I saw how effective application clustering is (by watching a load testing), so I am 100% under the application clustering solution.

Database mirroring...

I agree. Be more practical on the questions.

The no backup solution was obvious but I do not understand why you cannot take another snapshop, to cancel all changes.

This is my first reply to a topic on SQLServerCentral. I have been a dba for 10 years. Sometimes I feel that I do not have the knowledge you all...