![]() ![]() However, the files (2012 version) that we downloaded earlier are not yet in this location. We already have sample files here with the 2019 version. It’ll then show us the Backup File Location. We’re getting the backup media type in a file because we’ve already downloaded 2 files. So, let’s select the Device as the source.Ĭlick on the ellipses to locate the files. We want to restore a database that’s from our device. To restore the databases that we’ve downloaded, go back to the SMSS application and right-click on the Databases. Restoring Databases On SQL Server Management Studio Again, these are backup databases from Microsoft that we can restore later on for practice purposes. We can download as much as we want here.įor this tutorial, we’ll download AdventureWorks2012 and AdventureWorksDW2012. The LT stands for lightweight which is just a smaller version of the OLTP database. DW stands for data warehouse which contains the data warehousing workloads. OLTP database contains the typical online transaction workloads. There are 3 types of databases here: AdventureWorks2012 (OLTP), AdventureWorksDW2012 (Data Warehouse), and AdventureWorksLT2012 (Lightweight). For this tutorial, we’ll use the 2012 version but you can certainly use any version that you want. The only difference between these files is their dates. We can download the sample databases under the Download backup files. Look for the AdventureWorks sample databases – SQL Server and click on it. Just go to Google and search for “ download adventureworks”. Downloading Sample Databases For SQL Serverįor practice purposes, we can download the AdventureWorks databases provided by Microsoft. Currently, it only contains System Databases and Database Snapshots folders because we don’t have any database yet. Then, let’s just leave the Authentication to Windows Authentication. You can also have multiple servers like developer server, production server, and many more. If you’re working in any organization, you’ll be given a server name. For this example, we’re only starting to learn SQL so we’ll use Data Engine.įor the Server name, we’ll use localhost because this is where we installed our server earlier. We have different options for the Server type. It will then open the SQL Server Management Studio that we’ll use to connect the SQL Server.Ī dialog box will appear asking for the Server type, name, and authentication. Look for Microsoft SQL Server Management Studio application and click on it to open it up. After installing, search SSMS on your computer. ![]() You can then install it on your computer once downloaded. Again, SSMS is our ID environment which will be used to connect SQL Server.Īfter that, just click on the Free Download link to download SSMS. It will then redirect us to a page from Microsoft where we can download SSMS. Downloading and Installing The SMSS (SQL Server Management Studio)Īfter installing the SQL Server, it’ll also require us to install SSMS. We need to remember the server name for connecting our server later on. The most important thing to remember is the INSTANCE NAME and the Server name.įor this example, our INSTANCE NAME is MSSQLSERVER and the Server name is localhost. This contains some information about our server. It will then start downloading and installing the system and its packages.Īfter the installation, a window will appear. Then, choose the install location on your PC, and click the Install button. It will display the install location, minimum free space requirement, and download size. ![]() Installing The SQL Server (Developer Edition)įor the installation type, let’s choose Basic.Ĭlick the Accept button for the License Terms Agreement. Once downloaded, click on the SQL2019.exe file. As of this writing, it will download SQL Server 2019. We need to download the developer edition so let’s click the Download now button under the Developer. Scroll down to this page and look for the download section. Look for the SQL Server Downloads | Microsoft and click on it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |