need your advice on SQL performance

Hi all,
I just restored on edatabase on the new server (windows 2003 R2). The
performance is very slow. I checked the event log and it shows"
Bypassing recovery for database 'Marketing' because it is marked IN LOAD".
Could this cause the slowness and what does this mean and how to fix it?
Thanks.John
Did you perform RESTORE operation with WITH RECOVERY option?
"John" <John@.discussions.microsoft.com> wrote in message
news:66C3A076-83A7-49EB-B8FF-25C4504AE72E@.microsoft.com...
> Hi all,
> I just restored on edatabase on the new server (windows 2003 R2). The
> performance is very slow. I checked the event log and it shows"
> Bypassing recovery for database 'Marketing' because it is marked IN LOAD".
> Could this cause the slowness and what does this mean and how to fix it?
> Thanks.|||Yes. I still get this message in the log. Do you know what exacly this
message mean?
Thank you for your help.
"Uri Dimant" wrote:
> John
> Did you perform RESTORE operation with WITH RECOVERY option?
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:66C3A076-83A7-49EB-B8FF-25C4504AE72E@.microsoft.com...
> > Hi all,
> >
> > I just restored on edatabase on the new server (windows 2003 R2). The
> > performance is very slow. I checked the event log and it shows"
> > Bypassing recovery for database 'Marketing' because it is marked IN LOAD".
> > Could this cause the slowness and what does this mean and how to fix it?
> >
> > Thanks.
>
>|||John
http://www.sqlteam.com/Forums/post.asp?method=ReplyQuote&REPLY_ID=162149&TOPIC_ID=48723&FORUM_ID=6
"John" <John@.discussions.microsoft.com> wrote in message
news:C9245618-33F2-442D-BF5E-C3155E6DE86C@.microsoft.com...
> Yes. I still get this message in the log. Do you know what exacly this
> message mean?
> Thank you for your help.
> "Uri Dimant" wrote:
>> John
>> Did you perform RESTORE operation with WITH RECOVERY option?
>>
>> "John" <John@.discussions.microsoft.com> wrote in message
>> news:66C3A076-83A7-49EB-B8FF-25C4504AE72E@.microsoft.com...
>> > Hi all,
>> >
>> > I just restored on edatabase on the new server (windows 2003 R2). The
>> > performance is very slow. I checked the event log and it shows"
>> > Bypassing recovery for database 'Marketing' because it is marked IN
>> > LOAD".
>> > Could this cause the slowness and what does this mean and how to fix
>> > it?
>> >
>> > Thanks.
>>