Solved

MSSQL 2005 Restores from ZIP files

Posted on 2009-04-08
4
162 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
  • 2
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
bmatumbura earned 250 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
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.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

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

24 Experts available now in Live!

Get 1:1 Help Now