Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
2
Newest
 Teacher
Impact
~235 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
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