JJY

SQL Azure

Database Backup:

http://msdn.microsoft.com/en-us/library/ff951624.aspx

CREATE DATABASE destination_database_name     
  AS COPY OF [source_server_name.]source_database_name

SELECT name, state, state_desc from sys.databases
WHERE name = DATABASE_NAME
 

Database size change:

http://stackoverflow.com/questions/3426360/sql-azure-web-vs-business-edition

 

CREATE DATABASE Test (EDITION=’WEB’, MAXSIZE=1GB)

 

ALTER DATABASE Test MODIFY (EDITION=’WEB’, MAXSIZE=5GB)
ALTER DATABASE Test MODIFY (EDITION=’BUSINESS’, MAXSIZE=10GB)


 

posted on 2011-04-18 16:07  MikeJia  阅读(193)  评论(0编辑  收藏  举报

导航