Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MSSQL 2005 Restores from ZIP files

Posted on 2009-04-08
4
Medium Priority
?
168 Views
Last Modified: 2012-05-06
Has anyone had issues/problems with storing their full backups as .zip files, unzipping these backups and having problems with a restore. I'm find out if there is a risk in zipping our .bak files for our production to ultimately save tape space ( off site storage is pricey for us)
0
Comment
Question by:sedostal
[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
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
bmatumbura earned 750 total points
ID: 24098975
I don't foresee any problems with this. We have been archiving our .BAK files to .RAR format using WinRAR to save space for the past 3 years with no problems at all
0
 
LVL 11

Expert Comment

by:bmatumbura
ID: 24099001
We scheduled SQL Server to do a differential backup twice during the course of the day; then a full backup at night. The next morning the DB Admin RARs the .BAK file and sends it to an offsite storage building.
0
 

Author Comment

by:sedostal
ID: 24099443
Unfortunately, I believe winRAR  is different Winzip, isn't it. I could be wrong of course.   I'm also looking for someone that may have had a problem with using the restore from it...
0
 

Author Closing Comment

by:sedostal
ID: 31568119
Thank you !!!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

618 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