|
|
Posted by codefragment on 11/10/07 21:29
> But the real question is what you really want to achieve and why you want
> to do it onSQL2000. This sounds like a perfect scenario for database
> snapshots, a new feature inSQL2005.
We use sql 2000 and sql 2005, mainly the former, and our customers are
on sql 2000 so
I tend to that.
That being said what I want is an aid for developers so we could use
sql 2005.
We run through a process to debug some
problem, we then want to revert the database back to the state it was
in so we can repeat that
process to help in debugging. At the moment I can get around this by
making a note of the tables
involved and use deletes, inserts to get the data back to how I want
it but it would be nice if
I could just click 'backup' and and then later revert. If it was fast
it could be a real help.
Navigation:
[Reply to this message]
|