Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
y.koteswarrao
Starting Member
3 Posts |
 Posted - 2009-02-21 : 03:37:59
|
| Hi DBA'sThis is an interview question how to recover the missing log file(.LDF)?Koteswar Rao. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-21 : 08:57:49
|
| If SQL Server was closed properly you can use:sp_attach_single_file_db |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2009-02-23 : 20:31:12
|
| I don't think you should apply for the job if you don't know the answer already.Paul S. Randal, Managing Director, SQLskills.com (www.SQLskills.com/blogs/paul)SQL Server MVP, Contributing Editor of TechNet MagazineAuthor of SQL 2005 DBCC CHECKDB/repair codeAuthor & Instructor of Microsoft Certified Master - Database course |
|
|
|
|
|
|
Missing Log File