Some related posts from Technorati and Google.

 [Searchsqlserver.techtarget.com] Online restore feature in SQL Server 2005: After that, establish whether you will be able to take advantage of online restores if you break down your database into multiple filegroups. For additional information about online restores, take a look at SQL Server 2005 Books Online or download a copy of the Developer Edition and try this new feature to see if it makes sense for your environment.

 [SQL Server Storage Engine] Why you should NOT optimize your backup strategy... : Sounds kinda funny, doesn't it? I mean, who here doesn't have someone breathing down your neck every time you go past your backup window?

[Blog Home Page] Blending SMO and Transact-SQL to create... : The Database object in SMO has read-only properties to tell you if a given database is a snapshot or not, but I didn't find anything to allow me to set the properties before creating the database so I returned to Transact-SQL to create the database. Because snapshots are based on the file system features you need to specify each file used by the database (not the log, because the snapshot is read-only), so you need to loop through the FileGroups collection, evaluate each Filegroup to find the DataFileCollection, then loop through that to find each data file.

Reflected tags on Technorati: Blog, Sql Server Restore Database, Data Recovery Reports