Create a backup of the database, ignore the column

存储架构 2018-10-14 阅读原文

I'd like to create a database backup using SSMS. The backup file will be a .bak file, but I would like to ignore 1 column in a certain table, because this column isn't necessary, but it takes up 95% of the backup size.

The column values should all be replaced by 0x00 (column type is varbinary(max), not null).

What's the best way to do this?

FYI: I know how to generate a regular backup using Tasks => Back Up..

There is a long way of doing what you ask. Its basically create a new restored database, remove the non required data and then do a new backup again.

0x00

If you only needed a few tables, you could have used bcp
but that looks out of the picture for your current requirement.

Hello, buddy!

责编内容by:Hello, buddy!阅读原文】。感谢您的支持!

您可能感兴趣的

TCGA 临床数据的提取 TCGA数据库除了有各种癌症的大样本数据外,还有很完善的临床数据,这点是其他数据库所缺少的,因此我们需要会从TCGA数据库中提取对应癌症的临床数据,然后利用这些数据来进行后续的分析(比如想知道某个基因的表达对病人的预后是否有影响) 下...
Notes from the field: Visual Studio Live Washingto... By: Edgewood Solutions | | Related Tips:More > Professional Development Conferences This tip is a synops...
突破存储跨中心双活方案设计阶段难点之五:双中心间通讯不可控... 存储跨中心双活最关键、最难点就是链路质量,如何把控该风险? 双中心间通讯不可控问题:一是链路稳定状况不可控;二是IO延时指标不可控。这些不可控因素非常容易造成灾难性影响,轻则导致数据库读写性能灾难,重则导致数据库节点直接处于僵死状态。另...
DevOps : Releasing your database code with pre- an... Introduction In a previous blogpost about DevOps (Part I andPart II) the basics of Build and Release process has been...
Database App Development and Deployment to Linux i... The Devart company recently released UniDAC with support for Linux 64-bit platform. UniDAC makes application development...