Can I copy Databases from a server with SQL Server 2000 (RTM) to another
server with SQL Server 2000 (SP3a) without corruptions or problems? What
about from SQL2K RTM to SQL2K SP4? I need to upgrade to SP4 because one
application is requiring SP4 before we can upgrade to the new version.
So far I was able to do a detach / attach from RTM to SP3a and I have not
seen any problems yet? But I am not sure that will be the case with SP4.

If I backup, copy, and attach a Database that was on the SQL2K RTM server on
the server with SQL2K SP3a, can I just be copying the data from the RTM
server to the SP3a server? Does SP3a or SP4 do changes to a User Database
like modify tables? It makes changes to the Master tables, right? I believe
the SPs change the Master tables, but I am not sure if it changes the tables
or modify a Database that I create.

Posted similar question on: SQL Server Group.
Thanks in advance for your .
:-)

Dave,

There should be no problem copying a SQL Server 2000 database from RTM to
SP3a or SP4.

The SQL 2000 SPs do not change user databases, though SP4 does change
master, model, and msdb.

You should be able to move forward without any problems. Of course, you can
always test one database out and build up your confidence that way, prior to
making the big jump.

RLF


"Dave" <Dave@discussions.microsoft.com> wrote in message
news:897685E5-B7E4-47D0-824C-CACC8C64405C@microsoft.com...
> Can I copy Databases from a server with SQL Server 2000 (RTM) to another
> server with SQL Server 2000 (SP3a) without corruptions or problems? What
> about from SQL2K RTM to SQL2K SP4? I need to upgrade to SP4 because one
> application is requiring SP4 before we can upgrade to the new version.
> So far I was able to do a detach / attach from RTM to SP3a and I have not
> seen any problems yet? But I am not sure that will be the case with SP4.
>
> If I backup, copy, and attach a Database that was on the SQL2K RTM server
> on
> the server with SQL2K SP3a, can I just be copying the data from the RTM
> server to the SP3a server? Does SP3a or SP4 do changes to a User Database
> like modify tables? It makes changes to the Master tables, right? I
> believe
> the SPs change the Master tables, but I am not sure if it changes the
> tables
> or modify a Database that I create.
>
> Posted similar question on: SQL Server Group.
> Thanks in advance for your .
> :-)
>

For SQL Server 2000, the two instances should have the same build number for
this to be successful, such as, if the source instance has 8.0.2191, the
destination instance should also be the same


"Russell Fields" <russellfields@nomail.com> wrote in message
news:ujU9LwXvHHA.4348@TK2MSFTNGP06.phx.gbl...
> Dave,
>
> There should be no problem copying a SQL Server 2000 database from RTM to
> SP3a or SP4.
>
> The SQL 2000 SPs do not change user databases, though SP4 does change
> master, model, and msdb.
>
> You should be able to move forward without any problems. Of course, you
> can always test one database out and build up your confidence that way,
> prior to making the big jump.
>
> RLF
>
>
> "Dave" <Dave@discussions.microsoft.com> wrote in message
> news:897685E5-B7E4-47D0-824C-CACC8C64405C@microsoft.com...
>> Can I copy Databases from a server with SQL Server 2000 (RTM) to another
>> server with SQL Server 2000 (SP3a) without corruptions or problems? What
>> about from SQL2K RTM to SQL2K SP4? I need to upgrade to SP4 because one
>> application is requiring SP4 before we can upgrade to the new version.
>> So far I was able to do a detach / attach from RTM to SP3a and I have not
>> seen any problems yet? But I am not sure that will be the case with SP4.
>>
>> If I backup, copy, and attach a Database that was on the SQL2K RTM server
>> on
>> the server with SQL2K SP3a, can I just be copying the data from the RTM
>> server to the SP3a server? Does SP3a or SP4 do changes to a User
>> Database
>> like modify tables? It makes changes to the Master tables, right? I
>> believe
>> the SPs change the Master tables, but I am not sure if it changes the
>> tables
>> or modify a Database that I create.
>>
>> Posted similar question on: SQL Server Group.
>> Thanks in advance for your .
>> :-)
>>
>
>

Thank you very much for your .


"Russell Fields" wrote:

