sql server msde: First, the maximum size for a SQL Express database is 4GB so I'm not sure
how you're creating a 7GB database. Recovery is when the database goes
through its log and redoes any transactions committed since the last
checkpoint in the log. For a 7GB database, this normally only takes a
couple minutes so I assume there is something strange happening in your case
unless you are very short on memory or have very slow disk drives. SQL
Express uses SIMPLE recovery mode by default so there shouldn't be a lot of
recovery required. The most common cause of long recovery time is the
database being killed without going through an orderly shutdown - for
example turning off the machine without shutting it down or having too long
a checkpoint interval. You could try doing a checkpoint command right
before shutting down the database to see if infrequent checkpoints are
causing this.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

I have a fairly large database that takes up around 7GB of space on my hard
drive and on top of that, one of the tables in the datatbase with about 25
plus columns has 4 million rows. The problem I am getting is whenever I
restart the SQL Server service or at bootup, my database shows an (In
Recovery) message and it takes about 20 minutes before I can actually use
the db and make a query against it. Is there anyway I can avoid this In
Recovery process? Anyone know what is going on during this process? Are
indexes being rebuilt. I did notice that memory is consumed by the sql
server process during the 20 minute In Recovery phase in 8K blocks (same
size as database pages) Appreciate any help.

-Dave-