Part eight in the series covers the enhancements to backup and restore in SQL Server 2005, aimed at keeping the maximum amount of data always available. The discussion focuses on online restore and piecemeal management in particular. Learn how the SQL Server 2005 database remains online during a restore, and how during a fast recovery the database is available from the moment the undo begins. We also show how SQL Server 2005 allows a database to be online even if a file within the filegroup is ...

Read more