Solved

MSSQL 2005 Restores from ZIP files

Posted on 2009-04-08
4
161 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thank you !!!
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

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 I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

744 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

16 Experts available now in Live!

Get 1:1 Help Now