Re: How to move schedule jobs from one box to another during upgrade
From: ch (ch_at_dontemailme.com)
Date: 06/04/04
- Next message: Julie: "Re: ldf file getting very large"
- Previous message: Dan Marth: "Re: Can't find NOT FOR REPLICATION option"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 04 Jun 2004 11:10:14 -0500
search microsoft.com for sp_help_revlogin.
that will script all logins on a server.
keeps the same passwords and sids for the logins.
Jake wrote:
>
> 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
> > >
> > >
> >
> >
- Next message: Julie: "Re: ldf file getting very large"
- Previous message: Dan Marth: "Re: Can't find NOT FOR REPLICATION option"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