> Dave,
>
> There should be no problem copying a SQL Server 2000 database from RTM to
> SP3a or SP4.
>
> The SQL 2000 SPs do not change user databases, though SP4 does change
> master, model, and msdb.
>
> You should be able to move forward without any problems. Of course, you can
> always test one database out and build up your confidence that way, prior to
> making the big jump.
>
> RLF
>
>
> "Dave" <Dave@discussions.microsoft.com> wrote in message
> news:897685E5-B7E4-47D0-824C-CACC8C64405C@microsoft.com...
> > Can I copy Databases from a server with SQL Server 2000 (RTM) to another
> > server with SQL Server 2000 (SP3a) without corruptions or problems? What
> > about from SQL2K RTM to SQL2K SP4? I need to upgrade to SP4 because one
> > application is requiring SP4 before we can upgrade to the new version.
> > So far I was able to do a detach / attach from RTM to SP3a and I have not
> > seen any problems yet? But I am not sure that will be the case with SP4.
> >
> > If I backup, copy, and attach a Database that was on the SQL2K RTM server
> > on
> > the server with SQL2K SP3a, can I just be copying the data from the RTM
> > server to the SP3a server? Does SP3a or SP4 do changes to a User Database
> > like modify tables? It makes changes to the Master tables, right? I
> > believe
> > the SPs change the Master tables, but I am not sure if it changes the
> > tables
> > or modify a Database that I create.
> >
> > Posted similar question on: SQL Server Group.
> > Thanks in advance for your .
> > :-)
> >
>
>
>

Does the build have to be the same for both, a move or a copy of just the
user database I created? I am not talking about the "copy database wizard".
-thanks.


"bass_player [SBS-MVP]" wrote:

> For SQL Server 2000, the two instances should have the same build number for
> this to be successful, such as, if the source instance has 8.0.2191, the
> destination instance should also be the same
>
>
> "Russell Fields" <russellfields@nomail.com> wrote in message
> news:ujU9LwXvHHA.4348@TK2MSFTNGP06.phx.gbl...
> > Dave,
> >
> > There should be no problem copying a SQL Server 2000 database from RTM to
> > SP3a or SP4.
> >
> > The SQL 2000 SPs do not change user databases, though SP4 does change
> > master, model, and msdb.
> >
> > You should be able to move forward without any problems. Of course, you
> > can always test one database out and build up your confidence that way,
> > prior to making the big jump.
> >
> > RLF
> >
> >
> > "Dave" <Dave@discussions.microsoft.com> wrote in message
> > news:897685E5-B7E4-47D0-824C-CACC8C64405C@microsoft.com...
> >> Can I copy Databases from a server with SQL Server 2000 (RTM) to another
> >> server with SQL Server 2000 (SP3a) without corruptions or problems? What
> >> about from SQL2K RTM to SQL2K SP4? I need to upgrade to SP4 because one
> >> application is requiring SP4 before we can upgrade to the new version.
> >> So far I was able to do a detach / attach from RTM to SP3a and I have not
> >> seen any problems yet? But I am not sure that will be the case with SP4.
> >>
> >> If I backup, copy, and attach a Database that was on the SQL2K RTM server
> >> on
> >> the server with SQL2K SP3a, can I just be copying the data from the RTM
> >> server to the SP3a server? Does SP3a or SP4 do changes to a User
> >> Database
> >> like modify tables? It makes changes to the Master tables, right? I
> >> believe
> >> the SPs change the Master tables, but I am not sure if it changes the
> >> tables
> >> or modify a Database that I create.
> >>
> >> Posted similar question on: SQL Server Group.
> >> Thanks in advance for your .
> >> :-)
> >>
> >
> >
>
>
>

The general rules for moving user databases are as follows:

Any copy method (Backup-restore, detach-attach) is valid within a major
version (2000, 2005, 2008, etc)

Any copy method is valid from a major version to a later major version.
(I.E. Backup on SQL 2000, restore on 2005). There may be limits on how many
versions you can "jump" in the future. The attach process does any
necessary upgrades. So far, I have observed that the upgrade time is
independent of the size of the databases and is roughly constant on a given
hardware platform.

System databases must be from the exact same build version to do a backup
and restore.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Dave" <Dave@discussions.microsoft.com> wrote in message
news:897685E5-B7E4-47D0-824C-CACC8C64405C@microsoft.com...
> Can I copy Databases from a server with SQL Server 2000 (RTM) to another
> server with SQL Server 2000 (SP3a) without corruptions or problems? What
> about from SQL2K RTM to SQL2K SP4? I need to upgrade to SP4 because one
> application is requiring SP4 before we can upgrade to the new version.
> So far I was able to do a detach / attach from RTM to SP3a and I have not
> seen any problems yet? But I am not sure that will be the case with SP4.
>
> If I backup, copy, and attach a Database that was on the SQL2K RTM server
> on
> the server with SQL2K SP3a, can I just be copying the data from the RTM
> server to the SP3a server? Does SP3a or SP4 do changes to a User Database
> like modify tables? It makes changes to the Master tables, right? I
> believe
> the SPs change the Master tables, but I am not sure if it changes the
> tables
> or modify a Database that I create.
>
> Posted similar question on: SQL Server Group.
> Thanks in advance for your .
> :-)
>