[dba-SQLServer] Out of Disk

Arthur Fuller artful at rogers.com
Fri Aug 20 19:22:21 CDT 2004


Copy the files to the new hard disk into a dir of your choice. Then
delete the database within EM. Then open QA and run sp_attach_single_db
"JWCdata", pointing to the new location. Check BOL for precise syntax,
but that's the idea and it's trivial. You'll have it done in a few
minutes.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W.
Colby
Sent: Thursday, August 19, 2004 3:57 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Out of Disk


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 



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list