scheduled backups

I am wondering how to do a scheduled database backup with sql server
2005. If this could be done through ssms it would be best. ThanksLook into Maintenance Plans - under Management.
On Fri, 28 Dec 2007 10:03:33 -0800 (PST), mmark751969@.yahoo.com wrote:

>I am wondering how to do a scheduled database backup with sql server
>2005. If this could be done through ssms it would be best. Thanks|||You did not mention your SQL Server 2005' s Edition. If it's Express
Edition, then you can use SQLCMD + a T-SQL Script file and Windows Task
Scheduler to schedule a job...
If it's Standard, Developer, Enterprise Edition, then you can use Jobs under
SQL Server Agent or Maintanence Plans as Brett already mentioned.
Ekrem nsoy
<mmark751969@.yahoo.com> wrote in message
news:609aa56b-30e1-45de-96e8-919104137f8a@.i12g2000prf.googlegroups.com...
>I am wondering how to do a scheduled database backup with sql server
> 2005. If this could be done through ssms it would be best. Thanks

scheduled backups

I am wondering how to do a scheduled database backup with sql server
2005. If this could be done through ssms it would be best. ThanksYou did not mention your SQL Server 2005' s Edition. If it's Express
Edition, then you can use SQLCMD + a T-SQL Script file and Windows Task
Scheduler to schedule a job...
If it's Standard, Developer, Enterprise Edition, then you can use Jobs under
SQL Server Agent or Maintanence Plans as Brett already mentioned.
--
Ekrem Önsoy
<mmark751969@.yahoo.com> wrote in message
news:609aa56b-30e1-45de-96e8-919104137f8a@.i12g2000prf.googlegroups.com...
>I am wondering how to do a scheduled database backup with sql server
> 2005. If this could be done through ssms it would be best. Thanks