Re: Coping everything to New Server
From: Chieko Kuroda (ckuroda_at_unch.unc.edu)
Date: 06/11/04
- Previous message: Chieko Kuroda: "Re: Coping everything to New Server"
- In reply to: Don: "Re: Coping everything to New Server"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Jun 2004 14:56:49 -0400
Don,
the backup devices didn't get restored from the master db, maybe from the
msdb; I don't know.
I copied the backup folder from one machine to another.
Chieko
"Don" <Don@discussions.microsoft.com> wrote in message
news:4EF0E089-2658-40E4-B314-6E1F2FA64068@microsoft.com...
> Thanks Chieko,
>
> Where do the logins under the security section come from? Are these
brought in with the master or msdb database? Sames thing with the Backup
devices under
> the Management section.
>
> Don
>
>
> "Chieko Kuroda" wrote:
>
> > Hi,
> > I'm in the process of doing the same thing.
> > Remember that jobs are stored in the MSDB so you should backup and
restore
> > both the master DB and the MSDB.
> > That will get all of the stored procedures, jobs and linked servers from
the
> > original sql server.
> > You can determine all of the jobs that are in the agent by running:
> > USE msdb
> > EXEC sp_help_job
> > in the query analyzer.
> > If at all possible keep the old server, and check that everything is
working
> > correctly before you wipe it out.
> > I've got lot's of problems because the person helping me was in a hurry
to
> > finish.
> > Don't be in a hurry what ever you do.
> > Chieko
> >
> > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> > news:OlTgHW0TEHA.2324@TK2MSFTNGP10.phx.gbl...
> > > Have a look here:
> > >
> > >
> > > http://www.support.microsoft.com/?id=314546 Moving DB's between
> > Servers
> > > http://www.support.microsoft.com/?id=224071 Moving SQL Server
> > Databases
> > > to a New Location with Detach/Attach
> > > http://support.microsoft.com/?id=221465 Using WITH MOVE in
a
> > > Restore
> > > http://www.databasejournal.com/features/mssql/article.php/2228611
> > > Transferring Logins
> > > http://www.support.microsoft.com/?id=246133 How To Transfer Logins
and
> > > Passwords Between SQL Servers
> > > http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs
after
> > a
> > > Restore
> > > http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins
to
> > > users
> > > http://www.support.microsoft.com/?id=168001 User Logon and/or
> > Permission
> > > Errors After Restoring Dump
> > > http://www.support.microsoft.com/?id=240872 How to Resolve
Permission
> > > Issues When a Database Is Moved Between SQL Servers
> > > http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
> > > Restoring a .mdf
> > > http://www.support.microsoft.com/?id=307775 Disaster Recovery
Articles
> > > for SQL Server
> > >
> > > http://www.support.microsoft.com/?id=274463
Copy
> > DB
> > > Wizard issues
> > >
> > > --
> > >
> > > Andrew J. Kelly
> > > SQL Server MVP
> > >
> > >
> > > "Don" <Don@discussions.microsoft.com> wrote in message
> > > news:FC92BAD2-13DD-4460-B6BC-D9EB148EEC9B@microsoft.com...
> > > > I'm building a new SQL Server 2000 box and want to move all my
> > > objects(mulitple database, DTS packages, logins, Jobs, backup
locations,
> > > etc...) from the existing SQL Server 2000 box. What's the easiest way
to
> > do
> > > this? I see that SQL Server has a copy database wizard but I'm not
sure
> > > this will bring everything over.
> > > >
> > > > Thanks
> > >
> > >
> >
> >
> >
- Previous message: Chieko Kuroda: "Re: Coping everything to New Server"
- In reply to: Don: "Re: Coping everything to New Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
