_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
>> >
>>

[EXTREMELY URGENT] sp_attach_db error

I am attaching a database with 3 data files.
When I execute "exe sp_attache_db..." I obtain this error:
database 'POINT' cannot be opened because some of the files could not be
activated.
I have deleted its LDF file.
Usually I detach my db, then I delete transaction log, and reattach 3 data
files...
Now it doesn'work!!!!!!!!!!
Someone can help me?
Thanks."George" <giorgio.benedettiNOSPAM@.libero.it> wrote in message
news:bovm8o$8o0$1@.newsreader.mailgate.org...
> I am attaching a database with 3 data files.
> When I execute "exe sp_attache_db..." I obtain this error:
> database 'POINT' cannot be opened because some of the files could not be
> activated.
> I have deleted its LDF file.
> Usually I detach my db, then I delete transaction log, and reattach 3 data
> files...
> Now it doesn'work!!!!!!!!!!

First, it should be noted in case you're not aware that deleting the LDF
file is a VERY bad idea. It should only be done in the most rare of cases.

I"m actually surprised that sp_attach_db has worked at all w/o the log file.

However, you can try sp_attach_singlefile_db, but I doubt it will work.

You'll probably have to call Microsoft on this.

> Someone can help me?
> Thanks.

[Ask]Getting files from pocket pc emulator to desktop pc

hi...!
I'm creating a small device application using visual studio.NET 2003. Is it possible to get a sql server ce database file (.sdf) that i created at the pocket pc emulator to my desktop pc ?
If that's possible, then can you tell me how to do that ?

thanx b4

Moving this thread to SQL Mobile forum where it has got better chances of being answered.

-Thanks,

Mohit

|||

Yes, you sure can copy this file (e.g. by using file explorer on emulator and network drive on PC). But you can't use it on desktop.

|||Can you tell me what should i do to copy the file, more specifically (step by step) ?
I don't have a plan to use it on desktop, I just want to copy the .sdf file from emulator to desktop, then to the real pocket pc

thanx
|||

Please see this (don't mind it mentions wireless network, work the same way on emulator):

http://pocketpccentral.net/help/browsewlan.htm