quote:

---

Originally posted by AskSQLTeam

Mark writes "The server on which we have SQL Server 7 has crashed but we managed to copy out all of the D: drive which contains the SQL Server installation, database files, etc.

Without having taken database backups before the crash, is there any way to rebuild the SQL Server installation on a different machine using only those directories and files which we copied? We're hoping to rebuild not only the databases but (more importantly) the DTS packages as well.

Any help would be appreciated!

Thanks & regards,
Mark"

---

use master
go
-- Allow updates to system tables
exec sp_configure @configname = 'allow updates' , @configvalue = '1'
go
reconfigure with override 
go
exec sp_configure
go

--exec sp_help sysservers

-- Display the current valuse from sysservers
select * from sysservers
select srvname  from sysservers where srvid = 0
select  datasource   from sysservers where srvid = 0
select  srvnetname   from sysservers where srvid = 0
select [@@servername] = @@servername

declare @newname sysname
-- Enter new server name
select	@newname = 'NEWSERVERNAME'

update sysservers
set
	srvname 	= @newname
	,datasource	= @newname
where
	srvid = 0

go
-- Turn off updates to system tables
exec sp_configure @configname = 'allow updates' , @configvalue = '0'
go
reconfigure with override 
go
exec sp_configure
go
-- Shutdown SQL Server and restart it after changing the server name to update 

quote:

---

Originally posted by Michael Valentine Jones


5. You might want to update the server name in master.dbo.sysservers to reflect the new server name, and to get the value of @@servername to match the new server name. I forget the exact procedure for that, but it's the row with srvid = 0. You have to restart SQL Server after you do this.

---