restoring master on sp3 to sp2

I have torestore a master database from sql server 2000 running sp2 onto a
sql server 2000 running sp3. Would it cause any issues? Thanks.
Hi
"sharman" wrote:

> I have torestore a master database from sql server 2000 running sp2 onto a
> sql server 2000 running sp3. Would it cause any issues? Thanks.
Why?
You should have backed up the system database post upgrade (the installation
does tell you to do that!!)
John
|||Hi John,
I think I haven't phrased my question correctly. My question is can I
restore master, model and msdb on sql 2000 sp3 from backups that were backed
up on SQL 2000 SP2?
"John Bell" wrote:

> Hi
> "sharman" wrote:
>
> Why?
> You should have backed up the system database post upgrade (the installation
> does tell you to do that!!)
> John
|||Hi
On Jun 27, 5:14 pm, sharman <shar...@.discussions.microsoft.com> wrote:
> Hi John,
> I think I haven't phrased my question correctly. My question is can I
> restore master, model and msdb on sql 2000 sp3 from backups that were backed
> up on SQL 2000 SP2?
>
> "John Bell" wrote:
>
>
>
> - Show quoted text -
You can try this!! AFAIK there is no guarantee that something has
changed in a service pack or that it will work correctly, therefore it
is best to restore the same level.
John

restoring master on sp3 to sp2

I have torestore a master database from sql server 2000 running sp2 onto a
sql server 2000 running sp3. Would it cause any issues? Thanks.Hi
"sharman" wrote:

> I have torestore a master database from sql server 2000 running sp2 onto a
> sql server 2000 running sp3. Would it cause any issues? Thanks.
Why?
You should have backed up the system database post upgrade (the installation
does tell you to do that!!)
John|||Hi John,
I think I haven't phrased my question correctly. My question is can I
restore master, model and msdb on sql 2000 sp3 from backups that were backed
up on SQL 2000 SP2?
"John Bell" wrote:

> Hi
> "sharman" wrote:
>
> Why?
> You should have backed up the system database post upgrade (the installati
on
> does tell you to do that!!)
> John|||Hi
On Jun 27, 5:14 pm, sharman <shar...@.discussions.microsoft.com> wrote:
> Hi John,
> I think I haven't phrased my question correctly. My question is can I
> restore master, model and msdb on sql 2000 sp3 from backups that were back
ed
> up on SQL 2000 SP2?
>
> "John Bell" wrote:
>
>
>
>
>
> - Show quoted text -
You can try this!! AFAIK there is no guarantee that something has
changed in a service pack or that it will work correctly, therefore it
is best to restore the same level.
John

restoring master on sp3 to sp2

I have torestore a master database from sql server 2000 running sp2 onto a
sql server 2000 running sp3. Would it cause any issues? Thanks.Hi
"sharman" wrote:
> I have torestore a master database from sql server 2000 running sp2 onto a
> sql server 2000 running sp3. Would it cause any issues? Thanks.
Why?
You should have backed up the system database post upgrade (the installation
does tell you to do that!!)
John|||Hi John,
I think I haven't phrased my question correctly. My question is can I
restore master, model and msdb on sql 2000 sp3 from backups that were backed
up on SQL 2000 SP2?
"John Bell" wrote:
> Hi
> "sharman" wrote:
> > I have torestore a master database from sql server 2000 running sp2 onto a
> > sql server 2000 running sp3. Would it cause any issues? Thanks.
> Why?
> You should have backed up the system database post upgrade (the installation
> does tell you to do that!!)
> John|||Hi
On Jun 27, 5:14 pm, sharman <shar...@.discussions.microsoft.com> wrote:
> Hi John,
> I think I haven't phrased my question correctly. My question is can I
> restore master, model and msdb on sql 2000 sp3 from backups that were backed
> up on SQL 2000 SP2?
>
> "John Bell" wrote:
> > Hi
> > "sharman" wrote:
> > > I have torestore a master database from sql server 2000 running sp2 onto a
> > > sql server 2000 running sp3. Would it cause any issues? Thanks.
> > Why?
> > You should have backed up the system database post upgrade (the installation
> > does tell you to do that!!)
> > John- Hide quoted text -
> - Show quoted text -
You can try this!! AFAIK there is no guarantee that something has
changed in a service pack or that it will work correctly, therefore it
is best to restore the same level.
John

Restoring Master database

