This topic describes how to create a full database backup in SQL Server 2017 using SQL Server Management Studio
Full back up to disk to default location
In this example, the
SQLTestDB database will be backed up to disk at the default backup location. A backup of
SQLTestDB has never been taken.
- In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.
- Expand Databases, right-click
SQLTestDB, point to Tasks, and then click Back Up….
- Select OK.
Another method to export data from Remote server to local server using SQL server