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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dinesh T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 04/19/04 

Date: Tue, 20 Apr 2004 01:45:20 +0530

Jake,

In enterprise manager, right click on any database |All tasks|generate sql
script.In the 'options' tab, there is the facility to script database users
and server logins. 

--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Jake" <rondican@hotmail.com> wrote in message
news:OtjPv1#IEHA.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: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)