SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP


Create Database from Backup on SQL Server

Using SQL Server database backup file, administrators can create new database with restore task option. In this SQL Server tutorial I'ld like to show how SQL database administrators and Transact-SQL developers can create new database from backup file using Restore task on SQL Server Management Studio.

I have a SQL Server 2014 instance running on my development computer. I have also downloaded AdventureWorks sample database backup file.
I want to create a new database on my SQL Server instance using this backup file of the AdventureWords database.

First, launch SQL Server Management Studio (SSMS)
Connect to SQL Server instance which you want to create AdventureWorks database
Right click on Databases node
Select Restore Database... context menu option

restore database backup on SQL Server Management Studio

When Restore Database wizard is displayed, in General tab switch to Device on Source section to point to database backup file of AdventureWorks sample database.
Click on "..." button.

select SQL database backup source

Select backup devices dialog screen will be displayed.
Keep default option File for Backup Media Type unchanged.

add backup media for SQL backup files

Press Add button

Point to backup file on File Explorer screen.
I'm using SQL Server 2014 sample database AdventureWorks backup file for this SQL tutorial to show creating a new database with backup file.

SQL Server database backup to restore

Click OK

In Destination section, type the database name you want to create on SQL Server. A database name which does not exist on the SQL Server instance will result with creation of the database successfully as we aim for this tutorial.

create new database from SQL backup file

Press OK button
SQL Server will successfully create new database from backup file if no unexpected error occurs.



SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.