[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

compression option at database level instead of server level?

Posted on 2014-08-14
3
Medium Priority
?
122 Views
Last Modified: 2014-08-25
is it possible to set that only certain databases will use the 2008 compression automatic option during backup? if so, where can we see this setting (system views)?
0
Comment
Question by:25112
  • 2
3 Comments
 
LVL 70

Expert Comment

by:Scott Pletcher
ID: 40261948
No.  You can set this at the server level, but then it applies to ALL dbs.

USE master;
EXEC sp_configure ‘backup compression default’, '1';
RECONFIGURE WITH OVERRIDE;

But that shouldn't be a big deal.  Why don't you want the backups for some dbs compressed?
0
 
LVL 5

Author Comment

by:25112
ID: 40263727
ok.. hmm..

one db is 400GB, other 120GB.. but both backups are almost same in size.. so I wondered if one alone could be compressed and other not .. I just wanted to check.
0
 
LVL 70

Accepted Solution

by:
Scott Pletcher earned 2000 total points
ID: 40263764
You can do it db by db By specifying it in the BACKUP command:

BACKUP DATABASE ... WITH COMPRESSION

BACKUP DATABASE ... WITH NO_COMPRESSION
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Screencast - Getting to Know the Pipeline
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

834 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