MS SQL server 2005 attach databse without ldf file

MS SQL server 2005 attach databse without ldf file


 One of our system database became inaccessible due to lack of space on hard drive.
So we detached that database and after making some space I tried to re-attach and .... begins.

Come up with errors like:

The log cannot be rebuilt because the database was not cleanly shut down.

Now, I wanted to attach the database without .ldf file.  

Follow steps explained by Paul S. Randal on SQL server.

http://www.sqlskills.com/blogs/paul/post/checkdb-from-every-angle-emergency-mode-repair-the-very-very-last-resort.aspx#

Remember: You know there's a command that should be able to help you.

You are not the first person to get that error. There exist solutions and peoples who share it.

It wan't not take more than 15 min to get your data base online.

 Satalaj.

Sql Server MirroringMS SQL server shutdownAsp.net delete file file on Server C#.net and VB.net codeAsp.net File Uploadgodaddy hosting MS SQL server configurationASP.net File HandlingThe shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005Could not load file or assembly SystemServiceModelDomainServicesHosting Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 or one of its dependencies The system cannot find the file specifiedC# Delete All Files In DirectoryMS SQL server service packMS SQL server mirroring remove end points master key

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.