Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Difference Between Centralized Database and Cloud

Author  Topic 

pradeepbliss
Starting Member

28 Posts

Posted - 2014-05-28 : 02:21:10
I am newbie to cloud database and i know how centralized database works ,In a centralized system, I'll store it on one server. Then, I'll replicate that exact information to Server #2 for safekeeping.All the data's will be placed on root server,but i don't know diff between cloud and centralized database how they are working together.....

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-28 : 11:58:39
I am not clear what you mean by centralized server/database. A cloud database is one that you don't host. The alternative is to host the database on your hardware. There are pros and cons to both. We have all hosted databases with the exception of one database that's hosted in the cloud (SQL Azure). It is very difficult as a DBA to properly manage a database in SQL Azure, in my opinion. For instance, there are no incremental/log backups on SQL Azure.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -