1) Hopefully your dba does nightly backups and worst case scenario you lose
1 days worth of data.
2) CF generates an automatic commit, so if you tinker with any data in a
cfquery tag, there is no rollback for you. ( Also if you issue and ddl or
dcl commands)
-george
>From: Jennifer <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Community <[EMAIL PROTECTED]>
>Subject: Re: Lost my SQL database and need help restoring
>Date: Sat, 09 Jun 2001 12:23:36 -0500
>
>At 06:28 AM 6/9/2001 -0400, you wrote:
> >Okay. Gotta come right out and admit the dumb thing I did. I scripted a
> >database and ran the script in that database rather than the new
>database.
> >So everything got dropped and recreated. Not good.
>
>One of my coworkers once ran a script to update the price of a product but
>forgot the where clause.
>
>Don't feel too bad. These things happen sometimes. Luckily, I have managed
>to not do anything like this yet. The missing where clause incident made me
>pretty paranoid. There's nothing like hearing your senior programmer
>screaming to instill The Fear.
>
>What you might be able to do is run a rollback. Some databases will let you
>rollback to a certain date. I've seen this done with a couple of databases,
>but SQL 7 isn't one of them. It might be possible with SQL 7 but I just
>don't know. If it is possible, then it'll be an easy solution for you.
>Besides, it would be good to know that if you run an update without a where
>clause, you could recover after only a few minutes of freaking out.
>
>
>Now available in a San Francisco Bay Area near you!
>http://63.74.114.11/mr_urc/index.cfm
>http://63.74.114.11/mr_urc/resume.cfm
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
