Re: [NTISP] Moving SQL .dat files

Dale E. Reed Jr. ( (no email) )
Tue, 02 Feb 1999 22:27:17 -0800

Josh Hillman wrote:
>
> Is it possible to relocate/move the .dat files associated with a SQL
> device/database? I just realized that one of our databases is sitting in
> the root of C on the machine and it belongs in S. How can I move the .dat
> files and have MSSQL Server (6.5 SP4) be aware of it?

I'm not sure. You could do a dump of the DB, drop the DB and devices,
delete the old files, re-create the new devices and db, then restore
the DB. Not pretty, but would work. 

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

For more information about this list, including removal,see this url: http://www.iea-software.com/maillist.html