Post reply

Prinicpal server Tables are missing

  • July 25, 2012 at 2:07 am

    #259372

    Hi Team,

    In Principal server user tables are not appearing, how can re-store the all the table please suggest me.

  • July 25, 2012 at 2:12 am

    #1517208

    Can you do a select from a table you know in the database as a query or have the tables been dropped from the database?

    If so do you have backups?

  • July 25, 2012 at 2:34 am

    #1517219

    How can i check what went wrong in the database because user tables are missing.

  • July 25, 2012 at 2:35 am

    #1517221

    missing how, just missing in object explorer or can you not even select from them in a query window?

  • July 25, 2012 at 3:14 am

    #1517242

    I have checked errorlog,event log, windows event logs but i did not find the root cause why tables are missing how can i find out the reason for the above

  • July 25, 2012 at 3:20 am

    #1517244

    Please answer the question I have asked twice.

    Can you query the tables or not or have the tables been dropped from the database?

    If not you will need to restore from backup.

  • July 25, 2012 at 3:38 am

    #1517253

    Hi Anthony,

    Thansk for the reply...

    the table are not appearing how can i select the table..we dont know the table names

    restore of the database is not prob

    But my boss is asking what are reasons on this. what are prob on this ..please sugget me .

    tx

  • July 25, 2012 at 3:49 am

    #1517255

    So you dont know the name of at least 1 table within the database without looking at it in object explorer?

    Do you not have a DEV/TEST/UAT copy of the database where you can look at the schema to get a table?

    Causes

    Someone has dropped all the tables, corruption in the meta data, someone dropped the database and then recreated it without the objects. Could be a number of reasons.

    What do you get from the output of

    DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS

    Purchase an expensive log reader and get it to read your transaction logs, assuming your in Full recovery, you will be able to see what happened.

  • July 25, 2012 at 8:53 am

    #1517409

    shiv-356842 (7/25/2012)

    Hi Team,

    In Principal server user tables are not appearing, how can re-store the all the table please suggest me.

    If objects have been dropped, there are chances you have entry in default server trace (Object:Deleted event).

    Trace files are log_##.trc file located at C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log

  • July 25, 2012 at 12:57 pm

    #1517587

    and for some reason if you do not get that information from default trace ( if default trace was not running) you can follow steps from the following URL to find the same information.

    http://www.sqlskills.com/BLOGS/PAUL/post/Finding-out-who-dropped-a-table-using-the-transaction-log.aspx

  • July 25, 2012 at 1:09 pm

    #1517591

    Vikrant S Patil (7/25/2012)

    and for some reason if you do not get that information from default trace ( if default trace was not running) you can follow steps from the following URL to find the same information.

    http://www.sqlskills.com/BLOGS/PAUL/post/Finding-out-who-dropped-a-table-using-the-transaction-log.aspx

    Using the [ url ]/[ /url ] IFCode shortcut (no spaces inside the square brackets) around a url makes it easy for others to check out the link without having to cut and paste the url.

    http://www.sqlskills.com/BLOGS/PAUL/post/Finding-out-who-dropped-a-table-using-the-transaction-log.aspx

  • July 25, 2012 at 9:14 pm

    This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply