Wednesday, March 7, 2012

Can I use SQL server 2005 manager to schedule backups?

Can I use SQL server 2005 manager to schedule backups?
Any documents for that?
Thanks in advance.Sean wrote:
> Can I use SQL server 2005 manager to schedule backups?
> Any documents for that?
> Thanks in advance.
Create a SQL Agent job that executes the BACKUP command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi,
You could also use the Maintenance plans from SQL Server Management studio
to configure the database backup. The wizard itself will guide you to steps
to setup the backup job.
Thanks
Hari
SQL Server MVP
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:F1DC9D76-2519-42A4-807A-1D788D9B8A3F@.microsoft.com...
> Can I use SQL server 2005 manager to schedule backups?
> Any documents for that?
> Thanks in advance.

No comments:

Post a Comment