GilaMonster (1/25/2011)
jts_2003 (1/25/2011)
What would be great is an easy way of backing up (and restoring) just a table... maybe in Denali?No, and I doubt it will ever be a native feature. It allows the database to be in a transactionally inconsistent state. Lots of the 3rd party backup tools can do that, and others allow the backups to be 'mounted' as if they were actual databases (RedGate's Hyperbac for eg)
I keep a DB called Guff I use for importing data I need to compare to data in my other DBs (before I arrived the old way was just to import them to the production DBs so there were tables like stuffJan, GavsTable3 all over the shop).
If I am about to muck about with lots of updates to a table I often just export it to Guff beforehand so that I can run data comparisons and so on afterwards.
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]