November 28, 2014 at 1:07 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 28, 2014 at 3:05 am
This was removed by the editor as SPAM
November 28, 2014 at 3:12 am
Easy question.
Correct answer, but utterly useless references. The first doesn't even mention maintenance plans. The second says they can't be used to do bakups for a database that uses SQL Server Managed Backup to SQL Azure, not that they aren't supported at all (for example for doing database checks, or index rebuilds, or statistics update, anything but backups). So the references don't support the answer at all.
Perhaps a better reference would be http://msdn.microsoft.com/en-us/library/azure/ee336245.aspx#sqlagent which says that SQL Server Agent isn't supported, and since maintenance plans use (or used, last time I looked - it may have changed) SQL Agent for scheduling they won't work without it.
Tom
November 28, 2014 at 9:33 am
TomThomson (11/28/2014)
Easy question.Correct answer, but utterly useless references. The first doesn't even mention maintenance plans. The second says they can't be used to do bakups for a database that uses SQL Server Managed Backup to SQL Azure, not that they aren't supported at all (for example for doing database checks, or index rebuilds, or statistics update, anything but backups). So the references don't support the answer at all.
Perhaps a better reference would be http://msdn.microsoft.com/en-us/library/azure/ee336245.aspx#sqlagent which says that SQL Server Agent isn't supported, and since maintenance plans use (or used, last time I looked - it may have changed) SQL Agent for scheduling they won't work without it.
+1
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 28, 2014 at 9:55 am
November 30, 2014 at 12:11 am
TomThomson (11/28/2014)
Easy question.Correct answer, but utterly useless references. The first doesn't even mention maintenance plans. The second says they can't be used to do bakups for a database that uses SQL Server Managed Backup to SQL Azure, not that they aren't supported at all (for example for doing database checks, or index rebuilds, or statistics update, anything but backups). So the references don't support the answer at all.
Perhaps a better reference would be http://msdn.microsoft.com/en-us/library/azure/ee336245.aspx#sqlagent which says that SQL Server Agent isn't supported, and since maintenance plans use (or used, last time I looked - it may have changed) SQL Agent for scheduling they won't work without it.
Thanx 4 the good reference.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
November 30, 2014 at 5:48 pm
An easy one, even though I haven't used Azure. I don't like them anyway and don't use them, so it wouldn't hurt to have them taken away.
December 8, 2014 at 1:26 pm
Thanks for the question.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply