Posted by rcamarda on 05/18/06 14:47

IMO the quickest and easist way is to detach the database, move the
data via windows, and attach the database again.
This can be done via enterprise manager (in SQL Server 2000) or via QA.
See sp_detach_db command.
If you have a maintenace window where you can shutdown the application
(necessary since the database will be unavailable while detached) this
is the quickest and simplest. Once the database is attached, the
application wont know nor care that it was on the C: drive and now
somewhere else
HTH
Rob

• Next in forum: Re: alter table nocheck constraint still some dependencies
• Prev in forum: Re: Your Professional Advice Please - Design
• Thread view: Re: SQL Server 2000 running out of space.

[Reply to this message]