SQL 2000 install anomaly

[Ray Watson]

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

[Greg D. Moore \(Strider\)]

"Ray Watson" <[e-mail]> wrote in message
news:3f***********************@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

[Ray Watson]

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 ***
Don't just participate in USENET...get rewarded for it!

[Greg D. Moore \(Strider\)]

"Ray Watson" <[e-mail]> wrote in message
news:3f***********************@news.frii.net...

Thats a good suggestion, but I get the message
"cant detach databases, msdb, master and msdb"
MS has a KB article on how to move the system Databases.

They are a "special" case.


Any other ideas

Thanks


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ray Watson]

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...b;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 ***
Don't just participate in USENET...get rewarded for it!