tag:blogger.com,1999:blog-8930349235661427759.post7974723827646674518..comments2024-03-19T06:30:10.098+01:00Comments on Keep It Simple and Fast: Backup compression in SQL Server 2008 (R2)André van de Graafhttp://www.blogger.com/profile/07230010757193182052noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8930349235661427759.post-4342513496391558782012-11-06T06:44:14.677+01:002012-11-06T06:44:14.677+01:00TacticalDragon,
SQL will take care of that. For i...TacticalDragon,<br /><br />SQL will take care of that. For instance you can restore a compressed backup on a server which does not support backup compression.<br /><br />Gr. AndreAndré van de Graafhttps://www.blogger.com/profile/07230010757193182052noreply@blogger.comtag:blogger.com,1999:blog-8930349235661427759.post-81389627952177397112012-11-05T23:27:50.015+01:002012-11-05T23:27:50.015+01:00This comment has been removed by the author.TacticalDragonhttps://www.blogger.com/profile/05179242956426979184noreply@blogger.comtag:blogger.com,1999:blog-8930349235661427759.post-90740649843459448072012-11-05T23:27:39.947+01:002012-11-05T23:27:39.947+01:00I've read that you cannot have different backu...I've read that you cannot have different backup types Compressed and non compressed within a media set. <br /><br />Lets say i turn on compression at the server level a day before the next full backup. Now in my environment i have full database backups that happen once a week per database, differentials daily and tlogs once an hour. <br /><br />When i turn on compression at the server level in that scenario i will have quite a few compressed tlog backups and possibly a compressed differential for that last backup. <br /><br />Would restoring become a problem at that point for me? Or is SQL smart enough to figure out that the last full backup was not compressed, and therefore wont compress the differential and tlogs attached to it? Or will it just blindly start compressing what ever is backed up at that point? <br /><br />Thank youTacticalDragonhttps://www.blogger.com/profile/05179242956426979184noreply@blogger.com