> I have inadvertently modified 2500 records in my SQLServer 2000 db
> (forgot the 'where' predicates in the query!) and need to roll the db
> back to just before the update.
> I have a complete backup from about 7 days ago but no transaction log
> Is there anyway I can achieve this - without buying any software?!
Depends. If you are running in simple recovery mode, your only
chance is that the unfortunate WHERE clause is still in the log,
and you can use Lumginet's Log Explorer to clean up the mess.
If you have not truncated the log at all since the backup seven days
ago, yes then you can do it. Backup the transaction log, restore the
database, and the make point-in-time recovery of the transaction
which stops just before the time you performed the fatat UPDATE.