Welcome to weblogs.com.pk Sign in | Join | Help

Don’t Issue Unplanned Queries, Especially In a Hurry

Just a piece of advice: Don’t login to your database when you don’t have enough time. If you are logged in, then never give any update/delete/insert/create/drop commands. I have just lost some data, I specified wrong month in the query L

 

Anyways it’s always a good practice that you plan well before issuing any command!

Published Friday, September 03, 2004 5:13 PM by khurram
Filed under: ,

Comments

# re: Don’t Issue Unplanned Queries, Especially In a Hurry

Saturday, September 04, 2004 10:41 AM by Sohaib AtharT
Hi Khurram,
You can restore the database to a point in time using its transaction log. Have you tried that?

# re: Don’t Issue Unplanned Queries, Especially In a Hurry

Sunday, September 19, 2004 12:50 PM by khurram
One need to have the backups of the transaction logs and data. I used Lumigent's Log Explorer to recover the data.
New Comments to this post are disabled