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 |
|
rammohan
Posting Yak Master
212 Posts |
 Posted - 2008-03-06 : 00:17:23
|
| hi,is it possible to get the back up of a particular database automatically at fixed interval of time i.e for every two days or two hours etc. i am sql server 2005 as back end of my project. please show me a way in sql express edition too along with sql sever edition.One can never consent to creep,when one feels an impulse to soarRAMMOHAN |
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-03-06 : 00:33:15
|
| In Express edition you will need to set up a Windows Schedule Job to issue the backup command via OSQL. In Standard edition you can set up a maintenance plan on a schedule that can do what you ask for.The reason you get the two answers is because I do not believe that the SQL Server Agent Service is supported in the Express Edition. I may be wrong, Search for Jobs in BOL to verify.Chris Shawwww.SQLonCall.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-06 : 22:29:32
|
| are correct, sql2k5 express doesn't have sql agent. |
|
|
|
|
|
|
regarding back up of a data base automatically