sql server msde: Hi peeps

Ok, we have an instance of MSDE running several databases, which is
installed on the C: drive (c:\MSSQLSERVER$INSTANCE).

Because of space problems on C:, we want to move the entire Instance
(including all dbs) to another drive.

How do I do this with the minimum of fuss?!

Cheers

di Dan,
[quoted text, click to view]

you actually can't... you can move databases only, but a full instance move
operation requires uninstalling it and reinstalling...
you have then to specify the DATADIR='d:\...\' and TARGETDIR='d:\...\'
parameters
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp
to identify the preferred locations... please keep in mind that a little
part of the installation, actually the shared components only, will always
default to \Program Files\ directory with no way to modify that behavior...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply