_log.ldf - files

Hello,
Sometimes files that end with _log.ldf are left in the same directory as the
.ldf and .mdf-files of a SQL Server database file.
When this happens, the SQL Server files cannot be deleted, unless the
computer is booted up again.
What is the meaning of those files and how can they be removed without
having to reboot the computer?
Many thanks and greetings from Brugge (Bruges - Belgium),
MichelThey can't be deleted because something has them open.
I would, very carefuly, examine the Transaction log information for ALL of
your databases (database propertities) for the name(s) you are seeing.
Jay
"Michel" <Michel@.discussions.microsoft.com> wrote in message
news:7E996834-60E7-4954-9A5C-F7EBECB61224@.microsoft.com...
> Hello,
> Sometimes files that end with _log.ldf are left in the same directory as
> the
> .ldf and .mdf-files of a SQL Server database file.
> When this happens, the SQL Server files cannot be deleted, unless the
> computer is booted up again.
> What is the meaning of those files and how can they be removed without
> having to reboot the computer?
> Many thanks and greetings from Brugge (Bruges - Belgium),
> Michel
>|||Hello,
Thank you very much for your response.
Where do I find these Transaction log information?
Many thanks and greetings from Brugge (Bruges - Belgium),
Michel
"Jay" wrote:
> They can't be deleted because something has them open.
> I would, very carefuly, examine the Transaction log information for ALL of
> your databases (database propertities) for the name(s) you are seeing.
> Jay
> "Michel" <Michel@.discussions.microsoft.com> wrote in message
> news:7E996834-60E7-4954-9A5C-F7EBECB61224@.microsoft.com...
> > Hello,
> >
> > Sometimes files that end with _log.ldf are left in the same directory as
> > the
> > .ldf and .mdf-files of a SQL Server database file.
> > When this happens, the SQL Server files cannot be deleted, unless the
> > computer is booted up again.
> > What is the meaning of those files and how can they be removed without
> > having to reboot the computer?
> >
> > Many thanks and greetings from Brugge (Bruges - Belgium),
> >
> > Michel
> >
>
>|||Hello Michel,
Every database has at least an *.mdf and *.ldf files. If you delete a
database's ldf file, then you can not open that database again.
For more information about Transaction Log files, please check out the
following pages:
Understanding and Managing Transaction Logs:
http://msdn2.microsoft.com/en-us/library/ms345583.aspx
Ekrem Ã?nsoy
"Michel" <Michel@.discussions.microsoft.com> wrote in message
news:7E996834-60E7-4954-9A5C-F7EBECB61224@.microsoft.com...
> Hello,
> Sometimes files that end with _log.ldf are left in the same directory as
> the
> .ldf and .mdf-files of a SQL Server database file.
> When this happens, the SQL Server files cannot be deleted, unless the
> computer is booted up again.
> What is the meaning of those files and how can they be removed without
> having to reboot the computer?
> Many thanks and greetings from Brugge (Bruges - Belgium),
> Michel
>|||In the database propertities, Transaction log tab.
Are you on 2000, or 2005?
"Michel" <Michel@.discussions.microsoft.com> wrote in message
news:BAA804BF-DBCB-4BB6-B4E6-BF1A055710E0@.microsoft.com...
> Hello,
> Thank you very much for your response.
> Where do I find these Transaction log information?
> Many thanks and greetings from Brugge (Bruges - Belgium),
> Michel
>
> "Jay" wrote:
>> They can't be deleted because something has them open.
>> I would, very carefuly, examine the Transaction log information for ALL
>> of
>> your databases (database propertities) for the name(s) you are seeing.
>> Jay
>> "Michel" <Michel@.discussions.microsoft.com> wrote in message
>> news:7E996834-60E7-4954-9A5C-F7EBECB61224@.microsoft.com...
>> > Hello,
>> >
>> > Sometimes files that end with _log.ldf are left in the same directory
>> > as
>> > the
>> > .ldf and .mdf-files of a SQL Server database file.
>> > When this happens, the SQL Server files cannot be deleted, unless the
>> > computer is booted up again.
>> > What is the meaning of those files and how can they be removed without
>> > having to reboot the computer?
>> >
>> > Many thanks and greetings from Brugge (Bruges - Belgium),
>> >
>> > Michel
>> >
>>