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