RE: Restrict insert or update when taking backup

SSC Guru

Points: 1003853

December 13, 2012 at 8:41 pm

GilaMonster (12/13/2012)
rajkiran.panchagiri (12/13/2012)
Is there any other way other than this?
Not really. Setting the DB to read only or single user for the duration of the backup is the simplest. The question is why you want to prevent data changes during a backup.

I agree with Gail. Why would you want to restrict access during a backup?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)