Nasir Razzaq
asked on
Undo an Update Query
Hi Experts,
I have done this thing second time in my life. Ran an Update query without a Where clause!
I have no DB backup. What are my options?
Its SQL Server 2008.
I have done this thing second time in my life. Ran an Update query without a Where clause!
I have no DB backup. What are my options?
Its SQL Server 2008.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tried the Log Rescue. Installs ok but never connects with always saying the server component not installed.
Log Rescue is for SQL 2000 only. Doesn't support 2005 or 2008 since Microsoft altered the log format.
Lee
Lee
apologies, missed the part where you said SQL 2008
as I told you in very first post that without backups, you can't do anything.
ASKER
Does it mean that there is no such tool as Log Explorer or Log Rescue which works with SQL Server 2008?
You could try this page for further help:
http://sqldbpool.com/2008/04/16/how-to-read-transaction-log-data-in-sql-server-20002005/
Lee
http://sqldbpool.com/2008/04/16/how-to-read-transaction-log-data-in-sql-server-20002005/
Lee
Or try APEX SQL Log viewer
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
As I said earlier, I have been trying the Apex SQL Log. I tried all methods including installing client on client computer and server on server computer, installing both on client computer, and installing both on server computer but in all cases when i try to use it says server components are not installed properly.
One thing I noticed is that it ran *Uninstall*.sql when installing and also ran this when uninstalling so may be a problem with their installer!
One thing I noticed is that it ran *Uninstall*.sql when installing and also ran this when uninstalling so may be a problem with their installer!
You haven't mentioned you've tried Apex.
Anyway, what recovery model is set on your database?
(http://msdn.microsoft.com/en-us/library/ms189272.aspx)
If your recovery model is Simple then nothing is backed up in your transaction log.
If its full, try using methods described in:
http://searchsqlserver.techtarget.com/tip/How-to-restore-from-a-transaction-log-in-SQL-Server?ShortReg=1&mboxConv=searchSQLServer_RegActivate_Submit&
Btw, I'm in similar situation an hour ago I've dropped all UDFs from development machine instead
from deployment machine where I wanted to transfer those new I've been programming for last
two days.
Br
Ivan
Anyway, what recovery model is set on your database?
(http://msdn.microsoft.com/en-us/library/ms189272.aspx)
If your recovery model is Simple then nothing is backed up in your transaction log.
If its full, try using methods described in:
http://searchsqlserver.techtarget.com/tip/How-to-restore-from-a-transaction-log-in-SQL-Server?ShortReg=1&mboxConv=searchSQLServer_RegActivate_Submit&
Btw, I'm in similar situation an hour ago I've dropped all UDFs from development machine instead
from deployment machine where I wanted to transfer those new I've been programming for last
two days.
Br
Ivan
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Had to do the data entry again. Thank you all for trying to help.
ASKER