Please note that when this SQL Server tutorial is first released, the most recent SQL Server 2012 build was SQL Server Denali, CTP3. mdf file browser is displayed, go to file folder where AdventureWorks2012_Data.mdf data file is located in. mdf data file location where the target sample database files exist. buton in order to select the AdventureWorks sample database data file to attach. Then SQL Server Attach Databases tool will be displayed as shown below.Ĭlick on Add. Right click on Databases node and from context menu choose Attach.
Adventureworks database sql server 2012 install#
Then open Microsoft SQL Server Management Studio 2012 in order to attach database AdventureWorks as SQL Server 2012 sample database.Ĭonnect to the SQL Server 2012 Denali instance where you want to install sample database. This folder path changes according to the installation path selected during SQL Server setup and to the X64 or X86 build of the database platform tool. For example:Ĭ:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA Save the data file into SQL Server Engine Data directory where user databases exist.
Here is how you can attach sample db within a few steps and start using a mature database with data in it.įirst download sample database data file. I've already download sample database AdventureWorks2008R2 for SQL Server 2012 and choose the method of database attach to set this database on my running SQL Server 2012 database instance. Attach Database in SQL Server 2012 using SSMS
0 kommentar(er)
