Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Alternative to SQL Server 2008 Management Studio

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

Posted - 2014-12-24 : 07:46:48
Download full trial:

http://www.microsoft.com/en-gb/server-cloud/products/sql-server/try.aspx

Or get permissions to the server and use the tool there.



We are the creators of our own reality!
Go to Top of Page

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.
Go to Top of Page

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?
Go to Top of Page

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 Edition
http://www.microsoftstore.com/store/msusa/en_US/pdp/SQL-Server-2014-Developer-Edition/productID.298540400
Go to Top of Page

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
------------------------------
"""""""
Go to Top of Page

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?
Go to Top of Page

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 up

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -