SQL Backup skipping a few tables
Posted on 2016-11-03
I've got a Microsoft CRM database that I need to work with in order to prep for a data conversion to our new internal software.
However, this database is 40GB and it's problematic for me to get fresh copies of it from production. That being said, there are 2 tables that are 30GB in size, just blobs that I don't need. Can I run a backup into a .bak and exclude those from being exported? (This is SQL2005 fyi)