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 |
|
kerrycorcoran
Starting Member
38 Posts |
 Posted - 2008-01-28 : 14:57:43
|
| Was unsure where to place this post.Windows Server 2003R2 w/ Sp2MS SQL 2005I currently use MS SQL 2005 to host my Citrix Datastore DB. I manually run a daily back up (Tasks>Backup). How difficult would this be to automated? I have googled this without luck. Any insight appreciated. Thanks,Kerry |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-28 : 20:40:00
|
| You can schedule it as sql job, just click on script -> script action to job in backup page. |
 |
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-01-30 : 08:45:55
|
| I was able to automate the backup using a Maintenance Plan (wizard). Works great.Thanks,Kerry |
|
|
|
|
|
|
Automated Backup