Backup of once database

[GREGD]

I create a resource group with 2 server sql i selected thr whole instance.
So i chech i can restore once database from instance.
But when i want to create manually backup of one database i cannot do it there is only backup of whole resource group so i have backup of both servers.
Its this not possible because i use resourcefgroups?
Or how can i do manually backup of one database?

[mrahul]

Hi  GREGD,

   When you create a resource group, backup is taken at the resource group level. Backup happens for the resources grouped, irrespective of whether you had selected the whole SQL instance or selected multiple individual DBs while creating the resource group.

If your intention is to backup a single SQL DB, then you will need to protect the SQL DB individually. 

[GREGD]

What happend in this examples

i habe a resource group with server 1 server 2

i login on server 1 open task scheduler and start the scheduler for full.

Will automaticly take a backup of db on server 2?

Yes i allready found out that i can create a backup of single db

i crate my a new policy without scheduler

and under

resources\ view instance

can i  click the instance and den protect. so i can create a backup with before create policy. and i dont give the scheduler to the policy

or resources \view database

click on database and then protect. and create a backup job without scheduler.

i think this is the right way.

[mrahul · Accepted solution]

There are two ways to protect resources in SnapCenter. One is protecting via 'Resource Group' creation or the implicit way by just selecting the instance or individual DB and click on protect.

Depend on user choice on how they want to go about. Resource group creation is a way for the customer to group resources the way he wants based on critical workloads, scheduling needs etc...

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.