Thanks for the reply.

We have transactional replication here. The distribution database has already been set to 90 mode.

Is there anything else I should do, like update statistics once...

Yes, the database is in log shipping standby mode. I did it all the time in sql 2000 by first shutting down sql server, then copy the data file and...

Thanks much!

Thanks! I will give it a try.

Since we have not got the new servers from the hosting domain yet, I tried running some testing using sql 2005 replication security model, and it happened to work out...

Thanks for the reply.

I was actually reading 'replication security best practices' on books online. One of the practices is to 'run each replication agent under a different windows account'....

Thank you for the info. It is very helpful.

I did not personally intalled it, but @@version says sp1.

Its actually sql 2005 standard edition, sp1.

After having the server run throughout the night, looking from task manager, sqlserv.exe is now settled with 6.5GB memory (even though the max server...

Then what does setting max memory for sql server do?

Actually after I enabled the 'show advanced options', I do see those configuration values:

max server memory (MB): 16(min) 2147483647(max) 6144(config_value) 6144(run_value)

min server memory (MB):  0(min) 2147483647(max) 5120(config_value) 5120(run_value)

Does it look like the configured values will be used?

Thanks for the response.

Sorry, its SQL SERVER 2005.

When I run sp_config, in sql server 2005, it does not show min/max memory options, as you see in sql server...

Thanks for reply!

Hi, John, I ran the command

sqlservr.exe -f -m -s two

to try to start the instance and got the following error in sql server log:

2006-09-07 15:45:12.44 server    Copyright (C) 1988-2002...

Thanks all for the reply.

I actually was not able to bring sql server service online. So I could not do/view anything. John, I think you are right, if I...