Re: Backup Question
- From: "jamrock" <news_jamrock@xxxxxxxxx>
- Date: Thu, 27 Oct 2005 22:45:14 -0500
Make sure the SQL Server Agent service is running. Database Maintenance
Plans are managed by that service.
"Jasper Smith" <jasper_smith9@xxxxxxxxxxx> wrote in message
news:uYmtvE02FHA.2268@xxxxxxxxxxxxxxxxxxxxxxx
> You can create a Maintenance Plan to do this. In Enterprise Manager goto
> Management>Database Maintenance Plans, right click and choose New
> Maintenance Plan. You can then step through the wizard and select the
> options you want including which databases to backup and when. Jobs are
> automatically created for you depending on your selections
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Daren Hawes" <newsgroups@xxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:ORCRhzz2FHA.1416@xxxxxxxxxxxxxxxxxxxxxxx
> > Hi,
> > Is there any way I can use the Backup Features of Enterprise manager to
> > backup ALL databases on my SQL Server at once without going thru each
> > database? I also wish to schedule this.
> >
> > Thx
> >
>
>
.
- References:
- Backup Question
- From: Daren Hawes
- Backup Question
- Prev by Date: Re: Failed connections to remote 2k SQL Server
- Next by Date: Re: Failed connections to remote 2k SQL Server
- Previous by thread: Backup Question
- Next by thread: Re: Failed connections to remote 2k SQL Server
- Index(es):
Relevant Pages
|
Loading
