SQL Server 2008 Ran out of Disk Space

Question

SQL Server 2008 Ran out of Disk Space

Peter19898

SSC Rookie

Points: 45
More actions
July 17, 2015 at 5:36 pm

#300325

Hi
One of our SQL servers ran out of disk space and we received an error stating that the transaction log file was full for one of our Sharepoint content databases. I tried to detach the databases but the detach failed with an error stating again that the transaction log file was full and there was no disk space on the server (currently only 8.6MB!!!). I am in the process of copying the mdf and the ldf files to another SQL sever running the same version of SQL, will I be able to simply attach this database to the new server or will there be an issue with the database being in a mode that wont allow it to be attached like a dirty shut down mode similar to Exchange when the databases wont mount.
I would appreciate any assistance with this as I will have angry users shouting soon!
Thanks
Peter

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 1

Peter19898 (7/17/2015)
Hi
One of our SQL servers ran out of disk space and we received an error stating that the transaction log file was full for one of our Sharepoint content databases. I tried to detach the databases but the detach failed with an error stating again that the transaction log file was full and there was no disk space on the server (currently only 8.6MB!!!). I am in the process of copying the mdf and the ldf files to another SQL sever running the same version of SQL, will I be able to simply attach this database to the new server or will there be an issue with the database being in a mode that wont allow it to be attached like a dirty shut down mode similar to Exchange when the databases wont mount.
I would appreciate any assistance with this as I will have angry users shouting soon!
Thanks
Peter

Quick thought, do you have any disk space where you can temporarily add a log file for that db?

😎

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Providing you have both the mdf and the ldf, it should be fine. Attaching just the mdf will fail.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jeff Moden SSC Guru Points: 1004353 More actions · Answer 3

Peter19898 (7/17/2015)
Hi
One of our SQL servers ran out of disk space and we received an error stating that the transaction log file was full for one of our Sharepoint content databases. I tried to detach the databases but the detach failed with an error stating again that the transaction log file was full and there was no disk space on the server (currently only 8.6MB!!!). I am in the process of copying the mdf and the ldf files to another SQL sever running the same version of SQL, will I be able to simply attach this database to the new server or will there be an issue with the database being in a mode that wont allow it to be attached like a dirty shut down mode similar to Exchange when the databases wont mount.
I would appreciate any assistance with this as I will have angry users shouting soon!
Thanks
Peter

Are you doing regular log file backups?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

TEJABI Old Hand Points: 368 More actions · Answer 4

please go through this below link it will help much to you

http://stackoverflow.com/questions/56628/how-do-you-clear-the-sql-server-transaction-log