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?
Asked
Active
Viewed 589 times
0
-
2Standard isn't free but google will tell you this. – S3S Dec 01 '16 at 16:38
-
1This question belongs either in the superuser.com Stack Exchange forum or in the Microsoft SQL Server Setup and Upgrade forum: https://social.technet.microsoft.com/Forums/en-US/home?forum=sqlsetupandupgrade – T-Heron Dec 01 '16 at 16:47
-
1@THeron:DBA.SE suits best – TheGameiswar Dec 01 '16 at 16:58
1 Answers
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.
Wes Palmer
- 880
- 4
- 15
-
the first DB shows size 6624.19 MB and space available 37.97 MB, and the second DB shows size 1116.00 MB and space available 7.90 MB it means i have only 45.87 mb remaining balance? – Rizwan Dec 01 '16 at 17:14
-
Actually it is 10 GB per DB. For example you can have 10 database all at 9GB and not exceed the size limits. – Wes Palmer Dec 01 '16 at 18:42