sql server (alternate): Hi,

What is the Log.LDF file used for? Can it be deleted?

Thanks,


Stef

On Thu, 14 Aug 2003 11:42:01 -0400 in comp.databases.ms-sqlserver,
[quoted text, click to view]

It's the log file where all the transactions are logged, the server
will use this to automatically recover your database after a crash.
Not a good idea to delete it.

--
Ride Free (but you still have to pay for the petrol)

Stefan (nickm@studioweb.com) writes:
[quoted text, click to view]

No, you will not be able to access your database if you do. As Trevor
said, the transaction log is there to make it possible to recover the
database in case of a crash. SQL Server also uses this file if a
transaction runs into a problem and must be rolled back.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at