going to get ready isn't as we were going to learn how to create backup
0:02
maintenance plan in sequel to route using
0:05
management secret every Management Studio so here's my server
0:08
right here is my sequencer tech brothers and seek with a rip Ron is
0:13
sequel prod is me instance so in order to create
0:17
a backup maintenance plan you need to click on management
0:20
and go to the maintenance plan if you have already made in his plan there
0:25
would be a plus sign here and you can go ahead and beauty me to explain
0:28
since we don't have high maintenance plans will plan
0:32
we're going to go hand in hand right click on the maintenance and click on
0:36
new clean we need to name the plan
0:39
children and will head back up underscore all DB
0:43
so this is our maintenance plan since his maiden
0:46
plan is going to be backing up all the databases
0:50
including system databases and user databases
0:53
children go ahead and click okay as you can see right here
0:58
arm this is the maintenance plan and theirs is so plain appear
1:03
wouldn't go ahead and click on toolbox
1:06
appear if it doesn't appear the tool box than the pure you can click on View
1:10
and click on toolbox rate here and it will bring the tool box
1:14
right there so right now it's our on hide
1:17
I don't hide so you don't have to quicken I'm on hiding
1:21
click on this little I don't hide button and then it will
1:24
go ahead and stay on their so we're gonna go ahead
1:27
in this video on wooden going to do backup database task
1:32
to gonna go in and dragnet to this space
1:35
well as you drag the backup database task
1:41
in this space right here and you can see right here the X button
1:44
that means that this backup task is not configured
1:48
so we created them maintenance plan
1:51
and now we got back up database task from the toolbox
1:55
we're going to go ahead and configure this backup database task months is
2:00
configured
2:01
you will see you you will see that in this Exmark is gone
2:05
and it is converging into green that means is
2:08
ready to be used gonna go ahead and configure it
2:12
in order to configure it you need to double click on them backup database
2:15
task
2:16
and ill appear all good
2:19
i sending it'll show in this little window backup database task
2:24
so connection up here is our local connection general information is bad
2:28
what kind of backup that you're going to create this plan for
2:32
we you have a full backup differential backup and
2:35
long backup in this video were going to do fullback
2:38
so ima go ahead and click on that and up here we have a selection of DA bass
2:43
now if you click on the selection you get following selection
2:47
all databases movie the system databases which is master model
2:51
arm and msdb and
2:54
all other all user data bases this will exclude master model msdb
3:00
and 10 DB but also you have an option
3:03
if you wanna just specific databases you don't want all user data bases you don't
3:07
want system utilises you don't mind
3:10
appear this option you can go ahead and select
3:13
when databases that you wanted to backup in this
3:16
maintenance plan so we're going to go ahead and click on
3:20
all databases since this video is about backing up on your data bases on a
3:24
particular sequence for instance
3:26
wanna go ahead and click on on databases keep in mind this is very important
3:31
ignore databases word state is not online
3:35
if you need a basic is of mine and you have not clint done this year
3:38
maintenance plan is going to fail
3:40
so keep in mind that if you have backup
3:44
up here the database No
3:46
offline any database that is of in in your database list
3:50
you need to quit this options so that will go ahead and ignore
3:54
and not create an air in your big backup maintenance plan still gonna go ahead
3:58
and click all the bases I don't have any database that is
4:01
are playing so I it doesn't really matter to me but I'm going to click it
4:05
anyway
4:06
wanna go ahead click OK now appeared
4:10
back up to we have two options in Siebel Server 2012 2014
4:15
there are two options disc an URL URL
4:18
involved here are as your storage so we're not gonna cover in this video
4:23
will put another BTU to back up to a URL
4:27
using as your account but right here you have a disk
4:30
tape an URL we're going to you in this video
4:34
onto back back up all these databases on the desk
4:37
so were good with that quick on destination
4:40
up here if you wanted to create
4:43
some bacteria each database and once in subdirectories created all the division
4:49
will go
4:50
and create database directory such as Master
4:53
will call you using database and it will print
4:57
in this farming location you have an option right here if you wanted to
5:01
put it somewhere else are you can quick on right here
5:04
and change the pack are here idea BC
5:07
this is the bat that where you de beers is going to be so if you wanted to
5:11
create a backup
5:12
who for every database in create a subdirectory you can click back
5:16
I'm not going to create a subdirectory I'm okay with arm
5:20
in databases that you know just so the in mean
5:24
folder not some don't. sometimes is a good option to create a subdirectory
5:28
because so
5:29
arm it'll mmm in may get more manageable
5:32
or anybody in BB to do that
5:36
so back extension is baka rate here
5:39
through let look at the options for a few options are just like a on
5:45
manually creating the database we have a good compression if you wanna do you do
5:49
seek whatever default compression that's fine if you don't mind compression
5:53
you have an option not to select the compression
5:56
again I wanted to quickly mention that a mean
5:59
you databases compressed and from 100 get to it soon
6:03
backup is 40 gig that doesn't mean that it's going to
6:06
aunty less time to the store is going to take this team
6:09
time on as 100 getting these so
6:13
you have option backup said will expire you have option in days
6:17
in and and I'll also that date ophelie
6:21
a backup usually we on in in normal maintenance plan we don't do that this
6:26
is some
6:26
yeah at heart if you want to do the copy only backup in very by a backup
6:31
integrity
6:31
sometimes is a good option to do it in production but didn't even mind if you
6:35
click on there by backup integrity is going to take
6:38
sometime to in order to complete your backup task
6:41
if you want to do do the backup encryption you can
6:45
select that if you're sending your backup off-site
6:48
somewhere on to up vendor were even Microsoft you would like to encrypt your
6:53
data base
6:54
back up so that when it goes over the network
6:58
it will be hacked so you have back option
7:01
and were ready to quick okay
7:04
and create maintenance plans from plan month this maintenance plan he's created
7:09
it is going to create
7:10
a job for us in sequel to bring agent
7:13
so we're gonna go ahead and click OK and as you can see that
7:17
lil X button is gone and here's some
7:21
options that did is maintenance plan is going to run as
7:25
sequel to agree agent service account which is right here
7:28
so you need to make sure did agent account
7:31
there account to get you using you have an option to change that
7:35
ago
7:36
account great here if that account is changed or even the sequence number
7:40
agent you need to make sure that backed
7:42
particular account has a write permission when you're storing your
7:45
database backups if Jackson if nasa
7:48
not the case then you're going to run into
7:51
issue of permission issue that it cannot right to the popular
7:55
on nice to you want to add you backups
7:58
so we're gonna go ahead and keep in mind is very important to theme
8:02
on once you click on save gas money is going to create
8:06
she was a region job gonna go ahead and say well
8:09
alright our maintenance plan is saved and in this maintenance plan
8:14
we have configured full backup all
8:17
all the databases on her sequence ever insist so let's
8:21
quote this and
8:24
take a look on sequestering agent
8:27
as you can see rate here is our backup and restore all
8:32
job is created so you can go ahead in Manali
8:35
run this job or you can also execute your
8:39
maintenance plan if you the pressured who
8:42
get an option right here you can execute you maintenance plan what
8:47
Mac behind-the-scene it'll do didn't pick up the job on
8:50
secret every agent to include from the jobs right here you can go ahead and
8:57
start the job
8:58
so basically this is how you create I'm full backup maintenance plan
9:02
and go through some options I hope
9:05
this video