Go to google and Search northwind database for sql server2012
See this video and follow the steps
Download the executable sql script from the [ Ссылка ]
1- Click Start, select All Programs, click Microsoft SQL Server 2012 and select SQL Server Management Studio OR Type ssms at Run command and Enter. This will bring up the Connect to Server dialog box. Ensure that the Server name YourServerName and that Authentication is set to SQL server Authentication. Click Connect.
2- On the right, right-click Databases and select Restore Database. This will bring up the Restore Database window.
3- On the Restore Database screen, select the From Device radio button and click the … box. This will bring up the Specify Backup screen.
4- On the Specify Backup screen, click Add. This will bring up the Locate Backup File.
5- Select the DBBackup folder and chose your BackUp File.
6- On the Restore Database screen, under Select the backup sets to restore: place a check in the Restore box, next to your data and in the drop-down next to To database: select Database Name.
7- Ok your done.
How to restore a bak file into SQL Server 2012(Video)
Теги
Restore Bak fileSQL Server 2012Northwind RestoreNorthwind downloadRestore DatabaseSQL server restore .bak filehow to restore bak file in sql serverrestore database filerestore .bak file.bak filesql server restore .bak file.bak file sqlhow to open .bak fileImport .bak file to a database in SQL serverhow to restore database in sql server 2012 from .bak file step by steprestore .bak file in sql server 2012infinetsofthowhow toImport .bak file