Restrict access to certain db

I need to install EM and QA on some users machines, but I only want them to
have access to certain db's, What is best way to manage this? ALso, in QA I
want them to only be able to run Select/Update/Make Table queries. How do
I force a user to logon whe
n they open EM or QA with a certain login account?Hi,
1. Create a new login in sql server (Use enterprise manager -- Security
option)
2. Go to database and select users option and add a new user
3. Assign that user db_reader and db_writer role (this will only allow that
user to browse and update/insert/delete contents in this database)
4. Login to QA as SA user
5. Select the database in which the user need create table prev.
6. Execute "Grant CREATE TABLE to <User name>
If you need to restrict the Insert and Delete from tables - Have a look into
DENY command .
Tahnks
Hari
MCDBA
"mikeb" <anonymous@.discussions.microsoft.com> wrote in message
news:AAC88C32-6D4C-44C8-B6D8-607F078F6A7A@.microsoft.com...
> I need to install EM and QA on some users machines, but I only want them
to have access to certain db's, What is best way to manage this? ALso, in
QA I want them to only be able to run Select/Update/Make Table queries. How
do I force a user to logon when they open EM or QA with a certain login
account?

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
>
>

Restoring encrypted databases between different servers

Hello:

I'm working with two sql servers instances, ServerA and ServerB, which run under two different service accounts on different machines. They both have a database, DatabaseA, that has some encrypted fields.

If I take a backup of DatabaseA on ServerA and restore it on ServerB, I need to re-encrypt the Database Master Key (DMK) with the Service Master Key (SMK) as follows:

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'pwd used to encrypt DMK'

ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY

However, if I again take a backup on ServerB and then restore it on ServerA, I can use the DMK on ServerA without re-encrypting it with the SMK.

Shouldn't I have to re-encrypt the DMK with the SMK everytime I restore from a backup that was generated from a different server?

Thanks,

Cyndi

After the initial RESTORE and ALTER MASTER KEY … ADD ENCRYPTION BY SERVER MASTER KEY on ServerB, a redundant copy of the DBMK (protected by ServerB SMK) will be stored in the mater DB; and as long as the DBMK is the same, the copies should be synchronized. This redundant copy is there to minimize the DBMK management after the initial setup (via RESTORE).

I hope this information helps. Please let us know if you have any additional questions and/or if you have any additional feedback.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine