|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > Backup JOBS maintenance plans etc...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Backup JOBS maintenance plans etc...
|
|
| Jean Paul AT opelwilly 2002-08-07, 7:23 am |
| Hello,
Can someone tell me how to backup jobs, maintenance plans etc in SQL 7.0 to
migrate and restore in SQL 2000
Sincerely
Jean Paul
| |
| Kresimir Radosevic 2002-08-07, 7:23 am |
| Job definitions are stored at msdb database, but don't you have option to
generate sql script when you right click on jobs in em?
Regards
Kresimir Radosevic
"Jean Paul AT opelwilly" <jean.paul@NO.opelwilly.SP.com.AW> wrote in message
news:air48b$1cbva$1@sinclair.be.wanadoo.com...
> Hello,
>
> Can someone tell me how to backup jobs, maintenance plans etc in SQL 7.0
to
> migrate and restore in SQL 2000
>
> Sincerely
>
> Jean Paul
>
>
| |
| Jean Paul AT opelwilly 2002-08-07, 8:23 am |
| Thanks Kresimir,
Yes but how can that help me on, how can I generate the jobs in my SQL 2000.
What to do with the maintenance Plans they can't be converted to scripts
JP
"Kresimir Radosevic" <kresimir.radosevic@zg.tel.hr> schreef in bericht
news:uhEDhLhPCHA.1296@tkmsftngp09...
> Job definitions are stored at msdb database, but don't you have option to
> generate sql script when you right click on jobs in em?
>
> Regards
> Kresimir Radosevic
>
> "Jean Paul AT opelwilly" <jean.paul@NO.opelwilly.SP.com.AW> wrote in
message
> news:air48b$1cbva$1@sinclair.be.wanadoo.com...
> > Hello,
> >
> > Can someone tell me how to backup jobs, maintenance plans etc in SQL 7.0
> to
> > migrate and restore in SQL 2000
> >
> > Sincerely
> >
> > Jean Paul
> >
> >
>
>
|
|
|
|
|