Solved

sql back up compress

Posted on 2013-05-16
2
342 Views
Last Modified: 2013-05-29
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
0
Comment
Question by:solution1368
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Expert Comment

by:didnthaveaname
ID: 39173759
1) pretty sure it maintains the .bak extension, just compressed

2) you restore like you would any other backup
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 39177897
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question