"Ray Watson" <RW@IINET.NET.AU> wrote in message
news:3f4eac7e$0$23593$5a62ac22@freenews.iinet.net. au...
> Hi all
>
> In a new installation, if the data directory is stipulated as d:\data, it
> installs all
> data in d:\data\MSSQL\data.
>
> I need to place the data in d:\mssql7\data to incorporate backsup from old
> data backusp

Might be able to do a sp_detach_db and then sp_attach_db after moving the
files.

I've had to do something similar for similar reasons.


>
> Any ideas ?
>
> Cheers
>
> Ray
>
>