Hands-on Assignment 7
docx
keyboard_arrow_up
School
SSAT Degree College *
*We aren’t endorsed by this school
Course
1
Subject
Information Systems
Date
Nov 24, 2024
Type
docx
Pages
4
Uploaded by CaptainFalconPerson690
1
Hands-on Assignment 7
Mahesh Gottipati
CS63170G322 - Advanced Database
Gulsebnem Bishop
December 3, 2022
2
Create a Full Database Backup
This week's training focused on backing up a SQL Server database utilizing SQL
Server Management Studio, Transact-SQL, as well as PowerShell. Keeping a full copy of a
database backup takes more time and storage as the data expands. Differential copies, and
also full backups, might be useful for protecting large databases. After establishing a
connection to the appropriate instance of an Microsoft SQL Server Database Engine, users
are free to utilise Object Explorer to further develop the server tree.
Select a system database or a user database by the expanding Databases or System
Databases, respectively. The backup process is as simple as right-clicking the database you
wish to save, selecting Tasks from the resulting menu, and finally selecting Back Up. In the
dialogue box's drop-down menu, select the database you'd want to back up. Select "Backup
type" and then a backup technique; "Full" will take you there by default. When asked what
"Backup Component" refers to, choose Database. In the Destination section, verify that the
backup file is located in the default directory (../mssql/data).
Using the corresponding pull-down menu, you may quickly and easily switch the
backup destination device. Select the Add button to add new things or places to your archive.
You may increase the speed of your backups by utilising the "stripping" approach to divide
the backup collection over many files. Click the Remove button once you have chosen the
backup location you would like to eliminate. Right-clicking a backup location as well as
selecting Contents will open up the files inside it for inspection. The backup will begin after
you click the OK button. When the backup is finished, the confirmation box will close
3
automatically, so you may close SQL Server Management Studio at this point.
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
4