Solved

2008 compressed backup - does it need to decompressed before restoring

Posted on 2011-02-17
3
328 Views
Last Modified: 2012-05-11
the compressed backup that 2008 offers- does it have to be decompressed before restoring?

the backup is called tracker.bak if it has to be decompressed, does sql gui offer that?

thanks
0
Comment
Question by:anushahanna
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 500 total points
ID: 34916273
No, it is native to SQL Server, it will decompress upon using the restore commands.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34916308
ok- so that is not it..

then, could you suggest why i am facing the issue in
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/Q_26820590.html
when using the compressed .bak to restore?
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34916795
thanks for confirming it
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem with SqlConnection 4 160
GRANT, REVOKE, DENY 4 38
Delete Trigger in SQL Server2008R2 5 20
AWE-based memory on 32-bit servers 1 23
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now