• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

Missing Table

I have a missing table in the database, I would like to know if I can see when it was deleted. How can I view transaction log? Is there any way to recreate it, roll back the transaction?

thanks
0
pfslink
Asked:
pfslink
  • 3
  • 2
1 Solution
 
obahatCommented:
You can restore your latest backup + transaction logs onto another DB and see whether the table is there.
Generally, unless you have auditing turned on, there is no way (that I am familiar with) of telling when the table was dropped.
0
 
pfslinkAuthor Commented:
how would you know if auditing is turned on?
0
 
pfslinkAuthor Commented:
and how would you restore the transaction logs?
0
 
obahatCommented:
Gimme a sec... looking for the script that does that...
0
 
obahatCommented:
RESTORE DATABASE [<DBName>]
FROM
DISK = "<Path>\<FileName>.BAK"
WITH  FILE = 1,  NOUNLOAD ,  STATS = <Value>,  NORECOVERY
GO

RESTORE LOG [<DBName>]
FROM DISK = "<Path>\<FileName>.TRN"
WITH  FILE = 1,  NOUNLOAD ,  STATS = <Value>,  RECOVERY
GO

You can read more about this in the books online, under the RESTORE command.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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