restoring msdb of different server

Hi
Evironment: SQL Server 2000 SP3a
I want to restore master & msdb (which transfers login,
settings, jobs etc.) of old server to the new server. What
are the possible issues with this approach, if any? Is
UPDATE msdb.dbo.sysjobs
SET originating_server = 'NewServerName'
WHERE originating_server = 'OldServerName'
enough in case of msdb?
The old server is Windows 2000 Advanced Server SP4, HP
Proliant DL 380 G3 with 2 x 2.4 GHz Intel Xeon
Hyper-Threading CPUs, 4GB RAM, of which 2GB is for apps,
and HP SmartArray 5300/256 Ultra SCSI 320 RAID controller
with Ultra SCSI 320 15k RPM disks attached. The new server
is Windows 2003 Server Standart SP1, HP ProLiant DL 380 G4
with 2 x 3.6 GHz Intel Xeon Hyper-Threading CPUs, 3.5 GB of
app/OS RAM, the same RAID setup as in the old server.
I haven't changed any SQL Server settings on the old
server, except CPU affinity mask to use just one virtual
CPU on each of the physical CPUs and max. degree of
paralellism to 1.
Is SQL Server Setup aware of more advanced hardware of the
new server to such an extent that it can automatically
produce more optimal SQL server settings (stored in master)
than they were produced for the old server?
I.e. will the auto-generated settings in master database
from old server hurt performance on the new server?
--
Many, many thanks,
OskSee if this helps:
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
AMB
"Osk" wrote:
> Hi
> Evironment: SQL Server 2000 SP3a
> I want to restore master & msdb (which transfers login,
> settings, jobs etc.) of old server to the new server. What
> are the possible issues with this approach, if any? Is
> UPDATE msdb.dbo.sysjobs
> SET originating_server = 'NewServerName'
> WHERE originating_server = 'OldServerName'
> enough in case of msdb?
> The old server is Windows 2000 Advanced Server SP4, HP
> Proliant DL 380 G3 with 2 x 2.4 GHz Intel Xeon
> Hyper-Threading CPUs, 4GB RAM, of which 2GB is for apps,
> and HP SmartArray 5300/256 Ultra SCSI 320 RAID controller
> with Ultra SCSI 320 15k RPM disks attached. The new server
> is Windows 2003 Server Standart SP1, HP ProLiant DL 380 G4
> with 2 x 3.6 GHz Intel Xeon Hyper-Threading CPUs, 3.5 GB of
> app/OS RAM, the same RAID setup as in the old server.
> I haven't changed any SQL Server settings on the old
> server, except CPU affinity mask to use just one virtual
> CPU on each of the physical CPUs and max. degree of
> paralellism to 1.
> Is SQL Server Setup aware of more advanced hardware of the
> new server to such an extent that it can automatically
> produce more optimal SQL server settings (stored in master)
> than they were produced for the old server?
> I.e. will the auto-generated settings in master database
> from old server hurt performance on the new server?
>
> --
> Many, many thanks,
> Osk
>

Restoring Master db after Reinstall

After reinstall of sql server and applying SP3a I can't restore a saved
copy of Master. Receiving massage " the backup of the system database
on device '*:\***\...bak' cannot be restored because it was created by a
different version of the server (134218646) than this server(134218488).
Restore database is terminating abnormally."
Which SP do I need to get to SoftwareVersionBuild = 818
Hi Jim,
I believe the recipe for Build 8.00.818 is:
SP3 + Q821277/Q821337/Q818388/Q826161/Q821280
Steven Hutchinson,
IT Support Engineer,
Tayside Fire Brigade.
"Jim C." <Jim C.@.discussions.microsoft.com> wrote in message
news:32E29BC8-A586-496C-A191-D2CE5CC7E3F9@.microsoft.com...
> After reinstall of sql server and applying SP3a I can't restore a saved
> copy of Master. Receiving massage " the backup of the system database
> on device '*:\***\...bak' cannot be restored because it was created by a
> different version of the server (134218646) than this server(134218488).
> Restore database is terminating abnormally."
> Which SP do I need to get to SoftwareVersionBuild = 818
|||Thanks Steve. I tried SP3A and that didn't do it.
"Steven Hutchinson" wrote:

> Hi Jim,
> I believe the recipe for Build 8.00.818 is:
> SP3 + Q821277/Q821337/Q818388/Q826161/Q821280
>
> --
> Steven Hutchinson,
> IT Support Engineer,
> Tayside Fire Brigade.
>
> "Jim C." <Jim C.@.discussions.microsoft.com> wrote in message
> news:32E29BC8-A586-496C-A191-D2CE5CC7E3F9@.microsoft.com...
>
>

