Isn't that what I originally recommended when this thread started? :)
> Jeff Binkley
> ASA Network Computing
>
> -> Josh Hillman wrote:
> -> >
> -> > From: Dale E. Reed Jr. <daler@iea-software.com>
> -> > >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.
> -> >
> -> > I don't know why I didn't think of this before, but won't the following
> -> also > work?:
> ->
> -> I don't like trying to "trick" SQL Server. The below might work, but I
> -> can't recommend it.
> ->
> -> > Stop SQL Server.
> -> > Copy the appropriate .dat files from C: to a temporary location. > Start
> -> SQL Server.
> -> > Delete the database and device.
> -> > Create a new device and datbase with the same info, except
> -> > for the physical location (changing it to S:)
> -> > Stop SQL Server.
> -> > Replace the newly created .dat files in S: with the original
> -> > .dat files.
> -> > Start SQL Server.
> -> >
> -> > 2 years ago, our Emerald datbase got corrupted and I had to restore the >
> -> actual .dat files off of tape (the diskdump restores didn't work; forget >
> -> why). Obviously, the only way to get those .dat files on tape to begin with
> -> > was by shutting off SQL for a few minutes, while making copies of the .dat
> -> > files so that they'd be picked up in the tape-backup since the real ones
> -> are > always in use. Replacing the .dat files worked (although obviously,
> -> some > data had to be re-entered because of the timing). The difference
> -> here was > that the Emerald.dat file was restored to the same location that
> -> it was to > begin with.
> -> >
> -> > Josh Hillman
> -> > hillman@talstar.com
> -> >
> -> > For more information about this list, including removal,
> -> > see this url: http://www.iea-software.com/maillist.html
>
> For more information about this list, including removal,
> see this url: http://www.iea-software.com/maillist.html
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.comFor more information about this list, including removal,see this url: http://www.iea-software.com/maillist.html