SQL Server with Mr. Denny

Aug 26 2010   11:00AM GMT

Be careful were you place that Windows 2003 page file

Denny Cherry Denny Cherry Profile: Denny Cherry

If you are building a Windows 2003 cluster (yes I know it’s out of support, but so is SQL Server 2000 and lots of people are still using that) you need to be very careful where you put the page file.  If you put the page file on local disk there won’t be any problem, but if you put the page file on the SAN for increased performance then any other disks on that same storage bus won’t be able to be clustered.

Nice feature hugh.

When you look for the disks to cluster them in the Cluster Administrator the ones on the shared bus won’t be available, and if you try and cluster them using the cluster.exe command line tool you’ll get “System error 87 has occurred (0×00000057) The parameter is incorrect.”.  So move the page file back to local disks, and then you can cluster your SAN storage.

Denny

 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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: