Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

0

0
Avatar
--Genio--

Common questions, wonderfull answers.

Genio
On 1/13/19, 2:34 PM

A. 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.

1.    In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.

2.    Expand Databases, right-click SQLTestDB, point to Tasks, and then click Back Up....

3.    Select OK.




B. Full back up to disk to non-default location

In this example, the SQLTestDB database will be backed up to disk at F:\MSSQL\BAKPrevious back ups of SQLTestDB have been taken.

1.    In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.

2.    Expand Databases, right-click Sales, point to Tasks, and then click Back Up....

3.    On the General page in the Destination section select Disk from the Back up to: drop-down list.

4.    Select Remove until all existing backup files have been removed.

5.    Select Add and the Select Backup Destination dialog box will open.

6.    Enter F:\MSSQL\BAK\Sales_20160801.bak in the file name text box.

7.    Select OK.

8.    Select OK.



Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

5 follower(s)

Stats

Asked: 1/13/19, 2:34 PM
Seen: 1580 times
Last updated: 9/26/19, 5:03 PM