<div>
I cannot find a link that proves it, but i assume that MS will definitely have improved the compression technology for backups between 2 versions. There are quite some 3rd party tools for improving the size of the backups, as databases do grow very large. (see <a href="http://www.sqlmag.com/Article/ArticleID/98180/sql_server_98180.html" rel="ugc">http://www.sqlmag.com/Article/ArticleID/98180/sql_server_98180.html</a>) So there is absolutely place for improvement for MS, and so i would not worry about this at all; Sounds very logical to me. <br />
<br />

</div>


I cannot find a link that proves it, but i assume that MS will definitely have improved the compression technology for backups between 2 versions. There are quite some 3rd party tools for improving the size of the backups, as databases do grow very large. (see http://www.sqlmag.com/Article/ArticleID/98180/sql_server_98180.html [http://www.sqlmag.com/Article/ArticleID/98180/sql_server_98180.html]) So there is absolutely place for improvement for MS, and so i would not worry about this at all; Sounds very logical to me.



<div>
<div class="content wysiwyg-content">
I have two DB backups :<br />
DB a is 54345K<br />
DB b is 456130K<br />
<br />
I restore these DB into SQL 2005 and the Physical Files are:<br />
DB a.mdf- 146048k<br />
DB a.ldf- 399104k<br />
DB b.mdf- 504768k<br />
Db b.ldf- 387968 k<br />
<br />
I back these Databases up:<br />
DB a is now: 44299k<br />
DB b is now: 292132k<br />
<br />
Is this normal?
</div>
</div>


I have two DB backups :
DB a is 54345K
DB b is 456130K

I restore these DB into SQL 2005 and the Physical Files are:
DB a.mdf- 146048k
DB a.ldf- 399104k
DB b.mdf- 504768k
Db b.ldf- 387968 k

I back these Databases up:
DB a is now: 44299k
DB b is now: 292132k

Is this normal?

SQL Database shrinks after restore into SQL 2005. Is this normal?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.