This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
When we restore a database from server A to server B, do the system tables in the database also get restored?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi ChaitanyaKiran-2787,
How are things going? Did the answers help you?
If the replies could help you, please accept the useful reply as answer to help other community members find the helpful reply quickly.
If not, please don't hesitate to let us know and share us more information in order to provide further help.
Best Regards,
Amelia
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
The system tables for the database will get restored yes. If they didn't then you wouldn't have any schema, security or other settings and the DB would be useless. You'd end up having to restore the data and then set up the security and other settings again which wouldn't make sense.
However server-level settings are not tied to a particular database and wouldn't be restored.
Thanks for the answer. I restored a database from Prod to TEST, but the system tables in the database did not get restored.What could be the reason?
Which tables didn't get restored from the DB?
the system tables
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
What exactly do you mean by "system tables", what table names?
All tables included in the database are backed up and restored. Some of the objects you see in a database, are actually in master, not in the current database.
Again, which "the system tables" do you mean? E.g. DMV are not persisted.
A restore of a backup is an exact 1:1 copy of the source database with all objects, without any exception.
Which "system tables" do you mean?
The content of e.g. DMV are not persisted.
As other have said, a backup is full copy of the database. BACKUP works on a low level, and does not really understand tables. It simply writes pages to disk (or tape).
If you think some data is missing, a possible explanation is that you did something like this:
BACKUP DATABASE db TO DISK = 'C:\temp\existingfile.bak'
RESTORE DATABASE db FROM DISK = 'C:\temp\existingfile.bak'
In this case, BACKUP appends the backup to the existing file, but when you restore the database, RESTORE picks the first backup.
You can do this:
RESTORE HEADERONLY FROM DISK = 'C:\temp\yourbackup.bak'
If you see more than row, this means that you have multiple backups. If there are five rows, and you want the most recent one, you need to add WITH FILE = 5 to your RESTORE command.
And, no, this is not the most user-friendly design.
Hi ChaitanyaKiran-2787,
How are things going?
Could you please share the detailed system tables in the database that have not been backed up?
Please try to take a good new backup and restore it in the server B.
Best Regards,
Amelia