SQL Server 2014

Question

Does sql server 2014 saves data to the cloud or to local storage of pc?

If it can be connected to cloud, then how I can do?

Answer 1

Good day ,

I assume that you mean to connect to Azure SQL Database from local machine using the SQL Server Management Studio and not from one SQL Server to the remote SQL Server (which can be done using linked server for example). The SQL Server Management Studio is the tool that most of us use to connect local or remote servers. If this is your case then please check this tutorial:

https://azure.microsoft.com/en-us/documentation/articles/sql-database-connect-query-ssms/

* Local SQL Server (a server instance that installed locally) save the data locally, and Azure SQL Database save the data on the Azure SQL Database by default. There are some exceptions for example using external resources. I have feeling that you confusing SQL Server and SQL Server Management Studio.

---

Ronen Ariely  [Personal Site]    [Blog]    [Facebook]    [Linkedin]

Answer 2

SQL Server 2014 stores data locally as does SQL Server 2016, but SQL Server 2016 comes with a new feature called Stretch which allows you to stretch your database to the cloud. This provides a cost-effective way to leverage the power of cloud and ensure availability of your cold data. You can read more here : https://msdn.microsoft.com/en-us/library/dn935011.aspx?f=255&MSPPError=-2147217396

Answer 3

If I may clarify a bit more...
By the way I wrote the same basic answer on my response, without explicitly mention Stretch Database.

1. by default both version 2014 and 2016 and any version store the data where it is installed. SQL 2014 that is installed in the Azure will store the data in the azure (for example SQL 2014 on Azure VM), while if it is installed locally it will store the data locally. Again... this is the default.

2. Both versions of SQL Server can store data remotely (in the azure for example) if we really want to do it. For example, we can use remote shared folder, we can use linked server to SQL on Azure, and lot of other options. Some of these options I showed on my lecture about Stretch Database, as these are the old options (before 2016).

* As I wrote There are some exceptions for example using external resources.  As Shantanu wrote, built-in in SQL server 2016 we have Stretch Database, which is one of these exceptions. Another option for example is PolyBase :-)

---

Ronen Ariely  [Personal Site]    [Blog]    [Facebook]    [Linkedin]