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 |
|
psangeetha
Yak Posting Veteran
95 Posts |
 Posted - 2008-02-27 : 16:24:46
|
| Hi all, This is my first message in this forum and I am a new bie to SQL server 2005.. I am trying to schedule the backup job for a database in 2005 and I am not able to figure out where it is. I browsed through few topics in the forums and found that I can do using sql server agent in the SQL server management studio. But I do not see the sql server agent in the management studio. Any help is appreciated. Thanks all! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-27 : 16:27:19
|
| Coz you don't have sysadmin rights? |
 |
|
|
psangeetha
Yak Posting Veteran
95 Posts |
Posted - 2008-02-27 : 16:32:38
|
| I dont quite understand where I should have sysadmin rights??At the database level?? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-27 : 16:34:27
|
| What rights do you have in server level and database level? |
|
|
|
psangeetha
Yak Posting Veteran
95 Posts |
Posted - 2008-02-27 : 16:58:55
|
| I figured that out! I was actually using the mgmt studio from my machine to schedule the backup. My mistake! Thank you for giving me a clue on that! |
|
|
|
psangeetha
Yak Posting Veteran
95 Posts |
Posted - 2008-02-29 : 15:59:49
|
| Hi all, I have been very unsuccessful scheduling a backup using sql management studio in 2005. I looked up on all documents and found one possible way of scheduling using ‘script action to job’. But then when I schedule the backup job to run everyday at 7pm and click OK, it just executes the backup job right away and throws the backup in the destination I mentioned. It doesn’t backup the database everyday as scheduled, it just executes one time when I am scheduling. Any clue on this??? Thanks a lot! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 21:07:16
|
| Check under tasks and ensure db backup job is there. |
|
|
|
|
|
|
SQL server Agent missing in 2005