About the author

Imran Imran
Like Development in DotNet.

E-mail me Send mail

Recent Articles

 
1: Roles And Membership
Category: ASP.Net
Added: 6/2/2008

 
2: ListView and DataPager in ASP.NET 3.5
Category: ASP.Net
Added: 5/15/2008

 
3: Asp.Net Cookies
Category: ASP.Net
Added: 5/8/2008

 
4: DatagridDatalistRepeater
Category: ASP.Net
Added: 5/8/2008

 
5: mySql With Asp.Net
Category: Databases
Added: 4/16/2008

 
6: MDF without LDF
Category: Databases
Added: 4/16/2008

 
7: Disable Right Click
Category: Java Script
Added: 4/16/2008

 
8: String Functions
Category: ASP.Net
Added: 3/20/2008

 
9: Water Mark
Category: HTML & DHTML
Added: 3/20/2008

 
10: Ajax With Javascript
Category: AJAX
Added: 3/10/2008

MDF without LDF

by Imran 16/April/2008

Attach MDF file without LDF file


From few days ago i have a problem which is i lost my log file of sql server 2000. Then I tried to recover it then failed. Sql server 2000 cannot attach db without LDF log file. Then I search this problem on Google and found a solution

Attach your MDF file with Sql server 2005 and when you attaching then remove LDF file from list of Sql server 2005. Then you will see Sql server 2005 generate LDF file automatically. Then if you want to that database convert again to Sql server 2000 then use import/Export utility of Sql Server 2000 because you can use Sql Server Import/Export with Both 2000/2005.



Powered by DotNetClassic.com