The idea is to have a warm standby server for another warm standby server. Because we need the first server as the reporting server, we dont want to bring it...

If I attach the dbs, can I attach them as 'standby'? Because on the first server, I have 9 standby servers and I want to keep them in nonrecovery mode...

I would like to know how to simulate the transaction volume on development environment.

Thanks!

Thanks John. Does turning on PAE switch help at all?

I dont think awe is enabled. Here is the entry from sp_configure :

name ...

Thanks for the thought. The machine is running OK now. We used to set the memory for both instances to be 0-4GB(which is the total amount of memory on the...

Thanks all for the thoughts. Here is our scenario: --the memo field could potentially be very lengthy, with the limitation on the varchar field (8000 char), its not quite feasible...

Thanks, Steve. Yes, could be. In fact, thats how we are doing now. But since memo field is a text field, its very slow to use 'like'. I am trying...

Thanks, Andy. I tried it, didnt work tho. I read about the string that u can put in the double quote, its called 'prefix term', meaning it returns results with...

Thanks Allen. But I think this article might not apply to us. We have always been using sql server 2k. The odd thing is the error message always comes after...

Thanks for responding.

I will give it a try.

Kathleen

I ran

DBCC TRACESTATUS(-1)

GO

on each of the database on the server, none of them have any trace flags turned on.

Any more thoughts on these messages?

Thanks,

Kathleen

Thanks for the reply.

Sorry I missed one last message that says: 'LazyWriter: warning, no free buffers found.' So its like all seven messages keep showing up one by one....