RPS
Reputation: 837
MS SQL Server 2005: What Happens If LDF-file are lost?
If I put my MS SQL Log file on another drive and the drive crashes.
What happens to my MS SQL Database, will it create a new log file or how do I correct it?
Upvotes: 4
Views: 1380
Answers (1)
SQLMenace
Reputation: 134923
you need to recover/repair the database, see here: Recover a database without the ldf file
Upvotes: 4
Related Questions
- How to delete .ldf file from SQL Server 2008?
- MDF, LDF files on a virtual drive
- What is the LDF file in SQL Server?
- Recovering Database after deleting .ldf file
- MSSQL ReCreate LDF file for database
- Why do we need the LDF files along with MDF files?
- What happens when a transaction is being carried out during backing up of LDF files?
- SQL Server - can I load MDF without LDF file without losing data?
- sql server 2005 .mdf .ldf files
- Detaching a SQL Server 2005 database that has had it's MDF/LDF file moved or lost