|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > Move Log File/Database File to seperate disk.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Move Log File/Database File to seperate disk.
|
|
| Rob Cawood 2002-06-28, 3:25 am |
| 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)
| |
| Tom Moreau 2002-06-28, 4:25 am |
| 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)
| |
| Rob Cawood 2002-06-28, 7:25 am |
| 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)
>
>
>
>
| |
| Dan Guzman 2002-06-28, 7:25 am |
| 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)
> >
> >
> >
> >
>
>
|
|
|
|
|