Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 414
  • Last Modified:

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.
0
PKTG
Asked:
PKTG
1 Solution
 
Faiga DiegelSr Database EngineerCommented:
These are subscriptions made on your production server.Tthey are categorize as system tables under your database. You need to recreate your subscriptions, articles, publications, etc to recreate these system tables.
0
 
PKTGAuthor Commented:
In sys.table , these tables "type_desc" shows "User_Table" not system table. Please clarify me. Thanks.
0
 
Mark WillsTopic AdvisorCommented:
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
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now