Hi, I posted this thread on Office365(&SharePoint Online) forum and advised to create a new thread here. (http://community.office365.com/en-us/f/154/t/276871.aspx)
I was wondering if I should post this on "Access for Developers" forum, but thought would like to try this forum first.
This is to do with the Access WebApp, introduced with Acess2013, which uses Azure SQL database as back-end.
According to
http://technet.microsoft.com/en-us/library/cc262787%28v=office.15%29.aspx#SpApps, regarding "Maximum Access app database storage size in SQL Azure", it says "Each Access app created on SharePoint Online creates a database on SQL Azure. 1
GB is the limit for the database storage on SQL Azure".
How would I be able to check the size of the current SQL Azure database? I am looking after two Access Web Apps hosted on SharePoint Online. I need to monitor the size of the databases so that they will not exceed 1GB. The current snapshot
backup files are just over 10MB, including all the data. But SQL database size is a separate thing.
I have access to the backend SQL Azure using SQL Management Studio, but the command such as "sp_helpdb" does not work. I get "Could not find stored procedure 'sp_helpdb'." message.
I also tried the sql statement given in the thread in this forum "How to get the maximum size of Windows Azure SQL Database", but "VIEW DATABASE STATE permission denied in database" error message.
Would you please help me?
Many thanks in advance.
Keiko