Backing up and taking apart an SQL DB to back it up separate and restoring it separate pieces
Hello Backup Admin's
We would like to take a SQL DB and back up pieces of it. Not as a whole DB, but in Individuals straps. I.E. The core of the DB and its parts attached to it. If I wanted to just back up a piece of info can that be done? And if so, how? I have always done it as a whole and when a restore was needed I would restore it as a whole and take out what I needed from it.
Please pass on the good news...