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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-06 : 10:03:26
|
| Marty Micheals writes "We recently had a server that houses both an application and its SQL Server Database that we attempted to restore to another server. One of our NT folks took a full server backup tape and restored it onto an identical server (we are using Windows2000 SP2 and SQL Server 7.0 SP(3).When the server was done being restored, we could not get the SQL services to start. We then uninstalled SQL, and attempted to reinstall it to no avail. The error messages we received said that the server could not be connected to and listed an ODBC named pipes error. We later deleted the MSSQL registry settings and still could not get the application to install.We ended up just bringing the database up on a different server. Any ideas of what might have went wrong?Thanks!" |
|
|
manishrawat
Starting Member
9 Posts |
Posted - 2001-12-07 : 12:21:31
|
| The SQL Server Installation is Windows machine name specific.Changing even machine name causes sql server to fail. So copying a back to a different machine name won't start SQL Service.I forgot what needs to done if this happensTrying looking sp_dropserver and sp_Addserver |
 |
|
|
|
|
|
Restoring An Entire Server via a Full NT Backup