About this task
Perform this backup process on a daily basis. Frequency depends upon the client RPO.
This topic is not applicable for vSphere 6.5.
Before you begin
•
Confirm that the Microsoft SQL server
sa
log on is enabled and a password is set for the
account.
•
Ensure the server authentication mode is set to the SQL Server and Windows Authentication
mode.
•
Obtain administrator log on credentials.
•
Obtain AMP jump server or AMP-2 element manager server network address.
•
Obtain VMware vCenter SQL server network address and SQL server log on credentials.
Procedure
1
Connect to the client AMP environment jump server.
2
From the jump server, use RDP to access the SQL database server, and log on as administrator.
3
To run the SQL Server Management Studio application, navigate to the application and select
Start
>
All Programs
>
Microsoft SQL Server 2012
>
SQL Server Management Studio
.
4
To log on to the application, perform the following:
a
In the
Server type
field, verify that
Database Engine
appears. If not, select it.
b
If the
Server name
field is not auto-filled, select
(local)
. If no matching account exists, log on
with administrator privileges.
c
In the
Authentication
field, verify that
Windows Authentication
appears. If not, select it,
and click
Connect
.
5
To confirm the list of databases that require backup, from the
Object Explorer
window, expand
Databases
>
System Databases
. The databases that require backup are in the
System
Databases
(
master
,
model
,
msdb
) and the
vcenter
and
vum
databases that appear after the
Database Snapshots
folder. Depending on the naming standard that has been followed (client or
Dell EMC), they should appear as
xmgmtvcenter
and
xmgmtvum
, where
x
is a unique identifier.
The
tempdb
database should be excluded from the backup process creation tasks.
6
Navigate to and expand
SQL Server Agent
>
Jobs
.
7
To create a backup job, right-click
Jobs
and select
New Job.
a
From the
New Job
window, in the
Name
field, type a value to correspond with the backup to
be performed.
b
In the
Owner
field, remove the default log on and type
sa
.
c
Change the
Category
field to
Database Maintenance
.
Guidelines for backing up configuration files
|
150
Содержание Vblock Systems 350
Страница 1: ...Dell EMC VxBlock and Vblock Systems 350 Administration Guide Document revision 1 8 October 2017 ...
Страница 114: ...Related information VMware vSphere Networking guide Managing VMware VDS 114 ...
Страница 122: ...Related information Cisco Nexus 1000V Troubleshooting Guide Managing the Cisco Nexus 1000V Series Switch 122 ...
Страница 156: ...4 On the Schedule tab schedule the task to run daily at 1 00 AM Backing up Cisco MDS switches 156 ...