can I create db on nfs-mounted drive?

I have a large NAS server that I want to use as a SANS server. I would like
to NFS mount the NAS to my sql server, create a database on it, then unattac
h it and reattach it to another sql server. Has anyone tried this before? do
es anyone have any other id
eas on how I can do something simular? I am trying to reduce my copy times b
etween my production servers and my delivery servers.
thank you in advance!!Below might be of some help...
http://support.microsoft.com/defaul...kb;en-us;304261
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"chenthorn" <anonymous@.discussions.microsoft.com> wrote in message
news:F118D86C-1D51-4052-86F3-B4541D730207@.microsoft.com...
> I have a large NAS server that I want to use as a SANS server. I would
like to NFS mount the NAS to my sql server, create a database on it, then
unattach it and reattach it to another sql server. Has anyone tried this
before? does anyone have any other ideas on how I can do something simular?
I am trying to reduce my copy times between my production servers and my
delivery servers.
> thank you in advance!!

Can 2005 and 2000 have use same shared network drive as resource

Can 2005 and 2000 have use same shared network drive as resource?
Example: If 2000 uses I,J,K Network drives can 2005 use I:\2005,j:\2005 and
k:\2005 .
We have A/A cluster, Can i upgrade one instance to 2005 and keep another as
2000 for some time.
Thanks
IT
"IT" <IT@.discussions.microsoft.com> wrote in message
news:2B430FAC-5A0E-4F65-B28F-6C51D1AD31EA@.microsoft.com...
> Can 2005 and 2000 have use same shared network drive as resource?
Not if they are configured correctly. Since each instance will have its own
cluster group and thus its own virtual server, then the resources from one
cluster group can not be used by another cluster group at the same time.
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:
Denver starting Feb 12th
NYC starting Feb 19th

> Example: If 2000 uses I,J,K Network drives can 2005 use I:\2005,j:\2005
> and
> k:\2005 .
> We have A/A cluster, Can i upgrade one instance to 2005 and keep another
> as
> 2000 for some time.
> Thanks
> IT
>
|||Thank you for the reply. I have one more question on A/A cluster(right now
its sql 2000 A/A cluster), Can i upgrade one instance to 2005 and keep
another as 2000 for some time.
Thanks in advance.
"Russ Kaufmann" wrote:

> "IT" <IT@.discussions.microsoft.com> wrote in message
> news:2B430FAC-5A0E-4F65-B28F-6C51D1AD31EA@.microsoft.com...
> Not if they are configured correctly. Since each instance will have its own
> cluster group and thus its own virtual server, then the resources from one
> cluster group can not be used by another cluster group at the same time.
>
> --
> 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:
> Denver starting Feb 12th
> NYC starting Feb 19th
>
>
|||"IT" <IT@.discussions.microsoft.com> wrote in message
news:60AC40F5-FB03-4265-9BDF-2174C196DF81@.microsoft.com...
> Thank you for the reply. I have one more question on A/A cluster(right now
> its sql 2000 A/A cluster), Can i upgrade one instance to 2005 and keep
> another as 2000 for some time.
Sure. You can have different versions of SQL running in different instances.
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:
Denver starting Feb 12th
NYC starting Feb 19th