New Hardware

I have found a couple of web sites that discuss moving a sql server and its
database from one machine to another but nothing in good detail.
I have also looked out on the Knowledgebase and have found nothing as of
yet. I know there has to be some articles on this.
Anybody have a link to one?
--
Paul BergsonIn your Knowledge Base search you missed:
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
Jacco Schalkwijk
SQL Server MVP
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
>I have found a couple of web sites that discuss moving a sql server and its
> database from one machine to another but nothing in good detail.
> I have also looked out on the Knowledgebase and have found nothing as of
> yet. I know there has to be some articles on this.
> Anybody have a link to one?
> --
> Paul Bergson
>
>|||Actually this isn't what I need this is to move individual db's not the
entire system. It is required that I move all the system db's as well.
--
Paul Bergson
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...
> In your Knowledge Base search you missed:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
> >I have found a couple of web sites that discuss moving a sql server and
its
> > database from one machine to another but nothing in good detail.
> >
> > I have also looked out on the Knowledgebase and have found nothing as of
> > yet. I know there has to be some articles on this.
> >
> > Anybody have a link to one?
> >
> > --
> >
> > Paul Bergson
> >
> >
> >
>|||Please clarify...
moving a few user databases OR all the databases (system and user)?
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --|||1. backup your DBs on first server
2. restore your DBs on second server
3. on second server create user accounts that you wanted to transferred from
first server to second server
4. in each DB run sp_change_users_login 'Update_One' to map each database
user (select * from sysusers) to the new accts you just created in step 3.
You can write a cursor to run dynamically.
hth,
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --
> Paul Bergson
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid>
> wrote
> in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...
>> In your Knowledge Base search you missed:
>> HOW TO: Move Databases Between Computers That Are Running SQL Server
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
>>
>> --
>> Jacco Schalkwijk
>> SQL Server MVP
>>
>> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
>> news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
>> >I have found a couple of web sites that discuss moving a sql server and
> its
>> > database from one machine to another but nothing in good detail.
>> >
>> > I have also looked out on the Knowledgebase and have found nothing as
>> > of
>> > yet. I know there has to be some articles on this.
>> >
>> > Anybody have a link to one?
>> >
>> > --
>> >
>> > Paul Bergson
>> >
>> >
>> >
>>
>|||Go to google groups and search this NG for "move system database". IIRC,
Andrew Kelly has posted a rather complete list of links that cover this
frequently asked topic.
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> Actually this isn't what I need this is to move individual db's not the
> entire system. It is required that I move all the system db's as well.
> --
> Paul Bergson
>
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid>
wrote
> in message news:e3TqbC0SFHA.3184@.TK2MSFTNGP15.phx.gbl...
> > In your Knowledge Base search you missed:
> >
> > HOW TO: Move Databases Between Computers That Are Running SQL Server
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
> >
> >
> > --
> > Jacco Schalkwijk
> > SQL Server MVP
> >
> >
> > "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> > news:ueLrT3zSFHA.2128@.TK2MSFTNGP15.phx.gbl...
> > >I have found a couple of web sites that discuss moving a sql server and
> its
> > > database from one machine to another but nothing in good detail.
> > >
> > > I have also looked out on the Knowledgebase and have found nothing as
of
> > > yet. I know there has to be some articles on this.
> > >
> > > Anybody have a link to one?
> > >
> > > --
> > >
> > > Paul Bergson
> > >
> > >
> > >
> >
> >
>|||New hardware. Retiring the old sql server. I need to move everything...
--
Paul Bergson
"CD" <mcdye1@.hotmail.REMOVETHIS.com> wrote in message
news:#Nr$t#0SFHA.3636@.TK2MSFTNGP14.phx.gbl...
> Please clarify...
> moving a few user databases OR all the databases (system and user)?
>
> "Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
> news:u8PWyq0SFHA.3684@.TK2MSFTNGP10.phx.gbl...
> > Actually this isn't what I need this is to move individual db's not the
> > entire system. It is required that I move all the system db's as well.
> >
> > --
>