SQL Server 2005 - Missing Tables while Restoring the Backup file- Clarification

Posted on 2008-11-14
Last Modified: 2012-05-05
I took full backup from production server and restore it in another server. But i didn't see some of the below tables :

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.
Question by:PKTG
    LVL 15

    Accepted Solution

    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.

    Author Comment

    In sys.table , these tables "type_desc" shows "User_Table" not system table. Please clarify me. Thanks.
    LVL 51

    Expert Comment

    by: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.

    EE Cleanup Volunteer

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now