Thank you for the post, free_mascot, interesting one. (couple of days ago, was searching the google for back/restore articles any newly written... and I came across one where this word "piecemeal" was mentioned, though I did not read it what it was about, but my first impression was some kind of made up name... and weird for me to find an entry in the local_help index... well ...
In the local help, at first it says
"This topic is relevant only for databases in the Enterprise edition of SQL Server that contain multiple files or filegroups; and, under the simple model, only for read-only filegroups."
"Piecemeal restore works with all recovery models, but is more flexible for the full and bulk-logged models than for the simple model. "
failed to co-relate them. One day I will see these in action, I suppose, as restoring FGs... in a decent and consistent way... should become a default practice.. :-)
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.