111 reputation
2
bio website
location
age
visits member for 2 years, 10 months
seen Mar 29 '13 at 23:29

Sep
8
awarded  Teacher
Sep
7
answered How can I automate clearing and resetting a Linux user's home directory to a default?
Aug
31
comment SQL Server 2005: Row in backup, missing in database
Yes, the row was probably deleted from the table by the time we made the backup. But if I open the .bak file using Notepad++ and make a search, I can still find the information inside. So I would like to know if there is some MSSQL "trick" to recover this old data still in backup file.
Aug
31
revised SQL Server 2005: Row in backup, missing in database
More accurate
Aug
31
comment SQL Server 2005: Row in backup, missing in database
Thanks for your answer. This is what I did so far: restore database restoredb from disk ... with ... recovery. Then, select * from restoredb.myschema.mytable where myfield = XXX, but it does not get the row I'm looking for. What am I missing?
Aug
30
awarded  Editor
Aug
30
revised SQL Server 2005: Row in backup, missing in database
More accurate title
Aug
30
asked SQL Server 2005: Row in backup, missing in database