SQL Server 2008 Database Restore

• SQL Editor

  SSCommitted

  Points: 1980

  More actions

  August 11, 2010 at 1:45 am

  #144602

  Hi all

  I am using Sql server 2008 Express Edition with Advanced Services.

  When i restore my database by backup file of size 900 mb then i got this error.

  D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

  TITLE: Microsoft SQL Server Management Studio

  ------------------------------

  Restore failed for Server '01HW202813\sqlexpress'. (Microsoft.SqlServer.SmoExtended)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

  ------------------------------

  ADDITIONAL INFORMATION:

  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.1600.22+((SQL_PreRelease).080709-1414+)&LinkId=20476

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

  What is this?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 11, 2010 at 2:26 am

  #1205197

  While the backup file is only 900MB, the original database was larger than 4GB, and Express is limited to a 4 GB data file.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• SQL Editor

  SSCommitted

  Points: 1980

  More actions

  August 11, 2010 at 3:35 am

  #1205232

  Then,How we will restore this?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 11, 2010 at 4:29 am

  #1205253

  Restore onto a non-express instance, shrink the data file, backup then restore on SQLExpress. (I don't recommend shrinking the source database due to the side effects of shrink)

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass