[dba-SQLServer] Out of Disk

Probably, but I fully intend to have a separate hard disk for this database
so I would just as soon move it right now.

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 Martin Reid
Sent: Thursday, August 19, 2004 4:04 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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
>
>

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