Restoring Master db after Reinstall

After reinstall of sql server and applying SP3a I can't restore a saved
copy of Master. Receiving massage " the backup of the system database
on device '*:\***\...bak' cannot be restored because it was created by a
different version of the server (134218646) than this server(134218488).
Restore database is terminating abnormally."
Which SP do I need to get to SoftwareVersionBuild = 818
Hi Jim,
I believe the recipe for Build 8.00.818 is:
SP3 + Q821277/Q821337/Q818388/Q826161/Q821280
Steven Hutchinson,
IT Support Engineer,
Tayside Fire Brigade.
"Jim C." <Jim C.@.discussions.microsoft.com> wrote in message
news:32E29BC8-A586-496C-A191-D2CE5CC7E3F9@.microsoft.com...
> After reinstall of sql server and applying SP3a I can't restore a saved
> copy of Master. Receiving massage " the backup of the system database
> on device '*:\***\...bak' cannot be restored because it was created by a
> different version of the server (134218646) than this server(134218488).
> Restore database is terminating abnormally."
> Which SP do I need to get to SoftwareVersionBuild = 818
|||Thanks Steve. I tried SP3A and that didn't do it.
"Steven Hutchinson" wrote:

> Hi Jim,
> I believe the recipe for Build 8.00.818 is:
> SP3 + Q821277/Q821337/Q818388/Q826161/Q821280
>
> --
> Steven Hutchinson,
> IT Support Engineer,
> Tayside Fire Brigade.
>
> "Jim C." <Jim C.@.discussions.microsoft.com> wrote in message
> news:32E29BC8-A586-496C-A191-D2CE5CC7E3F9@.microsoft.com...
>
>

Restoring Master db after Reinstall

After reinstall of sql server and applying SP3a I can't restore a saved
copy of Master. Receiving massage " the backup of the system database
on device '*:\***\...bak' cannot be restored because it was created by a
different version of the server (134218646) than this server(134218488).
Restore database is terminating abnormally."
Which SP do I need to get to SoftwareVersionBuild = 818Hi Jim,
I believe the recipe for Build 8.00.818 is:
SP3 + Q821277/Q821337/Q818388/Q826161/Q821280
Steven Hutchinson,
IT Support Engineer,
Tayside Fire Brigade.
"Jim C." <Jim C.@.discussions.microsoft.com> wrote in message
news:32E29BC8-A586-496C-A191-D2CE5CC7E3F9@.microsoft.com...
> After reinstall of sql server and applying SP3a I can't restore a saved
> copy of Master. Receiving massage " the backup of the system database
> on device '*:\***\...bak' cannot be restored because it was created by a
> different version of the server (134218646) than this server(134218488).
> Restore database is terminating abnormally."
> Which SP do I need to get to SoftwareVersionBuild = 818|||Thanks Steve. I tried SP3A and that didn't do it.
"Steven Hutchinson" wrote:
> Hi Jim,
> I believe the recipe for Build 8.00.818 is:
> SP3 + Q821277/Q821337/Q818388/Q826161/Q821280
>
> --
> Steven Hutchinson,
> IT Support Engineer,
> Tayside Fire Brigade.
>
> "Jim C." <Jim C.@.discussions.microsoft.com> wrote in message
> news:32E29BC8-A586-496C-A191-D2CE5CC7E3F9@.microsoft.com...
> > After reinstall of sql server and applying SP3a I can't restore a saved
> > copy of Master. Receiving massage " the backup of the system database
> > on device '*:\***\...bak' cannot be restored because it was created by a
> > different version of the server (134218646) than this server(134218488).
> >
> > Restore database is terminating abnormally."
> >
> > Which SP do I need to get to SoftwareVersionBuild = 818
>
>

Restoring Master Database errors on SQL 2000 SP3a

