Sql server supports compression for backup?

Question

1.00/5 (2 votes)

See more:

SQL-Server-2012

I want to find if the sql server supports compression for backup using vb.net.

What I have tried:

I tried the following code

BACKUP DATABASE KGMERP_SHANTHI To DISK = 'F:\KGM\ManualBackup\SHANTHI_KGM_07-09-2018 18 48 24 SQL_2012 Express Edition.bak' WITH  NOFORMAT, NOINIT, NAME = 'KGMERP_SHANTHI', SKIP, COMPRESSION

It supports on 2012 enterprise edition and not works on express edition.

Posted 7-Sep-18 3:47am

kgmmurugesh

Updated 7-Sep-18 5:01am

Add a Solution

Comments

Richard MacCutchan 7-Sep-18 10:36am

You should check the documentation for the product you are trying to use.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MadMyche · Accepted Answer · 2018-09-07T05:02:00

Solution 1

Could not find that information for SQL 2012

The 2016 version comparison chart (linked below) shows that Backup Compression is only supported on the Standard and Enterprise versions; the Web, Express, and Express Advanced versions do not
Editions and supported features of SQL Server 2016 | Microsoft Docs[^]

Posted 7-Sep-18 5:02am

MadMyche

Comments

Richard Deeming 7-Sep-18 11:25am

The 2012 version is still around, and says the same thing:
Features Supported by the Editions of SQL Server 2012 | Microsoft Docs[^]

Microsoft certainly don't make it easy to find! :)

MadMyche 7-Sep-18 12:36pm

Agreed

kgmmurugesh 8-Sep-18 0:50am

Thanks, Is there any sql command to check whether the server supports compression, because each customer using different version of sql server. It is more helpful, if i find it in sql command.