IT Employment

General discussion


Windows NT 4 and SQL v7.0

By jaime.tolentino ·
Due to slow MS SQL v7.0 databases access performance, we are forced to upgrade RAM and purchase additional CPU to my dual-processor capable SQL Server. The problem is Windows NT4 and SQL v7.0 doesnt automatically recognize the additional CPU and were advise to reinstall NT4 and SQL. If this is the real case, I am hesitant to proceed as my SQL application might not be properly restored from backup and run as before. Any thoughts on the issue and guidelines for the proper way to do this?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Possible answer

by mpir In reply to Windows NT 4 and SQL v7.0

I would use sp_detach_db to free the database (and maybe make a backup copy), re-install SQL Server, then use sp-attach_db. This gives you a backup, protects the data and accomplishes the upgrade with integral proceedures.

Related Discussions

Related Forums