Move TempDB Database off of the SAN

I have a system configured with Windows 2000 and SQL Server 2000
Clustering (active/passive). Both SQL Servers have a local E:\ drive
with the same directory structure. I would like to move the tempdb
off of the shared SAN and on to the E:\ drive. I don't foresee any
issues with this but wanted to know if anyone else has encountered
problems with this.
Conceivable it should work but would not be a supported configuration.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||If you would like to put tempdb on a different disk (for performance reasons)
you'd be better to create a new disk on a different disk pool on your SAN.
That way, you'd keep your support options open.
|||> I have a system configured with Windows 2000 and SQL Server 2000
> Clustering (active/passive). Both SQL Servers have a local E:\ drive
> with the same directory structure. I would like to move the tempdb
> off of the shared SAN and on to the E:\ drive. I don't foresee any
> issues with this but wanted to know if anyone else has encountered
> problems with this.
I am vaguely trying to do the same. But how do you plan to make your local
disk visible as a resource of the cluster ? If you cannot make it a
resource of the cluster, you cannot make it recognized...
I am trying to add it as a disk share resource, but it is not accepted by
SQL Server in cluster, even with trace flag 1807.
Did someone manage do do it ?
thanks in advance,
rudi

Move TempDB Database off of the SAN

I have a system configured with Windows 2000 and SQL Server 2000
Clustering (active/passive). Both SQL Servers have a local E:\ drive
with the same directory structure. I would like to move the tempdb
off of the shared SAN and on to the E:\ drive. I don't foresee any
issues with this but wanted to know if anyone else has encountered
problems with this."Douglara" <renee.douglas@.ps.net> wrote in message
news:afc82404.0408231344.1f60247d@.posting.google.c om...
> I have a system configured with Windows 2000 and SQL Server 2000
> Clustering (active/passive). Both SQL Servers have a local E:\ drive
> with the same directory structure. I would like to move the tempdb
> off of the shared SAN and on to the E:\ drive. I don't foresee any
> issues with this but wanted to know if anyone else has encountered
> problems with this.

In theory it should work since the tempdb is recreated at startup.

But I'd ask why? I'm assuming you're looking for a performance improvement?

And suggest asking over in the microsoft.public.sqlserver.clustering group
to be sure.

move datafiles to SAN

Is there a way to move data files to SAN without causing downtime to sql server
Apparently not .. Sorry
"sivan" <sivan@.discussions.microsoft.com> wrote in message
news:958C0429-77A1-44F8-B38E-F7DED1BC6766@.microsoft.com...
> Is there a way to move data files to SAN without causing downtime to sql
server
|||Hi,
You have to detach the database and then copy the files to SAN drive and then
attach it back. As soon as you detach the database , the database will not
be available till you attach it back.
FYI, ALL the other databases in the same instance will be available during
this time.
Thanks
Hari
MCDBA
"Hassan" wrote:

> Apparently not .. Sorry
> "sivan" <sivan@.discussions.microsoft.com> wrote in message
> news:958C0429-77A1-44F8-B38E-F7DED1BC6766@.microsoft.com...
> server
>
>
|||"Hari Prasad" <HariPrasad@.discussions.microsoft.com> wrote in message
news:BF369363-8765-48E0-9C2C-27857A2312ED@.microsoft.com...
> Hi,
> You have to detach the database and then copy the files to SAN drive and
then
> attach it back. As soon as you detach the database , the database will not
> be available till you attach it back.
>
There's one way that may minimize downtime.
Backup your databases and restore them with a new name (this time located on
the SAN).
Then stop activity to the DB Server, perform a transaction log backup of the
databases, restore those to the new databases, drop the old databases,
rename the new ones and you SHOULD be good to go.
If you script it, your downtime can be measured in minutes.
But I would practice this a LOT.
[vbcol=seagreen]
> FYI, ALL the other databases in the same instance will be available during
> this time.
> Thanks
> Hari
> MCDBA
>
>
> "Hassan" wrote:
sql[vbcol=seagreen]

move datafiles to SAN

Is there a way to move data files to SAN without causing downtime to sql serverApparently not .. Sorry
"sivan" <sivan@.discussions.microsoft.com> wrote in message
news:958C0429-77A1-44F8-B38E-F7DED1BC6766@.microsoft.com...
> Is there a way to move data files to SAN without causing downtime to sql
server|||Hi,
You have to detach the database and then copy the files to SAN drive and then
attach it back. As soon as you detach the database , the database will not
be available till you attach it back.
FYI, ALL the other databases in the same instance will be available during
this time.
Thanks
Hari
MCDBA
"Hassan" wrote:
> Apparently not .. Sorry
> "sivan" <sivan@.discussions.microsoft.com> wrote in message
> news:958C0429-77A1-44F8-B38E-F7DED1BC6766@.microsoft.com...
> > Is there a way to move data files to SAN without causing downtime to sql
> server
>
>|||"Hari Prasad" <HariPrasad@.discussions.microsoft.com> wrote in message
news:BF369363-8765-48E0-9C2C-27857A2312ED@.microsoft.com...
> Hi,
> You have to detach the database and then copy the files to SAN drive and
then
> attach it back. As soon as you detach the database , the database will not
> be available till you attach it back.
>
There's one way that may minimize downtime.
Backup your databases and restore them with a new name (this time located on
the SAN).
Then stop activity to the DB Server, perform a transaction log backup of the
databases, restore those to the new databases, drop the old databases,
rename the new ones and you SHOULD be good to go.
If you script it, your downtime can be measured in minutes.
But I would practice this a LOT.
> FYI, ALL the other databases in the same instance will be available during
> this time.
> Thanks
> Hari
> MCDBA
>
>
> "Hassan" wrote:
> > Apparently not .. Sorry
> >
> > "sivan" <sivan@.discussions.microsoft.com> wrote in message
> > news:958C0429-77A1-44F8-B38E-F7DED1BC6766@.microsoft.com...
> > > Is there a way to move data files to SAN without causing downtime to
sql
> > server
> >
> >
> >