January 6, 2017 at 3:44 am
I set up a trial with MS Azure and was practising SQL on MS SQL Server 2016 using the sample database that comes with that. The trial has now run out.
I have been looking for a sample DB so downloaded the Worldwide Importers sample, how do I connect it so I can use it or is there an easier way that I can continue using MS SQL Server for improving my skills?
Any help would be greatly appreciated.
Cheers
James
January 6, 2017 at 4:02 am
SQL Server Developer Edition is now free. You can download that locally.
http://www.microsoft.com/en-us/sql-server/sql-server-editions-developers
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
January 6, 2017 at 4:08 am
Ah sorry I wasn't clear, I have the local version of SQL Server 2016, it's just that the Azure DB I was connected to has now run out (free trial wise), I wanted to reconnect to another DB so downloaded a sample one (WorldWide Importers), I just want to know how to connect to that.
OR failing that how to use SQL server for practicing SQL.
January 6, 2017 at 4:29 am
Restore or attach the database you downloaded to your local instance (restore if you downloaded a backup, attach if you downloaded database files)
To connect to your local instance, just enter your machine's name instead of the azure DB name in the management studio connection dialog
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2017 at 4:39 am
Thanks for that. Sorry about posting on the other board, I posted before I had seen your response.
January 6, 2017 at 5:18 am
james.h291183 (1/6/2017)
Ah sorry I wasn't clear, I have the local version of SQL Server 2016, it's just that the Azure DB I was connected to has now run out (free trial wise), I wanted to reconnect to another DB so downloaded a sample one (WorldWide Importers), I just want to know how to connect to that.OR failing that how to use SQL server for practicing SQL.
Sorry, I misunderstood what you were asking
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
January 6, 2017 at 8:10 am
FWIW, if its a backup, it will typically end with .bak extension. For databases files, you will generally see an .mdf and an .ldf file for basic dbs.
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
January 6, 2017 at 8:14 am
It does end .bak, how do you restore a file?
January 6, 2017 at 8:21 am
james.h291183 (1/6/2017)
It does end .bak, how do you restore a file?
RESTORE. Or use the GUI in SSMS. I recommend the former, since you can tweak it more easily and reuse it as many times as you like. If you're struggling with the syntax, you can use the wizard and click on the Script button instead of running the restore. Please post back if there's any particular aspect of the RESTORE statement you don't understand.
John
January 6, 2017 at 8:27 am
Ah okay, that would require me to get past the connection screen wouldn't it.
At the moment, I just get an error message as the connection is looking to point at the old Azure connection I had, which has since expired.
I have tried using my machine as the server, which also isn't working.
January 6, 2017 at 8:29 am
See also: https://msdn.microsoft.com/en-us/library/mt734205(v=sql.1).aspx for a step-by-step guide
(in this instance, "the target SQL Server instance" should be your local machine name). EDIT: or not, just saw your last post.
January 6, 2017 at 8:37 am
You'll need SQL Server Management Studio (SSMS). Point it at the local version of SQL Server 2016 that you mentioned earlier. When you've connected to that, you'll be able to do the restore, assuming you have sufficient privileges.
John
January 6, 2017 at 8:40 am
Does it work if you just put a dot in?
January 6, 2017 at 8:40 am
As in a . (period if you're American?)
January 6, 2017 at 9:03 am
Dot is fine....I'm in the UK 🙂
At the moment it is just connecting, I reckon I could do the restore once I am beyond that.
I'm a bit confused as to what to enter for each of the below, I have tried server name is JamesPC\James and just JamesPC (which is the name of my machine, but no luck);
Server Type
Server Name
Authentication
Login
Password
Currently it is just my Azure subscription details showing to connect, which obviously won't work.
If anyone is happy to Skype and I will share my screen then that would be good.
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply