When restoring a large SQL Server database (double-digit GBs) insure that the backup file is not on the same physical drive that your data file will reside. Having them on the same drive seems to slow down the restore process 10 fold. That number is pulled
Read More...
Read the complete post at http://feeds.feedburner.com/~r/DiggingMyBlog/~3/128422812/restoring-large-sql-server-databases.aspx