| Author |
Topic |
|
wajeeha20
Starting Member
13 Posts |
 Posted - 2011-09-08 : 07:01:29
|
| hello, what i wonder is that im gonna take full recovery backup of some databases, but i want theese backup on tomorrow. how can i select the backup time and day in sql server managment studio 2008?? how and where can i select the time and day for backups?? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-08 : 07:23:07
|
| Schedule it with SQL Agent |
 |
|
|
wajeeha20
Starting Member
13 Posts |
Posted - 2011-09-08 : 07:36:46
|
| how? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-08 : 07:43:41
|
| like this |
|
|
|
wajeeha20
Starting Member
13 Posts |
Posted - 2011-09-08 : 07:51:17
|
| i know how to create job and other things. but i dont know is how to put a backup plan in a job or agent? shall i first make a job with backup? and than schedule it? ohhh im new in job and its really tuff:( |
|
|
|
wajeeha20
Starting Member
13 Posts |
Posted - 2011-09-08 : 07:54:51
|
| when i create new job, i got a option in "new job step" pane, that i have to choose one "type". what kind of type can i choose for a backup?? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-08 : 07:56:43
|
| lol. yes, create your backup script (or maintenance plan) then create a SQL Agent job to execute it at whatever schedule/interval you want.I don't use maintenance plans (I write my own backup jobs), but they are nice and easy when you're new to much of this. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-08 : 07:58:13
|
| T-SQL Command if you;re running a BACKUP command. |
|
|
|
wajeeha20
Starting Member
13 Posts |
Posted - 2011-09-08 : 08:19:05
|
| okey i got it. i used job and schedule. and it worked. but what if i have to backup up 14 databases, do i have to create a job for each database? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-08 : 08:47:47
|
| You can run multiple backups in the same step, or create a job step for each db. I would not create a seperate job for each, but you can. You'll end up with a lot of jobs eventually just for backups if you do that. |
|
|
|
wajeeha20
Starting Member
13 Posts |
Posted - 2011-09-09 : 05:59:52
|
| i made a maintanence plan for backups, chilll;) |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-09-09 : 08:11:29
|
| Ey...a fellow norwegian...welcome :D- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
wajeeha20
Starting Member
13 Posts |
Posted - 2011-09-12 : 08:55:12
|
| heyyy thanksssss:) :) |
|
|
|
|
backup for many databases