ThejasviNarayanaPasupulety_Module8_HandsOn_Assignment

docx

School

Trine University *

*We aren’t endorsed by this school

Course

5003

Subject

Computer Science

Date

Nov 24, 2024

Type

docx

Pages

11

Uploaded by AmbassadorPencilRedPanda44

Report
Module 8 - Hands On – Assignment Thejasvi Narayana Pasupulety Campbellsville University Advanced Database (CS63171G123) Dr. Quiana Bradshaw
Module 8 - Hands On – Assignment Creating a full back up The first step is to initiate Microsoft SQL Server and establish a link to the specified database. Once a connection to the host has been established, the extended delectable Eats database may be accessed by right-clicking on it.
To initiate the backup process, go to the Tasks menu and choose the Backup option.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Select the "Full" option for the backup type and proceed by clicking the "OK" button.. Return to local directory successfully. Full disk backup to a non-default location Please be patient while we adjust the default backup destination immediately.
Select Delightful_eats from the enlarged databases and right-click. Select the tasks menu and hit return. To delete any existing backups, go to the "general" tab and choose "disk" from the
"destination" drop-down menu.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Select add option to show a dialogue box for destination
Creating an encrypted backup It creates a comprehensive backup in a non-default place. Please expand the databases and the System Databases node to perform the desired action. Following this, proceed to right-click on the controller node. Please choose a new query to initiate a fresh query window that establishes a connection to the Delightful_eats
database and execute the code inside that window. After right-clicking Delightful Eats, hit back. Start a new media set by overwriting the media section and selecting "back up." After that, delete all media sets.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
. To enable encryption for your backups, please go to the page displaying your backup choices and choose the "Encrypt Backup" feature. Choosing the Advanced Encryption Standard (AES) with a critical size of 256 bits is recommended for encryption purposes. Please choose my certificate as the intended recipient for either the asymmetric key or the certificate.
Hit ok. Done.