[dba-SQLServer] Out of Disk

John W. Colby jwcolby at colbyconsulting.com
Thu Aug 19 14:57:27 CDT 2004


I imported more of the data into this big db I'm working on and now SQL
Server shuts down after 5 seconds or so after startup.  The error log says
"not enough room on disk" for something it is trying to build (a temp db I
think).  I am down to 15gb on the disk that the SQL Server data resides on.


The question is, can I simply copy the mdf and ldf files for this new
database off to the new hard disk I installed to free up memory?  I
understand that SQL Server would now be missing the database, but can I then
detach it and reattach it from the new drive?  If not I will need to clean
up enough space (amount unknown) to get SQL Server to stay up so that I can
correctly detach the db and then move it.

John W. Colby
www.ColbyConsulting.com 






More information about the dba-SQLServer mailing list