AmarettoSlim (5/22/2013)
Can someone explain why SQL Server doesn't support object level recovery in a native manner?
Because doing so would allow a native restore to result in a transactionally inconsistent database (imagine restoring the Client table and Invoices tables but not the Sales table, could mean that afterwards a client has an invoice for items that are not recorded as sold.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability