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.
| Author |
Topic |
|
Xarzu
Starting Member
25 Posts |
 Posted - 2012-09-18 : 19:32:29
|
| How do I back up and restore a SQL Azure database? For that matter, how do I back up and restore an entire Azure account? Let's suppose I am working at a company and I buy a 3 month trial account before my company comes onboard and says that there is a corporate account for me to work on? How do I move all my stuff from one account to another? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-18 : 19:45:58
|
| AFAIK, there is no backup for Azure. There are ways to export data out, but not Backup as we know it in On Premise SQL Server.-Chad |
 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-09-19 : 01:23:51
|
| As 'Chad' already suggested thst SQL Azure does not allow backups to a file. But we have some other alternatives: First, we can make a snapshot of our SQL Azure database with the CREATE DATABASE AS COPY.Another alternative is to use Sync Framework.I only aware about these two solutions. May be there are more solutions please search it on Google: https://www.google.com/search?hl=en&noj=1&sa=X&ei=lE9ZUOfgGISPrgeSyIC4DA&ved=0CBwQvwUoAQ&q=how+to+backup+and+restore+a+SQL+Azure+database |
|
|
|
|
|
|
How do I back up and restore a SQL Azure database?