PKTG
asked on
SQL Server 2005 - Missing Tables while Restoring the Backup file- Clarification
I took full backup from production server and restore it in another server. But i didn't see some of the below tables :
sysarticlecolumns
sysarticles
sysarticleupdates
syspublications
sysreplservers
sysschemaarticles
syssubscriptions
systranschemas
MSpeer_lsns
In production server some of the tables listed above has records and some of them not. In sys.table , these tables "type_desc" shows "User_Table". And also these tables created long time back. I guess while taking backup it shoud backup all the tables in the database . I don't know why these tables are not showing while restoring. Please clarify me. Thanks.
sysarticlecolumns
sysarticles
sysarticleupdates
syspublications
sysreplservers
sysschemaarticles
syssubscriptions
systranschemas
MSpeer_lsns
In production server some of the tables listed above has records and some of them not. In sys.table , these tables "type_desc" shows "User_Table". And also these tables created long time back. I guess while taking backup it shoud backup all the tables in the database . I don't know why these tables are not showing while restoring. Please clarify me. Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I will leave the following recommendation for this question in the Cleanup topic area:
Accept: faiga16 {http:#2263758}
Any objections should be posted here in the next 4 days. After that time, the question will be closed.
mark_wills
EE Cleanup Volunteer
I will leave the following recommendation for this question in the Cleanup topic area:
Accept: faiga16 {http:#2263758}
Any objections should be posted here in the next 4 days. After that time, the question will be closed.
mark_wills
EE Cleanup Volunteer
ASKER