Appreciated if someone please take a moment to answer this?

How do i know its actively using all?

Well the counter Total Server memory tells - how much memory the instance is using. Also from the windows task manager - I...

Thanks you SSC - you are just great.

I looked at the provided URL's and have one last question. So say if i am running SQL 2005-64 bit with 64 GB...

Thanks for the post.

In what cases do i have to assign the policy "Lock pages in memory" to the service account? I.E say if i have SQL 2005-64 bit with...

24 GB!

Thanks for the contribution. I am indeed running SQL2005-enterprise edition. i am going to enable the lock memory pages. but in-case i dont enable this option - what are the...

Thanks a ton for the answers. You guys are great.

thanks for the feedback.

Thanks for the answer. My warm stand by environment is pointing to a different apps server and having this serve name in production table might not make any sense. Additionally...

The purpose of going with logshipping was to have a automatic sync of stand by database every 30 minutes. Transfering all the accumalative changes from source to target through DTS...

The stand by database is read only. I believe DTS wont work here.

Thanks everyone for your contribution. Looks like Logshipping has all what i am looking for. i started reading more about logshipping and have to plan out to implement it.

Thanks for the answer.

Restore log with file option will load the static number given to the restore. I want to run this restore command all automated and there wont be...

Thanks for the answer. What i am planing on doing is backing up to 2 locations. The one with init will be used to refresh my stand by database (for...

Ten,

Tried the new code (EXEC) and it worked fine. Thanks a million for your assitance.

Cali