Hi,
Production Server: Windows 2000 server, SQL Server 2000 SP2
Test Server: Windows 2003 server, SQL Server 2000 SP3
I have to restore the master database from Production Server to Test Server.
Would it cause any issues? Thanks.Sharman,
Yes. Since logins, databases, linked servers, etc. are all defined in
master, those definitions on the Test Server will be replaced with the
definitions from the Production Server. Any unique logins will be
eliminated, databases may become unattached, and so forth.
So, you can do it, but you have to be very careful not to lose anything that
you need. You might restore master to your test server as
'master_from_prod' and determine what you have to do to merge any
differences.
(I do not fathom why Production master is needed on Test unless a pretty
good slice of other databases is also being brought over to Test as well.)
RLF
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:985B0C8F-6D5E-481C-8FD4-A60B7F043FB0@.microsoft.com...
> Hi,
> Production Server: Windows 2000 server, SQL Server 2000 SP2
> Test Server: Windows 2003 server, SQL Server 2000 SP3
> I have to restore the master database from Production Server to Test
> Server.
> Would it cause any issues? Thanks.|||I am asking this question because of the different Service Packs on
Production and Test servers with Production having a lower Service Pack. I
have read that Service Packs apply changes to system tables and I am
restoring a master created on SP2 on a SQL Server running SP3.
Once the restore of master is successful I will be restoring the other
system and user databases from Production Server as well.
"Russell Fields" wrote:
> Sharman,
> Yes. Since logins, databases, linked servers, etc. are all defined in
> master, those definitions on the Test Server will be replaced with the
> definitions from the Production Server. Any unique logins will be
> eliminated, databases may become unattached, and so forth.
> So, you can do it, but you have to be very careful not to lose anything that
> you need. You might restore master to your test server as
> 'master_from_prod' and determine what you have to do to merge any
> differences.
> (I do not fathom why Production master is needed on Test unless a pretty
> good slice of other databases is also being brought over to Test as well.)
> RLF
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:985B0C8F-6D5E-481C-8FD4-A60B7F043FB0@.microsoft.com...
> > Hi,
> >
> > Production Server: Windows 2000 server, SQL Server 2000 SP2
> > Test Server: Windows 2003 server, SQL Server 2000 SP3
> >
> > I have to restore the master database from Production Server to Test
> > Server.
> > Would it cause any issues? Thanks.
>
>|||sharman,
It was a while back, but I believe that SQL 2000 SP4 was the only one that
changed the format of the system tables in the SQL 2000 timeline.
RLF
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4BB1EF1C-D7B9-43F6-B4AB-A64CA0A20834@.microsoft.com...
>I am asking this question because of the different Service Packs on
> Production and Test servers with Production having a lower Service Pack. I
> have read that Service Packs apply changes to system tables and I am
> restoring a master created on SP2 on a SQL Server running SP3.
> Once the restore of master is successful I will be restoring the other
> system and user databases from Production Server as well.
>
> "Russell Fields" wrote:
>> Sharman,
>> Yes. Since logins, databases, linked servers, etc. are all defined in
>> master, those definitions on the Test Server will be replaced with the
>> definitions from the Production Server. Any unique logins will be
>> eliminated, databases may become unattached, and so forth.
>> So, you can do it, but you have to be very careful not to lose anything
>> that
>> you need. You might restore master to your test server as
>> 'master_from_prod' and determine what you have to do to merge any
>> differences.
>> (I do not fathom why Production master is needed on Test unless a pretty
>> good slice of other databases is also being brought over to Test as
>> well.)
>> RLF
>> "sharman" <sharman@.discussions.microsoft.com> wrote in message
>> news:985B0C8F-6D5E-481C-8FD4-A60B7F043FB0@.microsoft.com...
>> > Hi,
>> >
>> > Production Server: Windows 2000 server, SQL Server 2000 SP2
>> > Test Server: Windows 2003 server, SQL Server 2000 SP3
>> >
>> > I have to restore the master database from Production Server to Test
>> > Server.
>> > Would it cause any issues? Thanks.
>>|||There is more to it than logins I think. Isn't the location of all
databases stored there? Other stuff too . . .
--
TheSQLGuru
President
Indicium Resources, Inc.
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:e$$AvFNuHHA.3404@.TK2MSFTNGP03.phx.gbl...
> Sharman,
> Yes. Since logins, databases, linked servers, etc. are all defined in
> master, those definitions on the Test Server will be replaced with the
> definitions from the Production Server. Any unique logins will be
> eliminated, databases may become unattached, and so forth.
> So, you can do it, but you have to be very careful not to lose anything
> that you need. You might restore master to your test server as
> 'master_from_prod' and determine what you have to do to merge any
> differences.
> (I do not fathom why Production master is needed on Test unless a pretty
> good slice of other databases is also being brought over to Test as well.)
> RLF
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:985B0C8F-6D5E-481C-8FD4-A60B7F043FB0@.microsoft.com...
>> Hi,
>> Production Server: Windows 2000 server, SQL Server 2000 SP2
>> Test Server: Windows 2003 server, SQL Server 2000 SP3
>> I have to restore the master database from Production Server to Test
>> Server.
>> Would it cause any issues? Thanks.
>|||I'd rather apply the SQL patches than restore master from PROD to TEST
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:utqOUsZuHHA.484@.TK2MSFTNGP06.phx.gbl...
> There is more to it than logins I think. Isn't the location of all
> databases stored there? Other stuff too . . .
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:e$$AvFNuHHA.3404@.TK2MSFTNGP03.phx.gbl...
>> Sharman,
>> Yes. Since logins, databases, linked servers, etc. are all defined in
>> master, those definitions on the Test Server will be replaced with the
>> definitions from the Production Server. Any unique logins will be
>> eliminated, databases may become unattached, and so forth.
>> So, you can do it, but you have to be very careful not to lose anything
>> that you need. You might restore master to your test server as
>> 'master_from_prod' and determine what you have to do to merge any
>> differences.
>> (I do not fathom why Production master is needed on Test unless a pretty
>> good slice of other databases is also being brought over to Test as
>> well.)
>> RLF
>> "sharman" <sharman@.discussions.microsoft.com> wrote in message
>> news:985B0C8F-6D5E-481C-8FD4-A60B7F043FB0@.microsoft.com...
>> Hi,
>> Production Server: Windows 2000 server, SQL Server 2000 SP2
>> Test Server: Windows 2003 server, SQL Server 2000 SP3
>> I have to restore the master database from Production Server to Test
>> Server.
>> Would it cause any issues? Thanks.
>>
>

