存储架构

Create a backup of the database, ignore the column

微信扫一扫,分享到朋友圈

Create a backup of the database, ignore the column
0

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.

阅读原文...


微信扫一扫,分享到朋友圈

Create a backup of the database, ignore the column
0

Hello, buddy!

鼠标悬停动画效果

上一篇

mybatis-高级结果映射之一对一(多种方式, 有没提到的你找我)

下一篇

评论已经被关闭。

插入图片

热门分类

往期推荐

Create a backup of the database, ignore the column

长按储存图像,分享给朋友