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 th
at
> 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...
>
>|||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...[vbcol=seagreen]
>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:
>|||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...
>|||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...
>