Different drives (mdf, ldf) - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Different drives (mdf, ldf)

Author

Topic

dbMartiN
Starting Member

26 Posts

Posted - 2004-09-28 : 03:15:42

Hello,

I have a SQL Server database with the .mdf and .ldf files on drive F:, if the disc crashes we loose all these files. Can I put the .ldf files on a different drive to ensure that we still got them if the F: drive crashes??

In a database backup, is both the .ldf and .mdf files included??

Thanks for all help...

KR
Martin

Thanks for your help!

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-09-28 : 03:28:37

actually it is best practice to separate the mdf and ldf files on different physical drives. i usually detach the database, then move the ldf to a different drive, then attach it again, specifying on where the log file is now located.

if your database backup is complete, then yes both files are included

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-09-28 : 04:52:06

And if you're going to be doing this (which I would recommend also), you should use this article as reference:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071

It's a good article to have in your toolbox anyway.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

dbMartiN
Starting Member

26 Posts

Posted - 2004-09-28 : 05:20:12

Thanks for your answers!

I looked att the link below, is there not a way to do this in EM?

Is it best to move both the system databases files and the user files?

KR
Martin

Thanks for your help!

SamC
White Water Yakist

3467 Posts

Posted - 2005-04-15 : 14:37:54

Is there a way to RESTORE a database such that the LDF is on another drive, or more precisely, so the MDF is on a separate drive than: master, tempdb and the LDFs?

X002548
Not Just a Number

15586 Posts

Posted - 2005-04-15 : 15:10:44

quote:
Originally posted by jen

actually it is best practice to separate the mdf and ldf files on different physical drives. i usually detach the database, then move the ldf to a different drive, then attach it again, specifying on where the log file is now located.

if your database backup is complete, then yes both files are included

Well...ok.....If your working at less the 10GB I don't think it matters...

AND, make sure the drives are physically attached to the server...not across a network....

Brett

8-)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-04-15 : 15:34:44

quote:
Originally posted by SamC

Is there a way to RESTORE a database such that the LDF is on another drive, or more precisely, so the MDF is on a separate drive than: master, tempdb and the LDFs?

Yes you can use the RESTORE DATABASE command with the WITH MOVE option.

Tara

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-04-18 : 01:16:36

yes there is (just right click on the database, and you'll see the options), just don't forget to create a backup (just so you have something to work on if anything goes wrong)

quote:
Originally posted by dbMartiN

Thanks for your answers!

I looked att the link below, is there not a way to do this in EM?

Is it best to move both the system databases files and the user files?

KR
Martin

Thanks for your help!

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources