Friday, March 30, 2012

Moving transactionlog distmdl.ldf

I have followed procedures of MS KB Article 224071 to move all the
transaction logs from my SQL Server 2000 server to another disk, but I
can't find instructions for this ditsmdl.ldf log.
How should I move this one ?
TIA!distmdl.ldf is the log file for the distribution database template. I think
you should just leave it where it is.
If you are also changing the default data directory and default log
directory then place the distmdl.mdf and distmdf.ldf files in those folders
respectively.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:k3knf016ork00isnvr1r8pip1mmmcm8can@.
4ax.com...
I have followed procedures of MS KB Article 224071 to move all the
transaction logs from my SQL Server 2000 server to another disk, but I
can't find instructions for this ditsmdl.ldf log.
How should I move this one ?
TIA!|||On Mon, 19 Jul 2004 16:39:25 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>distmdl.ldf is the log file for the distribution database template. I think
>you should just leave it where it is.
>If you are also changing the default data directory and default log
>directory then place the distmdl.mdf and distmdf.ldf files in those folders
>respectively.
Yes, I am moving ALL the transactionlog files to another disk.
Seems that there's a different procedure for pretty much each system
log file. So, what I need to know is HOW to move it correctly.
I followed the procedures in KB article 224071, but it doesn't mention
instructions for this distmdl.ldf.|||I meant, are you specifying a different default path for databases and log
files, in the 'Server properties' dialog box in Enterprise Manager? If you
are not, then there's no need to move distmdl.ldf.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:liepf0ho37a0s1q5baqo9m4mpa1923cmqe@.
4ax.com...
On Mon, 19 Jul 2004 16:39:25 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>distmdl.ldf is the log file for the distribution database template. I think
>you should just leave it where it is.
>If you are also changing the default data directory and default log
>directory then place the distmdl.mdf and distmdf.ldf files in those folders
>respectively.
Yes, I am moving ALL the transactionlog files to another disk.
Seems that there's a different procedure for pretty much each system
log file. So, what I need to know is HOW to move it correctly.
I followed the procedures in KB article 224071, but it doesn't mention
instructions for this distmdl.ldf.

No comments:

Post a Comment