I have a complete transaction log file from the start of the existance of the database ( a year or so). I mistakenly deleted about 2K rows in 1 table. The database has never been backed up.
I would like to get the rows back of course. I was thinking along the path of making a backup of the the databse and log, then restoring to a STOPAT point (just before mistake). When I backup the I only get a small log backup, not the complete 76 MB log, using the NO_TRUNCATE option or not...
I've tried "attaching" the big log to a new database, putting the new db in "suspect" mode, then doing a backup, but I still just get a tiny log backup?????
How can I get a backup operation to backup the entire log, so I can do a RESTORE ... STOPAT afterwards ?
or
How can I re-apply my complete transaction log to an empty db, just up to a STOPAT point?
Thanks
Once you understand the BITs, all the pieces come together