Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ErictheRed
Starting Member
1 Post |
 Posted - 2004-02-02 : 14:26:35
|
| The Basic Goal:I am building a DR Server to test my DR plan. On my production server I had upgraded my DB from SQL7 to SQL 2K. It retained my directory structure from the original install. E:\MSSQL7\*. Therefore the data directory is e:\MSSQL7\Data\. I would like to rebuild this data structure on the DR sever to ease the database recovery/restore. The issue:Whenever I install MSSQL 2K to the folder E:\MSSQL7\ the installer appends \MSSQL\ to the path so that the full installation is now in E:\MSSQL7\MSSQL\.I am installing from the BackOffice CD.The question:Will I have to install sql7 then upgrade to sql2k to resolve this install? Will sql7 install on a Win2003 server?The Complete Goal:After I resolve this pathing issue, I plan to have this server map to a location on the network and do automatic restores of the production server DB thorough the day. The production server currently backs up its daily full backup to the network location and every two hours it builds and appends to the log backup at this location.I will then further backup the full daily DB to a DVD blank daily (Sunday thru Thursday) to restore to an off-site server. Neither the in-house (2hour old) or offsite (1day old) server will be a hardware duplicate of the production server. They are just a safety cushion for our accounting department. The replacement (redundant) server(s) will not be workhorses either.Any suggestions, comments, question, welcome. Point me to the section of the manual that I must have overlooked or suggest any other reading material. Thanks All -Eric |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-03 : 12:32:56
|
| There is no way to fix the path issue that you are having through the installation. For SQL 2000, it appends MSSQL. If you type in E: only in the installation wizard, it will give you E:\MSSQL. That's how we do it. I wouldn't think that you'd want MSSQL7 for a SQL 2000 installation.You can fix the problem after the installation if you must have MSSQL7 by detaching the databases, moving the files to the correct place, then reattaching them using the new path.Tara |
 |
|
|
|
|
|
Install SQL on DR Server issue.