Can I point to an existing Mssql7 directory from a new SQL 7 install

[Cranger]

We reinstalled NT on our server and I re-installed sql server 7.0. My question is, can I just point to the old Mssql7 Data directory from the new install. I tried it and I keep getting errors. What I did was renamed mssql7 to mssql7a. Then I installed SQL 7 on the C:drive and defined the data to be F:\mssql. After I installed I renamed the two directories so mssql7a is now mssql7. I thought this would work but my services wont start after I do this.

Do I have to restore my data directory from backups? or do I even need to restore SQL 7 from back up as well. Any help is appreciated. Thanks

 

[foxdev]

Try using the sp_attach_db to get the new install to recognize the databases already existing on the drive. -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com