Moving Transaction Log File

We are currently in the process of moving our ERP SQL database to a
new server. I do not have a problem detaching, moving and
(re)attaching the database. My dilemma is this; both the mdf and ldf
files are currently on the same drive, when I move the database over
to the new server, I want the mdf to go on one drive and the ldf to go
on another. Can this be done?
Note: We use the simple recovery method.Greg,
Yes.First detach the database, move the ldf file to new location and while
attaching it back , mention the new path for ldf.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Greg R" <gregr@.rochestercolonial.com> wrote in message
news:9d1c9cfe.0308251242.32b56bcd@.posting.google.com...
> We are currently in the process of moving our ERP SQL database to a
> new server. I do not have a problem detaching, moving and
> (re)attaching the database. My dilemma is this; both the mdf and ldf
> files are currently on the same drive, when I move the database over
> to the new server, I want the mdf to go on one drive and the ldf to go
> on another. Can this be done?
> Note: We use the simple recovery method.|||before you attach the DB you can move .ldf and .mdf files to the desired
drive. When you attach just tell SQL where the files are.
"Greg R" <gregr@.rochestercolonial.com> wrote in message
news:9d1c9cfe.0308251242.32b56bcd@.posting.google.com...
> We are currently in the process of moving our ERP SQL database to a
> new server. I do not have a problem detaching, moving and
> (re)attaching the database. My dilemma is this; both the mdf and ldf
> files are currently on the same drive, when I move the database over
> to the new server, I want the mdf to go on one drive and the ldf to go
> on another. Can this be done?
> Note: We use the simple recovery method.|||INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Greg R" <gregr@.rochestercolonial.com> wrote in message
news:9d1c9cfe.0308251242.32b56bcd@.posting.google.com...
We are currently in the process of moving our ERP SQL database to a
new server. I do not have a problem detaching, moving and
(re)attaching the database. My dilemma is this; both the mdf and ldf
files are currently on the same drive, when I move the database over
to the new server, I want the mdf to go on one drive and the ldf to go
on another. Can this be done?
Note: We use the simple recovery method.|||Yes it can be done, I have done it.
Good luck
>--Original Message--
>We are currently in the process of moving our ERP SQL
database to a
>new server. I do not have a problem detaching, moving and
>(re)attaching the database. My dilemma is this; both the
mdf and ldf
>files are currently on the same drive, when I move the
database over
>to the new server, I want the mdf to go on one drive and
the ldf to go
>on another. Can this be done?
>Note: We use the simple recovery method.
>.
>