SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:39 PM
| ||||
| ||||
 SQL 2000 install anomaly 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      |
|
02-28-2008, 05:39 PM
| |||
| |||
| Re: SQL 2000 install anomaly "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 > > |
|
02-28-2008, 05:39 PM
| |||
| |||
| Re: SQL 2000 install anomaly 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! |
|
02-28-2008, 05:40 PM
| |||
| |||
| Re: SQL 2000 install anomaly "Ray Watson" <rw@iinet.net.au> wrote in message news:3f4edc0f$0$62076$75868355@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! |
|
02-28-2008, 05:40 PM
| ||||
| ||||
| Re: SQL 2000 install anomaly 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! |
Linear Mode
