"stop before startup" after "Using large pages for buffer pool" during SQL Server startup

Worked on a SQL Server startup issue which I would like to share here: Here is how the SQL Server errorlog looked like 2012-04-19 03:43:26.50 Server Microsoft SQL Server 2005 – 9.00.4035.00 (Intel IA-64) Nov 24 2008 12:59:53 Copyright (c) 1988-2005 Microsoft CorporationEnterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)……2012-04-19 03:43:26.52…

0

Restore database stuck at 90% waiting on PREEMPTIVE_OS_WRITEFILEGATHER

There are already few blogs and a KB to talk about this problem so I’m trying to tie them together to make sure you get this quickly When you are restoring a database (in my case a database having 32 files), post 90% complete, all but one threads in sysprocesses went into SUSPENDED state waiting…

1