[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

winzipping a backup of a large DB (22G)

Can you winzip a  backup of a  large DB (22G)
0
kdeleon
Asked:
kdeleon
1 Solution
 
Anthony PerkinsCommented:
Not without detaching the database first.  See the sp_detach_db and sp_attach_db system Stored Procedures for more info.

Anthony
0
 
nielspCommented:
Create a DB_Maintenanceplan that creates a backup for you, then zip this backupfile
0
 
Anthony PerkinsCommented:
nielsp is right,  I misread your question.  There should be no problem doing a winzip of a SQL backup.

Anthony
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
KatanaCSCommented:
Actually, while zipping database and database backup files works, you WILL have a problem -- WinZip will throw the following error:
"The size of {filename} exceeds the maximum file size of 4 gigabytes allowed by the Zip 2.0 format."

Unfortunately, at this time I don't know of any other archival software that will handle files this size.

Regards,
KatanaCS
0
 
nielspCommented:
And there's a point for KatanaCS. My DB's aren't this big, so I never encountered this limitation. I don't know a compress-utility that can handle files this size. What is the reason for wanting to zip the DB? Perhaps if you tell us that, we can make up a alternative solution.
0
 
Eugene ZCommented:
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now