I am installing a new server with windows 2000 and SQL 7 i
will be restoring the databases from the old serveer to
the new but need to keep the network name it seems if the
name is renamed it creates problems has anyone carried out
this opreation successfully

If you are using backup software, no problems. If you copying across the
network and re-attaching, then both machines can not be up on the network at
the same time.

Cheers,

Rod

"Steve Wood" <anonymous (AT) discussions (DOT) microsoft.com> wrote

As Rod states you should be fine but there are some links that may be of
interest:


http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.databasejournal.com/featu...le.php/2228611
Transferring Logins
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server

http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues

--

Andrew J. Kelly
SQL Server MVP


"Steve Wood" <anonymous (AT) discussions (DOT) microsoft.com> wrote