John W. Colby
jwcolby at colbyconsulting.com
Thu Aug 19 15:08:08 CDT 2004
Is the ldf the log file? If so I understand it is possible to place that file on a different drive from the data file? How do I limit the size of the log file and dictate the location? John W. Colby www.ColbyConsulting.com -----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