Link to home
Start Free TrialLog in
Avatar of PKTG
PKTGFlag for United States of America

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.
ASKER CERTIFIED SOLUTION
Avatar of Faiga Diegel
Faiga Diegel
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PKTG

ASKER

In sys.table , these tables "type_desc" shows "User_Table" not system table. Please clarify me. Thanks.
Avatar of Mark Wills
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