| Author |
Topic |
|
wind4kite
Starting Member
3 Posts |
 Posted - 2014-12-24 : 07:44:18
|
| Dear all,I have to restore a .bak database file of 14GB to export it in a format compatible to Excel or access.I tried with the free of SQL Server 2008 Management Studio but it is limited to 10GB.Please, I would be thankfull for any advice.Thanks in advance! |
|
|
sz1
Aged Yak Warrior
555 Posts |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-24 : 08:53:03
|
quote:
Originally posted by wind4kite
Dear all,I have to restore a .bak database file of 14GB to export it in a format compatible to Excel or access.I tried with the free of SQL Server 2008 Management Studio but it is limited to 10GB.Please, I would be thankfull for any advice.Thanks in advance!
If you really "have" to do the restore, I presume this is on the job, right? If so, ask your manager for a license to a full SQL Server edition. Even better, convince them to give you an MSDN license and download what you need. |
 |
|
|
wind4kite
Starting Member
3 Posts |
Posted - 2014-12-24 : 09:42:38
|
| Dear all,thanks for the help.I will try to install the SQL server 2014 trial version. Does anybody know if it is limited also to 10GB? |
|
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2014-12-24 : 09:49:03
|
| Its the full software trial for 180 days with full functionality. You could purchase SQL Developer edition quite cheap which is around £50, you get full functionality with that too but due to licensing you should not use on servers and is really for development purposes on your local machine, although nothing in the software prohibits you from using anywhere. Its in the licence agreement.We are the creators of our own reality!Developer Editionhttp://www.microsoftstore.com/store/msusa/en_US/pdp/SQL-Server-2014-Developer-Edition/productID.298540400 |
|
|
|
wind4kite
Starting Member
3 Posts |
Posted - 2015-01-20 : 04:36:28
|
| Dear All,I have just installed the SQL server 2014 trial version for 180 days.I tried to restore the database but I failed because the size is bigger than 10GB. It was the same error message when I tried the free version.BEllow the error message:I thought this version would allow me to restore a database bigger than 10GB. This is the link to download the file. (http://technet.microsoft.com/en-gb/evalcenter/dn205290.aspx)As I am not logged as ADMIN, is it may be an issue?""""""TITLE: Microsoft SQL Server Management Studio------------------------------Restore of database 'AKF' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)------------------------------ADDITIONAL INFORMATION:System.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database. (Microsoft.SqlServer.SmoExtended)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&LinkId=20476------------------------------BUTTONS:OK------------------------------""""""" |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-20 : 06:42:24
|
| your problem is not s SMS. Your problem is the database engine itself. When running a trial version you are limited in the maximum size of the database. Tell your manager that you need full version preferably enterprise. You're trying to restore to your own PC, right? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2015-01-21 : 01:49:41
|
| Developer edition sounds like the best approach.An alternative approach is to try and shrink the database to below 10 GB (if possible). Then back it upJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
Alternative to SQL Server 2008 Management Studio