This isn't actually possible. You'd need to be using SQL replication or something to merge the writes.
Thanks, Brian Desmond [email protected] c - 312.731.3132 From: Jim Holmgren [mailto:[email protected]] Sent: Wednesday, July 07, 2010 1:37 PM To: NT System Admin Issues Subject: RE: Network Share unshares Your cluster is presently in an Active/Passive config, which great for high availability but does nothing for end-user performance. You would need to go Active/Active if you are looking to load balance and provide a performance increase. Before you do that - you may want to look into your storage configurations to make sure your SQL storage (DB, Log, TempDB, etc) is optimized. Jim Jim Holmgren Manager of Server Engineering XLHealth Corporation The Warehouse at Camden Yards 351 West Camden Street, Suite 100 Baltimore, MD 21201 410.625.2200 (main) 443.524.8573 (direct) 443-506.2400 (cell) www.xlhealth.com<http://www.xlhealth.com> From: Cameron Cooper [mailto:[email protected]] Sent: Wednesday, July 07, 2010 1:27 PM To: NT System Admin Issues Subject: RE: Network Share unshares This should probably be another topic (hacking my own)... Currently we have the two clustered with one as the active node and the other as the inactive, is there a way that we can setup the two to load balance the database? _____________________________ Cameron Cooper Network Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected]<mailto:[email protected]> | www.aurico.com From: Richard Stovall [mailto:[email protected]] Sent: Wednesday, July 07, 2010 12:17 PM To: NT System Admin Issues Subject: RE: Network Share unshares You're welcome. It should bounce over to the inactive node just like SQL and any other configured resources. From: Cameron Cooper [mailto:[email protected]] Sent: Wednesday, July 07, 2010 1:15 PM To: NT System Admin Issues Subject: RE: Network Share unshares Thank you sir. Setup the resource and will see what happens when the server is restarted tonight. _____________________________ Cameron Cooper Network Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected]<mailto:[email protected]> | www.aurico.com From: Richard Stovall [mailto:[email protected]] Sent: Wednesday, July 07, 2010 11:55 AM To: NT System Admin Issues Subject: Re: Network Share unshares You have to make the share a clustered resource. Just create it in the cluster admin tool. On Wed, Jul 7, 2010 at 12:54 PM, Cameron Cooper <[email protected]<mailto:[email protected]>> wrote: We have two SQL Servers clustered into a Dell MD3000 and have a folder that is shared. When either of the clustered servers restarts the share is gone. Any ideas on how to resolve this? _____________________________ Cameron Cooper Network Administrator | CompTIA A+ Certified Aurico Reports, Inc Phone: 847-890-4021 | Fax: 847-255-1896 [email protected]<mailto:[email protected]> | www.aurico.com<http://www.aurico.com> CONFIDENTIALITY NOTICE: This email, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or protected health information. Under the Federal Law (HIPAA), the intended recipient is obligated to keep this information secure and confidential. Any disclosure to third parties without authorization from the member of as permitted by law is prohibited and punishable under Federal Law. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. NOTA DE CONFIDENCIALIDAD: Este mensaje incluyendo cualquier anejo es para uso exclusivo del (los) destinatario (s) y puede incluir informaci?n confidencial y/o informaci?n de salud protegida. La Ley Federal (HIPAA) establece que el destinatario est? obligado a mantener la informaci?n confidencial y sequra. HIPAA proh?be y castiga cualquier divulgaci?n a terceras personas sin autorizaci?n del afiliado o permitido por ley. Si usted no es el destinatario, redirija esta mensaje al remitente, y destruye cualquier copia existente del mensaje original. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
