|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > Moving SQL2K Server to a new server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Moving SQL2K Server to a new server
|
|
|
| Existing server is running sql2k w/ no service packs, just original install.
On the new box I'm moving to, if I install Sql2kSp2, can I just do a restore
of my tables, master, msdb, model, etc.??
I think the answer would be no, but I wanted to check.
Thanks,
Joe
| |
| Steve Thompson 2002-12-19, 2:23 pm |
| "Joe" <joenospam@nospam.com> wrote in message
news:jvoM9.1173$io.49923@iad-read.news.verio.net...
> Existing server is running sql2k w/ no service packs, just original
install.
> On the new box I'm moving to, if I install Sql2kSp2, can I just do a
restore
> of my tables, master, msdb, model, etc.??
>
> I think the answer would be no, but I wanted to check.
Why would you want to restore Master? You could certainly restore the other
databases...
Steve
| |
|
| Thanks Steve. So what you're saying (I think) is that the only db affected
by the service packs is master, and the actual operation of SQL Server
itself, it will have no bearing on older existing dbs?
Thanks,
Joe
"Steve Thompson" <stevethompson@nomail.please> wrote in message
news:#WhwJV5pCHA.856@TK2MSFTNGP12...
> "Joe" <joenospam@nospam.com> wrote in message
> news:jvoM9.1173$io.49923@iad-read.news.verio.net...
> > Existing server is running sql2k w/ no service packs, just original
> install.
> > On the new box I'm moving to, if I install Sql2kSp2, can I just do a
> restore
> > of my tables, master, msdb, model, etc.??
> >
> > I think the answer would be no, but I wanted to check.
>
> Why would you want to restore Master? You could certainly restore the
other
> databases...
>
> Steve
>
>
| |
| Steve Thompson 2002-12-20, 9:24 am |
| "Joe" <joenospam@nospam.com> wrote in message
news:r5qM9.1184$io.50275@iad-read.news.verio.net...
> So what you're saying (I think) is that the only db affected
> by the service packs is master, and the actual operation of SQL Server
> itself, it will have no bearing on older existing dbs?
Generally speaking, yes -- however, there are likely other server based
dll's and exe's that get changed along with internal changes to stored
procedures and extended stored procedures
..
The other way to think of it, it is usually possible to migrate your
databases to a more recent version, it's not always as easy to migrate to an
older version.
Once you have your new server running, it's better to restore (first
choice), or re-attach your databases. The proper entries get added to master
at that time.
Steve
|
|
|
|
|