Here's a quick tip for you:
During some restore operations in SQL Server, the transaction log redo step might be taking an unusually long time. Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. To do this, you should use the
MAXTRANSFERSIZE parameter of the
RESTORE statement. For example, if you set
MAXTRANSFERSIZE = 1048576, it'll use 1MB buffers.