Скачать или смотреть Create a Full Database Backup of Microsoft SQL Server 2008 R2 Management Studio 2021

Create a Full Database Backup of Microsoft SQL Server 2008 R2 Management Studio 2021

1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, expand the server tree.

2. Expand Databases, and either select a user database or expand System Databases and select a system database.

3. Right-click the database that you wish to backup, point to Tasks, and then click Back Up....

4.In the Back Up Database dialog box, the database that you selected appears in the drop-down list (which you can change to any other database on the server).

5. In the Backup type drop-down list, select the desired backup type - the default is Full.

( Important
You must perform at least one full database backup before you can perform a differential or a transaction log backup.)

6. Under Backup component, select Database.

7. In the Destination section, review the default location for the backup file (in the ../mssql/data folder).

-To backup to a different device, change the selection using the Back up to drop-down list. To stripe the backup set across multiple files for increased backup speed, click Add to add additional backup objects and/or destinations.

-To remove a backup destination, select it and click Remove. To view the contents of an existing backup destination, select it and click Contents.

8. Click OK to initiate the backup.

9. When the backup completes successfully, click OK to close the SQL Server Management Studio dialog box.


If you like the video
Please like, comment and share.

And don't forget to subscribe
---------------------------------------------------------------------------------------------------------
YouTube Channel: :- 🔻
   / @techvalleyjh  

Social Link: :- 🔻
  / jewel.hossain.9883  

--------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------

Intro Credit :- 🔻
1. http://www.topfreeintro.com/best-no-t...
2. http://www.topfreeintro.com/best-no-t...
---------------------------------------------------------------------------------------------------------