1
Reply

What is The Difference Between SQL Server and SQL Azure ?

Sanjay Dwivedi

Sanjay Dwivedi

Jul 20, 2017
434
0

    SQL Azure Database Unsupported features:1.ServicesSQL Server Agent Service SQL Server Browser Service SQL Server Full Text Search Service SQL Server Service Broker Service2. Protocal SQL Azure support only TCP while SQL Server support Http/TCP/Named Pipe etc3.Backup and Restore SQL Azure provides the aforementioned replication to provide high availability, this protects you only against failures within the datacenter (such as hardware problems, data corruption, and so on). It does not protect your data against user errors.With SQL Server, you would typically create a backup to the filesystem and restore from the same. With SQL Azure, this is not allowed because that filesystem for an SQL Azure data node represents a potentially shared resource across all the tenants who have Databases on that node.

    Sanjay Dwivedi
    July 20, 2017
    0