Link to home
Create AccountLog in
Avatar of solution1368
solution1368

asked on

sql back up compress

I already done back up and check the compress checkbox in sql server. The file is saved, and I have two questions.

1. After it is compressed, what file extension will be? All i see is file.
2. How can I restore the database from the db I just compressed?

The compressed db does not look like it is a zip or something. I just wonder how to restore back...thanks
a.png
Avatar of didnthaveaname
didnthaveaname

1) pretty sure it maintains the .bak extension, just compressed

2) you restore like you would any other backup
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account