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
solution1368Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Anthony PerkinsConnect With a Mentor Commented:
1. However you named it in your script. You could call it CMP if you wanted.
2. No different.

Just a word of caution:  A backup is of no use to you, if you cannot restore from it.  So please test your backups (compressed or not) frequently and you will not be surprised.
0
 
didnthaveanameCommented:
1) pretty sure it maintains the .bak extension, just compressed

2) you restore like you would any other backup
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.