Hi All

You must excuse this post, I have lame XXX developers who have gone and
created a database with the logfile and database file on the same disk
array.

I need to move the log file from the raid 5 array to a raid 1 array.

I vaguely remember from my studies that there is a way of doing this but
can't remember how.

PS. It is a SQL 2000 Server, maybe this is different for SQL 7.

Please help.

Regards

Rob Cawood
IT Manager (explains it all, hehe)

Report this post to a moderator

Admitting you're an IT manager is the first step ... ;-)

Check out sp_detach_db and sp_attach_db in the BOL. In SQL Server 2000, you
can attach and detach via the EM GUI. Just detach the database, move the
offending file and then reattach. NBD.

--
Tom

----------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
SQL Server MVP
Columnist, SQL Server Professional

Toronto, ON Canada
www.pinnaclepublishing.com/sql
www.apress.com
---
Rob Cawood wrote in message ...
Hi All

You must excuse this post, I have lame XXX developers who have gone and
created a database with the logfile and database file on the same disk
array.

I need to move the log file from the raid 5 array to a raid 1 array.

I vaguely remember from my studies that there is a way of doing this but
can't remember how.

PS. It is a SQL 2000 Server, maybe this is different for SQL 7.

Please help.

Regards

Rob Cawood
IT Manager (explains it all, hehe)

Report this post to a moderator

Thanks Tom

You got to give me some credit... At least i know where the DB files should
be stored.

PS. It is different to SQL 7? That is what got me confused as i am not that
involved with dev work anymore, so SQL 2000 is still a bit fuzzy.

Thanks again.

Rob.


"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:Og0McioHCHA.2584@tkmsftngp08...
> Admitting you're an IT manager is the first step ... ;-)
>
> Check out sp_detach_db and sp_attach_db in the BOL. In SQL Server 2000,
you
> can attach and detach via the EM GUI. Just detach the database, move the
> offending file and then reattach. NBD.
>
> --
> Tom
>
> ----------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> SQL Server MVP
> Columnist, SQL Server Professional
>
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> www.apress.com
> ---
> Rob Cawood wrote in message ...
> Hi All
>
> You must excuse this post, I have lame XXX developers who have gone and
> created a database with the logfile and database file on the same disk
> array.
>
> I need to move the log file from the raid 5 array to a raid 1 array.
>
> I vaguely remember from my studies that there is a way of doing this but
> can't remember how.
>
> PS. It is a SQL 2000 Server, maybe this is different for SQL 7.
>
> Please help.
>
> Regards
>
> Rob Cawood
> IT Manager (explains it all, hehe)
>
>
>
>

Report this post to a moderator

The detach/attach method works with SQL 2000 as well.


Hope this helps.


Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index...epartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Rob Cawood" <rcawood@um.co.za> wrote in message
news:uJc$u6pHCHA.1596@tkmsftngp13...
> Thanks Tom
>
> You got to give me some credit... At least i know where the DB files
should
> be stored.
>
> PS. It is different to SQL 7? That is what got me confused as i am not
that
> involved with dev work anymore, so SQL 2000 is still a bit fuzzy.
>
> Thanks again.
>
> Rob.
>
>
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:Og0McioHCHA.2584@tkmsftngp08...
> > Admitting you're an IT manager is the first step ... ;-)
> >
> > Check out sp_detach_db and sp_attach_db in the BOL. In SQL Server
2000,
> you
> > can attach and detach via the EM GUI. Just detach the database,
move the
> > offending file and then reattach. NBD.
> >
> > --
> > Tom
> >
> > ----------------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> > SQL Server MVP
> > Columnist, SQL Server Professional
> >
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> > www.apress.com
> > ---
> > Rob Cawood wrote in message ...
> > Hi All
> >
> > You must excuse this post, I have lame XXX developers who have gone
and
> > created a database with the logfile and database file on the same
disk
> > array.
> >
> > I need to move the log file from the raid 5 array to a raid 1 array.
> >
> > I vaguely remember from my studies that there is a way of doing this
but
> > can't remember how.
> >
> > PS. It is a SQL 2000 Server, maybe this is different for SQL 7.
> >
> > Please help.
> >
> > Regards
> >
> > Rob Cawood
> > IT Manager (explains it all, hehe)
> >
> >
> >
> >
>
>

Report this post to a moderator