[quoted text, click to view]

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.


[quoted text, click to view]

Thats a good suggestion, but I get the message
"cant detach databases, msdb, master and msdb"

Any other ideas

Thanks




*** Sent via Developersdex http://www.developersdex.com ***

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

Any ideas ?

Cheers

Ray

[quoted text, click to view]

MS has a KB article on how to move the system Databases.

They are a "special" case.


[quoted text, click to view]

Hi all

Yes, thanks to the suggestion, I have located some usefull answers.

In fact the initial starting up problem was the root cause, but I had a
bigger project, where I had to move databases between servers as well.

I had tried searching Microsoft for startup sql parameters only.

For those interested, the location is
http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

The transfer from 7 to 2000 is a special case

Thanks for all the guidance
Cheers

Ray


*** Sent via Developersdex http://www.developersdex.com ***