Hi All
I work in a envoriment where i restore lots of master
database for specfic reason.
The problem i am currently encountering is the following
When i attempt to restore the Master database is SQL
Enterprise Manager (in single user mode) i get a error
box with a title of sql-dmo odbc sqlstate: HY000 and
nothing else.
It then kills the SQL service which i can then restart as
normal but the master database is not restored.
If i attempt to restore via SQL Query Anylzer i just get
connect broken and the SQL service is stopped.
The only way i have found to restore my master database is
to reinstall SQL from scratch which is very time consuming.
Has anyone else seen this and now how to workaround this
issue with out reinstalling SQL
Many Thanks
Martin Cheetham
Hi,
I have never ended up in this situation. I recommend you to try rebuilding
the MASTER database using REBUILDM.EXE rather than reinstalling SQL Server.
After rebulding the master you can restore the database
using the normal procedure
Thanks
Hari
MCDBA
"Martin Cheetham" <martin_cheetham@.yahoo.co.uk> wrote in message
news:237a101c45e86$4c7f5b60$a401280a@.phx.gbl...
> Hi All
> I work in a envoriment where i restore lots of master
> database for specfic reason.
> The problem i am currently encountering is the following
> When i attempt to restore the Master database is SQL
> Enterprise Manager (in single user mode) i get a error
> box with a title of sql-dmo odbc sqlstate: HY000 and
> nothing else.
> It then kills the SQL service which i can then restart as
> normal but the master database is not restored.
> If i attempt to restore via SQL Query Anylzer i just get
> connect broken and the SQL service is stopped.
> The only way i have found to restore my master database is
> to reinstall SQL from scratch which is very time consuming.
> Has anyone else seen this and now how to workaround this
> issue with out reinstalling SQL
> Many Thanks
> Martin Cheetham

Restoring Master Database errors on SQL 2000 SP3a

Hi All
I work in a envoriment where i restore lots of master
database for specfic reason.
The problem i am currently encountering is the following
When i attempt to restore the Master database is SQL
Enterprise Manager (in single user mode) i get a error
box with a title of sql-dmo odbc sqlstate: HY000 and
nothing else.
It then kills the SQL service which i can then restart as
normal but the master database is not restored.
If i attempt to restore via SQL Query Anylzer i just get
connect broken and the SQL service is stopped.
The only way i have found to restore my master database is
to reinstall SQL from scratch which is very time consuming.
Has anyone else seen this and now how to workaround this
issue with out reinstalling SQL
Many Thanks
Martin CheethamHi,
I have never ended up in this situation. I recommend you to try rebuilding
the MASTER database using REBUILDM.EXE rather than reinstalling SQL Server.
After rebulding the master you can restore the database
using the normal procedure
--
Thanks
Hari
MCDBA
"Martin Cheetham" <martin_cheetham@.yahoo.co.uk> wrote in message
news:237a101c45e86$4c7f5b60$a401280a@.phx.gbl...
> Hi All
> I work in a envoriment where i restore lots of master
> database for specfic reason.
> The problem i am currently encountering is the following
> When i attempt to restore the Master database is SQL
> Enterprise Manager (in single user mode) i get a error
> box with a title of sql-dmo odbc sqlstate: HY000 and
> nothing else.
> It then kills the SQL service which i can then restart as
> normal but the master database is not restored.
> If i attempt to restore via SQL Query Anylzer i just get
> connect broken and the SQL service is stopped.
> The only way i have found to restore my master database is
> to reinstall SQL from scratch which is very time consuming.
> Has anyone else seen this and now how to workaround this
> issue with out reinstalling SQL
> Many Thanks
> Martin Cheetham

Restoring Master Database errors on SQL 2000 SP3a

Hi All
I work in a envoriment where i restore lots of master
database for specfic reason.
The problem i am currently encountering is the following
When i attempt to restore the Master database is SQL
Enterprise Manager (in single user mode) i get a error
box with a title of sql-dmo odbc sqlstate: HY000 and
nothing else.
It then kills the SQL service which i can then restart as
normal but the master database is not restored.
If i attempt to restore via SQL Query Anylzer i just get
connect broken and the SQL service is stopped.
The only way i have found to restore my master database is
to reinstall SQL from scratch which is very time consuming.
Has anyone else seen this and now how to workaround this
issue with out reinstalling SQL
Many Thanks
Martin CheethamHi,
I have never ended up in this situation. I recommend you to try rebuilding
the MASTER database using REBUILDM.EXE rather than reinstalling SQL Server.
After rebulding the master you can restore the database
using the normal procedure
Thanks
Hari
MCDBA
"Martin Cheetham" <martin_cheetham@.yahoo.co.uk> wrote in message
news:237a101c45e86$4c7f5b60$a401280a@.phx
.gbl...
> Hi All
> I work in a envoriment where i restore lots of master
> database for specfic reason.
> The problem i am currently encountering is the following
> When i attempt to restore the Master database is SQL
> Enterprise Manager (in single user mode) i get a error
> box with a title of sql-dmo odbc sqlstate: HY000 and
> nothing else.
> It then kills the SQL service which i can then restart as
> normal but the master database is not restored.
> If i attempt to restore via SQL Query Anylzer i just get
> connect broken and the SQL service is stopped.
> The only way i have found to restore my master database is
> to reinstall SQL from scratch which is very time consuming.
> Has anyone else seen this and now how to workaround this
> issue with out reinstalling SQL
> Many Thanks
> Martin Cheetham

