July 25, 2012 at 2:07 am
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
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
How can i check what went wrong in the database because user tables are missing.
July 25, 2012 at 2:35 am
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
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
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
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
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
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
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.
July 25, 2012 at 1:09 pm
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.
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.
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy