Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
2  
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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.