thanks Gail

😛

thank you that is exactly what I am looking for.

I am moving my master database to a different server to test disaster recovery. Our 2000 boxes have no high avialibility so I need to get them up ASAP. If...

thanks.. I think that gave me what I needed:-)

so you are saying that there isn't a way to change the directory of tempdb on a different server if it does not exist in the current directory where it...

using dbcc checkdb with physical_only runs faster but does nothing from increasing the total memory to be equal to target memory.

thank you Richard

Thanks for everyones help.

Ok I cannot increase the amount of RAM to 14GB without causing paging (usually triggered by %committed bytes in use over 80%).

I would prefer to look at...

yes that is helpful - thanks

yep I have set the max mem. I have 16GB and 5 instances.

max mem is as follows

inst1 1GB - 1 database mirrored

inst2 500MB - 3 databases mirrorred 2, databases unmirrored

inst3...

the problem is that after I run it the .memory_manager.total server memory increases to the target server memory and does not let up until a restart. I have experienced...

thanks Roy.. I believe clustering is expensive - I don't think my boss will go for that.

Presently we are using mirroring and having a small problem with applications having ...

thanks Steve.

Oh isql - is that like sqlcmd?

If so does that mean restoring the master is same as restoring master on 2005 except you use isql instead of sqlcmd?

I thought perhaps I could use trans replication to migrate a 2000 database to 2005 with hopefully no (or next to no) downtime - I have a 2000 box that...