forum

Home / DeveloperSection / Forums / How we can Reduce DB size to restore to SQL Server Express

How we can Reduce DB size to restore to SQL Server Express

Anonymous User 1920 23-Sep-2015
I have a SQL Server 2008 R2 database, about 15 GB.

I want to copy it for a partner, who is using SQL Server 2008 R2 Express.

I deleted many tables and rows, and now I am sure that the data is smaller than 2 GB.

I make a backup, send to the partner, he tries to restore it but he receives an error:

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database
What did I do wrong?

Updated on 23-Sep-2015
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By