Re: How to move schedule jobs from one box to another during upgrade

From: Wayne Snyder (wsnyder_at_computeredservices.com)
Date: 04/18/04 

Date: Sun, 18 Apr 2004 08:35:29 -0400

User information is stored in each database, so when you restore the databse
you get the user information .... Only the login might be missing. Another
possibility ( for SQL logins which are NOT NT logins) is that the new SQL
login may not match up to the OLD User...

Take a look at the stored procedure sp_change_users_login....

For additional information about moving logins, you might search Books on
line for Log Shipping. To make one of the shipped databases the primary,
logins must be moved, the docs show each step in doing that... 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jake" <rondican@hotmail.com> wrote in message
news:OtjPv1%23IEHA.2556@TK2MSFTNGP10.phx.gbl...
> Dinesh,
>
>     Is there a way to generate scripts for the users under the login of
> security?
>
> Jake
>
> "Dinesh T.K" <tkdinesh@nospam.mail.tkdinesh.com> wrote in message
> news:uzJawX%23IEHA.3968@TK2MSFTNGP12.phx.gbl...
> > Jake,
> >
> > sql jobs as well as DTS packages are stored in the msdb database.If you
> > restore msdb database backup, you can get all those jobs in the new
> > box.Also, its possible to script sql jobs(In enterprise manager |
> management
> > |sql server agent, right click on jobs |all tasks|generate sql script).
> >
> > --
> > Dinesh
> > SQL Server MVP
> > --
> > --
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Jake" <rondican@hotmail.com> wrote in message
> > news:ed08VQ#IEHA.2300@tk2msftngp13.phx.gbl...
> > > Hello,
> > >
> > >     We are currently upgrading our sql server. I have created a new
> > instance
> > > on another box. I am currently importing all of the databases to the
new
> > > box. How can I get the scheduled jobs and move them over to the new
box?
> > The
> > > new server has a new instance name. Also how can I move over all of
the
> > > users rights? Thanks in advance.
> > >
> > > Jake
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Problem with SQL Server 2005 Express Edition
    ... Use of included script samples are subject to the terms specified at ... One cause for that error is trying to use a SQL Server login on a database server that is configured to only accept Windows logins. ...
    (microsoft.public.sqlserver.security)
  • Re: Help Ive been an idiot
    ... You need to make sure that you readd any logins that were mapped to database ... Jasper Smith (SQL Server MVP) ... > connectionString, CommandType commandType, String commandText, ...
    (microsoft.public.sqlserver.setup)
  • Re: Master database must never be the default database for any login
    ... let's say that I want TEMPDB as my default database for all logins ... Is it possible I configure SQL Server to set a default database other ... MASTER to any logins created automatically? ...
    (microsoft.public.sqlserver.security)
  • Re: Managing SQL database rights using AD
    ... logins to SQL Server. ... You would add these two logins you ... just added as users in the database. ... the Windows group that you just added as logins (and then ...
    (microsoft.public.sqlserver.security)
  • Re: Resynching DB Users after Restore
    ... accidental security breach due to a cross-server restore. ... this semi-automagically, especially if you have a small, known set of logins ... Senior Database Administrator ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.security)