The Multifunctioning DBA

Sep 23 2011   1:32PM GMT

DR SQL Server Memory Test

Colin Smith Colin Smith Profile: Colin Smith

My new company has a DR Test coming up and we came up with a great idea on how to make the SQL Servers test pretty simple. We use SAN Block level replication so we should be able to mount up our shared disk to any server that has the correct version of SQL Server installed. One question that we had though was that if SQL Server is configured to take say 1024 MB of memory minimum but the server only has 4 GB total would it start up. The answer is yes it will. I tested this using SQL Server 2008 running in Virtual Box. I had SQL Server set up to grab 1024 MB minimum at startup. I shut down the VM and configured the maching to only have 52MB and then I started it back up. SQL Server came up just fine. So this tells me that it will start up and then we can modify the settings to be what we would like.

Hope this helps.

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: