[dba-SQLServer] Out of Disk

John

Can you just move the tempdb out to the bigger disk??

Martin


----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Thursday, August 19, 2004 8:57 PM
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
>
>