Re: Mystery Table Delete!
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 06/25/04
- Next message: Wayne Snyder: "Re: Moving databases between servers"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Mystery Table Delete!"
- In reply to: Pegasus: "Mystery Table Delete!"
- Next in thread: Pegasus: "Mystery Table Delete!"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Jun 2004 08:16:13 -0400
Probably the best way to see might be to get the tool from Lumigent (
www.lumigent.com)...
Give them a call and see if the tool will help in your situation.
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "Pegasus" <anonymous@discussions.microsoft.com> wrote in message news:212c301c45a9e$73c9e3c0$a301280a@phx.gbl... > I'm hoping someone out there can help me solve a mystery! > > 29 tables in our live database were deleted the other day > and we've no real idea how this could have happened. > > We have found an entry in Application Event Viewer that > happened at about the same time as the tables vanished, > but we don't really understand what it means: > EventID: 17055 > Categorey: (6) > Description: 3041: BACKUP failed to complete the command > dump tran [Claims] with no_log > > I understand that this is saying that the command failed, > but where did the command come from? The user on the > event was creating new tables and replacing stored > procedures in the database at the time, however, [Claims] > is the name of the whole database! > > We have recovered from the disaster now but really do need > to understand what has happened here, how it happened, and > how we can ensure it never happens again in the future. > > Thanks in advance for any help. > > Regards > > Paula
- Next message: Wayne Snyder: "Re: Moving databases between servers"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Mystery Table Delete!"
- In reply to: Pegasus: "Mystery Table Delete!"
- Next in thread: Pegasus: "Mystery Table Delete!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