Restoring master and msdb on a different server

Hi
I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
Server 2003 SP1 and MS SQL Server 2000 SP3.
The SQL Server on the weaker machine has affinity mask turned on to use
only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
located on drive E:.
The SQL Server on the stronger machine has master and msdb located on
drive C:, affinity mask set off, and dynamic memory allocation set on.
Can I restore the master database from the weaker machine on the stronger
machine and is it a good idea?
Many thanks,
OskarCan you do it? Sure. Is it a good idea or not? That depends on why you
would want to do it. What are you trying to accomplish?
Also, the weaker machine, you said, is only a 2-way CPU box, why would you
have a 2 CPU affinity set on it?
Sincerely,
Anthony Thomas
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
Hi
I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
Server 2003 SP1 and MS SQL Server 2000 SP3.
The SQL Server on the weaker machine has affinity mask turned on to use
only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
located on drive E:.
The SQL Server on the stronger machine has master and msdb located on
drive C:, affinity mask set off, and dynamic memory allocation set on.
Can I restore the master database from the weaker machine on the stronger
machine and is it a good idea?
Many thanks,
Oskar|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>

Restoring master and msdb on a different server

Hi
I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
Server 2003 SP1 and MS SQL Server 2000 SP3.
The SQL Server on the weaker machine has affinity mask turned on to use
only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
located on drive E:.
The SQL Server on the stronger machine has master and msdb located on
drive C:, affinity mask set off, and dynamic memory allocation set on.
Can I restore the master database from the weaker machine on the stronger
machine and is it a good idea?
Many thanks,
Oskar
Can you do it? Sure. Is it a good idea or not? That depends on why you
would want to do it. What are you trying to accomplish?
Also, the weaker machine, you said, is only a 2-way CPU box, why would you
have a 2 CPU affinity set on it?
Sincerely,
Anthony Thomas

"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
Hi
I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
Server 2003 SP1 and MS SQL Server 2000 SP3.
The SQL Server on the weaker machine has affinity mask turned on to use
only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
located on drive E:.
The SQL Server on the stronger machine has master and msdb located on
drive C:, affinity mask set off, and dynamic memory allocation set on.
Can I restore the master database from the weaker machine on the stronger
machine and is it a good idea?
Many thanks,
Oskar
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>

Restoring master and msdb on a different server

Hi
I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
Server 2003 SP1 and MS SQL Server 2000 SP3.
The SQL Server on the weaker machine has affinity mask turned on to use
only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
located on drive E:.
The SQL Server on the stronger machine has master and msdb located on
drive C:, affinity mask set off, and dynamic memory allocation set on.
Can I restore the master database from the weaker machine on the stronger
machine and is it a good idea?
--
Many thanks,
OskarCan you do it? Sure. Is it a good idea or not? That depends on why you
would want to do it. What are you trying to accomplish?
Also, the weaker machine, you said, is only a 2-way CPU box, why would you
have a 2 CPU affinity set on it?
Sincerely,
Anthony Thomas
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
Hi
I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
Server 2003 SP1 and MS SQL Server 2000 SP3.
The SQL Server on the weaker machine has affinity mask turned on to use
only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
located on drive E:.
The SQL Server on the stronger machine has master and msdb located on
drive C:, affinity mask set off, and dynamic memory allocation set on.
Can I restore the master database from the weaker machine on the stronger
machine and is it a good idea?
--
Many thanks,
Oskar|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
--
Many thanks,
Oskar
"Anthony Thomas" wrote:
> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
--
Many thanks,
Oskar
"Anthony Thomas" wrote:
> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
--
Many thanks,
Oskar
"Anthony Thomas" wrote:
> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
--
Many thanks,
Oskar
"Anthony Thomas" wrote:
> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
--
Many thanks,
Oskar
"Anthony Thomas" wrote:
> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
--
Many thanks,
Oskar
"Anthony Thomas" wrote:
> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
--
Many thanks,
Oskar
"Anthony Thomas" wrote:
> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>