dbTalk Databases Forums  

SQL Server and File Server

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL Server and File Server in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jacques Demers
 
Posts: n/a

Default SQL Server and File Server - 10-24-2007 , 02:37 PM






Hi,
Can someone give me an opinion with installing SQL Server 2005 with
clustering and use those servers for file servers at the same time.
Thanks
Jacques



Reply With Quote
  #2  
Old   
Russ Kaufmann [MVP]
 
Posts: n/a

Default Re: SQL Server and File Server - 10-24-2007 , 03:29 PM






"Jacques Demers" <jacquesdemers (AT) hotmail (DOT) com> wrote

Quote:
Hi,
Can someone give me an opinion with installing SQL Server 2005 with
clustering and use those servers for file servers at the same time.
Thanks
Jacques
What are the business requirements? If you are clustering because of a SQL
need, which is probably an extremely vital need, then adding file sharing on
top of it will result in increased risks to your SQL environment. The whole
purpose of doing High Availability is to reduce risk, and this configuration
would not be the best solution.

If the company has a huge demand for redudant file services, then consider
either a second cluster or implementing DFS with replication.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 21 - 24 in New York



Reply With Quote
  #3  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL Server and File Server - 10-24-2007 , 03:32 PM



Don't.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Jacques Demers" <jacquesdemers (AT) hotmail (DOT) com> wrote

Quote:
Hi,
Can someone give me an opinion with installing SQL Server 2005 with
clustering and use those servers for file servers at the same time.
Thanks
Jacques



Reply With Quote
  #4  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL Server and File Server - 10-24-2007 , 03:56 PM



Had to go with the verbose version, didn't you?

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Russ Kaufmann [MVP]" <russ (AT) clusterhelp (DOT) com> wrote

Quote:
"Jacques Demers" <jacquesdemers (AT) hotmail (DOT) com> wrote in message
news:%23wq7SVnFIHA.1388 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
Hi,
Can someone give me an opinion with installing SQL Server 2005 with
clustering and use those servers for file servers at the same time.
Thanks
Jacques

What are the business requirements? If you are clustering because of a SQL
need, which is probably an extremely vital need, then adding file sharing
on top of it will result in increased risks to your SQL environment. The
whole purpose of doing High Availability is to reduce risk, and this
configuration would not be the best solution.

If the company has a huge demand for redudant file services, then consider
either a second cluster or implementing DFS with replication.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 21 - 24 in New York


Reply With Quote
  #5  
Old   
Russ Kaufmann [MVP]
 
Posts: n/a

Default Re: SQL Server and File Server - 10-24-2007 , 04:44 PM



"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote

Quote:
Had to go with the verbose version, didn't you?
Not only the verbose version, but I still beat you to it by three minutes.
<G>


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 21 - 24 in New York



Reply With Quote
  #6  
Old   
Jacques Demers
 
Posts: n/a

Default Re: SQL Server and File Server - 10-25-2007 , 07:40 AM



Thank you guys.

"Russ Kaufmann [MVP]" <russ (AT) clusterhelp (DOT) com> a écrit dans le message de
news: D44B6F30-471A-4628-81BA-761637187EA1...soft (DOT) com...
Quote:
"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote in message
news:eedMbBoFIHA.3716 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
Had to go with the verbose version, didn't you?

Not only the verbose version, but I still beat you to it by three minutes.
G


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 21 - 24 in New York



Reply With Quote
  #7  
Old   
Jacques Demers
 
Posts: n/a

Default Re: SQL Server and File Server - 10-26-2007 , 09:55 AM



Hi Russ,
Thank you for the information. But I should have explain a little more why
we want to install SQL Server 2005 in cluster on the file servers who are
already using Microsoft cluster. The reason is that we want to install
SharePoint Portal Server 2007 with SQL Server 2005 in clustering*. When
SharePoint will be accessible the files on the file servers would eventually
be transfered in the portal on the SQL server. This way the files servers
would eventually becomes only SQL servers. What do you think, do you think
the servers would be able to take the load?
Thank you
Jacques


"Russ Kaufmann [MVP]" <russ (AT) clusterhelp (DOT) com> a écrit dans le message de
news: D44B6F30-471A-4628-81BA-761637187EA1...soft (DOT) com...
Quote:
"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote in message
news:eedMbBoFIHA.3716 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
Had to go with the verbose version, didn't you?

Not only the verbose version, but I still beat you to it by three minutes.
G


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 21 - 24 in New York



Reply With Quote
  #8  
Old   
Russ Kaufmann [MVP]
 
Posts: n/a

Default Re: SQL Server and File Server - 10-26-2007 , 10:20 AM



"Jacques Demers" <jacquesdemers (AT) hotmail (DOT) com> wrote

Quote:
Hi Russ,
Thank you for the information. But I should have explain a little more why
we want to install SQL Server 2005 in cluster on the file servers who are
already using Microsoft cluster. The reason is that we want to install
SharePoint Portal Server 2007 with SQL Server 2005 in clustering*. When
SharePoint will be accessible the files on the file servers would
eventually be transfered in the portal on the SQL server. This way the
files servers would eventually becomes only SQL servers. What do you
think, do you think the servers would be able to take the load?
Nobody here can answer that for you. It completely depends on your
environment.

--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 21 - 24 in New York



Reply With Quote
  #9  
Old   
Jacques Demers
 
Posts: n/a

Default Re: SQL Server and File Server - 10-26-2007 , 10:34 AM



Thank you

"Russ Kaufmann [MVP]" <russ (AT) clusterhelp (DOT) com> a écrit dans le message de
news: 3D2E2893-C8C9-4473-A5EE-D06D6C0CFC81...soft (DOT) com...
Quote:
"Jacques Demers" <jacquesdemers (AT) hotmail (DOT) com> wrote in message
news:eRIlSB%23FIHA.3672 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Hi Russ,
Thank you for the information. But I should have explain a little more
why we want to install SQL Server 2005 in cluster on the file servers who
are already using Microsoft cluster. The reason is that we want to
install SharePoint Portal Server 2007 with SQL Server 2005 in
clustering*. When SharePoint will be accessible the files on the file
servers would eventually be transfered in the portal on the SQL server.
This way the files servers would eventually becomes only SQL servers.
What do you think, do you think the servers would be able to take the
load?

Nobody here can answer that for you. It completely depends on your
environment.

--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 21 - 24 in New York



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.