Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to back up my entire DB including one table that's allocated in "Tables -> System Tables". When I try to generate the sql scripts to back up my DB this table isn't mapped in this scripts. Do I need to do something more to map this table to the scripts?

share|improve this question
What table of yours is in system tables, why is it there, and how did it get there? Also why don't you backup your database to backup your database, instead of scripting it? – Aaron Bertrand Sep 12 '11 at 16:31
up vote 3 down vote accepted

Creating scripts of objects usually isn't the best backup method.

There shouldn't be any actual tables listed under Tables > System Tables. Those should all be catalog views unless you've hacked the system objects to put one of yours tables in there.

share|improve this answer
Entity framework migrationHistory tables are located in system tables. – Moulde Apr 15 '13 at 12:14
Those wouldn't be use objects so they shouldn't be included in his script, which I assume is going into source control. – mrdenny Apr 15 '13 at 17:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.