存储架构

Create a backup of the database, ignore the column

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

Create a backup of the database, ignore the column
0 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.

Hello, buddy!
感谢您的支持!

    鼠标悬停动画效果

    上一篇

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

    下一篇

    您也可能喜欢

    评论已经被关闭。

    插入图片