Recover and Roll back SQL DB State

Question

Friends,

I'm looking for an solution on SQL DB server. I'm being working in support organization on managing SQL Server.

When we make some changes on SQL DB (Schema changes, table alteration, data etc..) and found it is not compatible we need to roll back easily.

Something like, before i make any changes on my DB server need to preserve current state of DB and once changes were made and if looks good then i can commit permanantly. If not working properly i can discard the changes and revert to previous state quickly.

Is there any such option available?

can't it be done using trigger? – Rahul Apr 15 '14 at 13:12 — Rahul, Apr 15 '14 at 13:12

score 0 · Answer 1 · answered Apr 15 '14 at 13:16

0

You can create Database Snapshot which helps to prevent administrative error.

Here is a link that can help you understand how to create and apply database snapshot:

Database Snapshot

answered Apr 15 '14 at 13:16

veljasije

6,722
12
48
79

I will try on this. Meanwhile did anyone setup this already? If yes, does it affect with DB Size? – baluchen Apr 22 '14 at 09:19

Recover and Roll back SQL DB State

1 Answers1