restoring from network drive

Ok -I'm drawing a huge blank.
After a new install of SQL2K and SP3a, I'm unable to restore a backup from a
network drive.
SQL services are logging on with a domain account
The SQL service account has also been granted Local admin access on the PC
When trying to restore a database from Device, the only drive listed is the
local C: drive - none of the mapped drives are available.
JTTry entering a UNC name for the name of the backup, something like:
\\backupserver\sharename\backup\database
.bak
Also note the MSSQLSERVER service account will need access to the network
share.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"JT" <JT_*n*o*s*p*a*m*Goalie33@.cox.net> wrote in message
news:WAZzc.4489$cj3.1501@.lakeread01...
> Ok -I'm drawing a huge blank.
> After a new install of SQL2K and SP3a, I'm unable to restore a backup from
a
> network drive.
> SQL services are logging on with a domain account
> The SQL service account has also been granted Local admin access on the PC
> When trying to restore a database from Device, the only drive listed is
the
> local C: drive - none of the mapped drives are available.
> JT
>

restoring from network drive

Ok -I'm drawing a huge blank.
After a new install of SQL2K and SP3a, I'm unable to restore a backup from a
network drive.
SQL services are logging on with a domain account
The SQL service account has also been granted Local admin access on the PC
When trying to restore a database from Device, the only drive listed is the
local C: drive - none of the mapped drives are available.
JT
Try entering a UNC name for the name of the backup, something like:
\\backupserver\sharename\backup\database.bak
Also note the MSSQLSERVER service account will need access to the network
share.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"JT" <JT_*n*o*s*p*a*m*Goalie33@.cox.net> wrote in message
news:WAZzc.4489$cj3.1501@.lakeread01...
> Ok -I'm drawing a huge blank.
> After a new install of SQL2K and SP3a, I'm unable to restore a backup from
a
> network drive.
> SQL services are logging on with a domain account
> The SQL service account has also been granted Local admin access on the PC
> When trying to restore a database from Device, the only drive listed is
the
> local C: drive - none of the mapped drives are available.
> JT
>

restoring from network drive

Ok -I'm drawing a huge blank.
After a new install of SQL2K and SP3a, I'm unable to restore a backup from a
network drive.
SQL services are logging on with a domain account
The SQL service account has also been granted Local admin access on the PC
When trying to restore a database from Device, the only drive listed is the
local C: drive - none of the mapped drives are available.
JTTry entering a UNC name for the name of the backup, something like:
\\backupserver\sharename\backup\database.bak
Also note the MSSQLSERVER service account will need access to the network
share.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"JT" <JT_*n*o*s*p*a*m*Goalie33@.cox.net> wrote in message
news:WAZzc.4489$cj3.1501@.lakeread01...
> Ok -I'm drawing a huge blank.
> After a new install of SQL2K and SP3a, I'm unable to restore a backup from
a
> network drive.
> SQL services are logging on with a domain account
> The SQL service account has also been granted Local admin access on the PC
> When trying to restore a database from Device, the only drive listed is
the
> local C: drive - none of the mapped drives are available.
> JT
>|||SQL Server will only show local drives/partitions on the
computer you are trying to restore to...Use UNC names/IP
adresses when restoring from a network drive.
EX:
RESTORE DATABASE MYDATABASE
FROM DISK = '\\SERVER1\D$\Program Files\Microsoft SQL
Server\MSSQL\Backup\MYDATABASE\MYDATABASE.BAK'
WITH
DBO_ONLY,
REPLACE,
STANDBY = '\\SERVER1\D$\Program Files\Microsoft SQL
Server\MSSQL\Backup\MYDATABASE\'UNDO_MYDATABASE.ldf',
MOVE 'MYDATABASE_Data' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MYDATABASE_Data.mdf',
MOVE 'MYDATABASE_Log' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MYDATABASE_Log.ldf'
e.t.c
>--Original Message--
>Ok -I'm drawing a huge blank.
>After a new install of SQL2K and SP3a, I'm unable to
restore a backup from a
>network drive.
>SQL services are logging on with a domain account
>The SQL service account has also been granted Local admin
access on the PC
>When trying to restore a database from Device, the only
drive listed is the
>local C: drive - none of the mapped drives are available.
>JT
>
>.
>