I am using sql server 2008 R2 express edition,it only supports 10 Gb DB space. how can i get know how much space is used and how much free space i have balance,i have tried sp_spaceused, but i didn't get clear answer. i think i have 2 DB's. and if i want to upgrade 2008 R2 express edition to 2008 R2 standard edition what is the procedure?, can i upgrade directly or need to take backup and uninstall express edition and then need to install standard edition?. is that anything i need to pay (for license) to upgrade to standard edition?
我使用的是sql server 2008 R2 express版,它只支持10 Gb的数据库空间。我如何才能知道有多少空间使用以及我有多少可用空间我已经尝试了sp_spaceused,但我没有得到明确的答案。我想我有2个DB。如果我想将2008 R2快递版升级到2008 R2标准版的程序是什么?,我可以直接升级还是需要备份和卸载快递版然后需要安装标准版?我需要支付(许可证)升级到标准版的任何东西吗?
1 个解决方案
#1
0
Standard edition will require you to pay a fee fro licensing. As far as upgrading you can just install standard edition without uninstalling express. I would then take a backup for you express database and restore it to the standard edition then uninstall express once everything is working. As far as the space used Right click on your DB name in SSMS and select properties and that will tell you how much space that particular DB is using.
标准版将要求您支付许可费用。升级只需安装标准版而无需卸载快递。然后我会为你表达数据库并将其恢复到标准版本,然后在一切正常后卸载快递。就使用的空间而言,右键单击SSMS中的数据库名称并选择属性,这将告诉您特定数据库使用了多少空间。
#1
0
Standard edition will require you to pay a fee fro licensing. As far as upgrading you can just install standard edition without uninstalling express. I would then take a backup for you express database and restore it to the standard edition then uninstall express once everything is working. As far as the space used Right click on your DB name in SSMS and select properties and that will tell you how much space that particular DB is using.
标准版将要求您支付许可费用。升级只需安装标准版而无需卸载快递。然后我会为你表达数据库并将其恢复到标准版本,然后在一切正常后卸载快递。就使用的空间而言,右键单击SSMS中的数据库名称并选择属性,这将告诉您特定数据库使用了多少空间。