Re: Coping everything to New Server

From: Don (Don_at_discussions.microsoft.com)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 11:20:01 -0700

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
> >
> >
>
>
>

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.server)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.programming)
  • Re: "Best Practices" way to distribute MSDE
    ... > Restore a users's selected backup. ... for dayly house-keeping I do usually provide scripted job for database ... that file copy operation (not SQL Server backup!) can be performed.. ... my personala advice is to perform dayly house-keeping actions ...
    (microsoft.public.sqlserver.msde)
  • Re: NT Backup Causes Server to Hang
    ... Thanks for using the SBS newsgroup. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
Loading