Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How does SQL handles space assigned to objects?

Status
Not open for further replies.

TheBugSlayer

Programmer
Sep 22, 2002
887
US
Hi all. My question is a bit broad.
Some table were deleted from a DB a was just recreated after a crash, there was no backup yet.

Thanks to Log Explorer we could retrieve only one of the tables. My question is why the rest of the tables could not be recovered? Is it that the space they occupied was assigned to other objects? If yes I would like to understand the process.

Thanks for your help.

(I am making an analogy with the way the OS used to handle memory bak in the days of MS-DOS, Norton Commander 5 and all the likes).
 
Sorry, just refreshing the question since there has been no answer so far.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top