Home > DeveloperSection > Forums > Enormous database in SQL Server Express 2008
Chris S
Chris S

Total Post:48

Posted on    September-28-2015 4:30 AM

 MSSQL Server Database  MSSQL Server 

 1 Reply(s)
 797  View(s)
Rate this:
I've got a large backup that I need to partially install into our instance of SQL Server express 2008. The backup file is over the 4096Mb limit that restricts SQL Server Express. Is there any way to do a partial restore?

This database is from a customer and I need to do some development against it. We don't have any licensed versions of SQL Server 2008 that I can restore this data into and chop it apart.

Incidentally, the error I get is :

TITLE: Microsoft SQL Server Management Studio

Restore failed for Server 'ZEPPO\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
System.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&LinkId=20476

Mayank Tripathi
Mayank Tripathi

Total Post:397

Posted on    September-28-2015 6:16 AM

Don't want to miss updates? Please click the below button!

Follow MindStick