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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-12 : 09:23:35
|
| Mauricio Solorzano writes "This question pertains to:Microsoft SQL Server 2000 - 8.00.94 (Intel X86)Aug 6 2000, 00:57:48Standard Edition on Windows NT 5.0 (Build 2195:Service Pack 1), which is Win2K Advanced Server.We created a test database and the transaction log was physically erased from the hard disk, but the primary *.MDF is intact. From just this data file, how can the suspect data base be repaired (i.e. to create the trans log. and re-attach)? My database logical name is Sprint_data.MDF, and thelog file WAS Sprint_log.LDF, which was located in anotherdrive (RAID 5) before it was accidentally deleted. Thereare no backups (oops).Best Regards, Mauricio J. Solórzano Software EngineerBusiness Applications" |
|
|
|
|
|
How to repair a DB without the transaction log file *.ldf