smcsmc1
asked on
MS Adventure works database need to get this database "into" my sqlserver Adventure Works 2014 Full Database Backup.zip
I downloaded:
Adventure Works 2014 Full Database Backup.zip
from codeplex.
I get the zip file (42 MGB) but when I try to decompress it all I get is a 42 MGB .bak file
named AdventureWorks2014.bak
I want to have all contents of database in original zip file placed into my sql server 2014 app on my machine.
Problem 1 I cannot "unzip" the back file
Question 1: After I do somehow get all files extracted is it then a simple process of using sql server management to open the database from the resulting unpacked files above?
Adventure Works 2014 Full Database Backup.zip
from codeplex.
I get the zip file (42 MGB) but when I try to decompress it all I get is a 42 MGB .bak file
named AdventureWorks2014.bak
I want to have all contents of database in original zip file placed into my sql server 2014 app on my machine.
Problem 1 I cannot "unzip" the back file
Question 1: After I do somehow get all files extracted is it then a simple process of using sql server management to open the database from the resulting unpacked files above?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
OK, how does this relate to the .bak file
I am total newbie to SQL server (know DB concepts, SQL etc but not UI)
I have a 42 MGB .bak file how do I get data out of it? I need step by step, thanks
Follow the link and read it. It's a backup file. So you need to restore it.
Transact-SQL statements can be written and submitted to the Database Engine in the following
ways:
• By using SQL Server Management Studio, which is available as
a free download from the Microsoft Download Center.
• By using the sqlcmd utility, which is installed with the client utils.
• By connecting from an application that you create.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am total newbie to SQL server (know DB concepts, SQL etc but not UI)
I have a 42 MGB .bak file how do I get data out of it? I need step by step, thanks