mibuso.com

Microsoft Business Solutions online community
It is currently Wed Jun 19, 2013 6:39 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Log Shipping to SQL Azure for backup purposes
PostPosted: Wed Jun 06, 2012 11:18 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 6:37 pm
Posts: 7932
Location: Howell, MI
Country: United States (us)
Here's an interesting scenario. One of my customers wants to have a backup of their database in the cloud, and was asking whether it is possible to log ship an on-premises SQL database to SQL Azure, and use it as the source for disaster recovery. If their on-premises server goes down, they would take a backup of the SQL Azure database and use that to restore the on-premises database. They would never use the SQL Azure to connect NAV to, it would only serve as a copy of the production database.

They've done some shopping around and found that if this is possible, it is much less expensive than having offsite storage, or log shipping to a VM in the cloud.

I don't even know if it is possible to do this, so I figured I'd post the question here. Does anyone have experience with this, or know whether it is possible?

_________________
Daniel Rimmelzwaan
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject: Re: Log Shipping to SQL Azure for backup purposes
PostPosted: Wed Jun 06, 2012 11:27 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5317
Location: Prague
Country: Czech Republic (cz)
As I understand it with Azure you only get access to the tables, no back end access at all, so I can't see how you would configure log shipping.

If it can be made to work though, then its quite an innovative use of Azure.

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: Log Shipping to SQL Azure for backup purposes
PostPosted: Thu Jun 07, 2012 1:41 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7526
Location: Milan
Country: Italy (it)
Another reason it is not possible: In SQL Azure the tables MUST have a clustered index. SQL Azure needs it to be able to keep its own internal 'cloud-replication'. And in NAV, some NAV systemtables ($ndo$dbproperty I think) does not have a clustered index.
Another problem could be the size of the DB. It has a limit (I think 150GB but I am not sure).

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting


Top
 Profile  
 
 Post subject: Re: Log Shipping to SQL Azure for backup purposes
PostPosted: Fri Jun 08, 2012 12:21 pm 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2591
Location: MA
Country: United States (us)
I think the SQL Azure limit is 50 GB.

_________________
There are no bugs - only undocumented features.


Top
 Profile E-mail  
 
 Post subject: Re: Log Shipping to SQL Azure for backup purposes
PostPosted: Fri Jun 08, 2012 1:28 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7526
Location: Milan
Country: Italy (it)
Checked it out: before it was 50GB. Now it is 150GB.
http://msdn.microsoft.com/en-us/library/windowsazure/ee336245.aspx#dcasl
http://sqlblog.com/blogs/greg_low/archive/2011/12/13/sql-azure-db-size-limit-increased-to-150gb.aspx

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting


Top
 Profile  
 
 Post subject: Re: Log Shipping to SQL Azure for backup purposes
PostPosted: Fri Jun 08, 2012 1:39 pm 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2591
Location: MA
Country: United States (us)
kriki wrote:


Guess I missed that one. Thanks.

_________________
There are no bugs - only undocumented features.


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: