Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2007-02-20 : 08:29:53
|
| using sql server management studio -- how can I schedule a backup to automatically take place every day? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-20 : 08:32:31
|
| You can do it by creating new Maintainance plan for the database.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-02-20 : 12:10:15
|
| where? |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-02-20 : 12:17:38
|
| SSMS, right click on maintenance plans and create a new plan.The type of plan is "Database Maintenance Plan" you have to select "Backup Database Task" it is fairly simple, even a DBA can do it.... |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-02-20 : 13:34:36
|
| sorry for my lack of knowledge but what is SSMS and where do i find it. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-02-20 : 14:22:35
|
| found it -- thanks |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-02-20 : 14:25:02
|
| anyway for it to backup to a remote location using ftp? |
|
|
|
|
|
|
scheduling backup