|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Restoring master and msdb on a different server
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" <Os***@discussions.microsoft.com> wrote in message I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@microsoft.com... Hi 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. -- Show quoteHide quoteMany 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" <Os***@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. -- Show quoteHide quoteMany 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" <Os***@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. -- Show quoteHide quoteMany 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" <Os***@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. -- Show quoteHide quoteMany 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" <Os***@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. -- Show quoteHide quoteMany 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" <Os***@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. -- Show quoteHide quoteMany 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" <Os***@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. -- Show quoteHide quoteMany 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" <Os***@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 > > >  
Other interesting topics
MS Access Query vs. SQL 7 Stored Procedure
MS PSS-What the heck is this?! Basic question.... on Index.... Problem with osql.exe -L full drives full trans log version 7 alter table drop column and dbcc cleantable SQL7 2 DB files down to one??? SQLServer Agent varchar vs nvarchar stored procedure with different criteria |
|||||||||||||||||||||||
