How to restore compressed SQL Server backup

Vikas Gore

7y5.2k

Hi,

How can i restore the .bak files which is taken with database compression enabled in sql server??

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vikas Gore7y ago
Hi Rajnikant,

Unable to restore using RESTORE command
Rajanikant Hawaldar7y ago
refer these below links and let me know

https://www.mssqltips.com/sqlservertip/1513/exploring-database-backup-compression-in-sql-server-2008/

https://dba.stackexchange.com/questions/55055/how-to-move-a-database-from-sql-server-2012-to-sql-server-2005/55063#55063

https://dba.stackexchange.com/questions/137005/restore-a-database-with-compression-on-a-non-enterprise-edition-sql-server

https://support.microsoft.com/en-in/help/4019893/fix-restore-fails-when-you-do-backup-by-using-compression-and-checksum
Rajanikant Hawaldar7y ago
Hi Vikas,
let me know issue is fixed
USE master
GO

RESTORE DATABASE AdventureWorks_compressed
  FROM DISK = N'C:\SQLData\AdventureWorks_compressed.bak'
  WITH MOVE N'AdventureWorks_Data' TO N'C:\SQLData\AdventureWorks_c.mdf',
  MOVE N'AdventureWorks_Log' TO N'C:\SQLData\AdventureWorks_c.ldf',
  RECOVERY,
  STATS = 10;
GO
Thanks
Vikas Gore7y ago
Hi Amit,

I want to restore native compressed .bak file.
Amit Gupta7y ago
Right click on your sql database and then choose Restore Database and follow the instructions on the screen