Does full backup or simple backup also take snapshot of db schema as well as data
Does full or simple backup back up the database schema? that is in following scenario: 1. do full backup 2. add some tables and c开发者_如何学Pythonolumns in some table; drop some tables and some columns in some table 3. do restore with the full backup file 4. does that schema get back to the state it backup?
In general the answer is yes. But you'd have to clarify on what db server you're talking about and how the backups are being done.
EDIT : A full backup will back everything up.
精彩评论