|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Access 97 / VBA Users...She sent 7800 records into an external "black-box" system -- records whose status wee need to track. And then she deleted them from SQL Server. Now she's talking to one of our C# guys about using a hex editor to crack the LDF file format to extract the records that were deleted and restore them. PLEASE have more intelligent suggestions? Anyone who's an MCDBA will recall the MOC 2072 course in database administration. As a former MCT, I still have the CD for that course, if anyone has a chapter or lesson for me to refer to? -- Peace & happy computing, Mike Labosh, MCSD "When you kill a man, you're a murderer. Kill many, and you're a conqueror. Kill them all and you're a god." -- Dave Mustane Sounds like the DBA needs to be a bit more stingy with the access
permissions and management needs to spend a bit more time peering over their shoulders. Show quote "Mike Labosh" <mlab***@hotmail.com> wrote in message news:O9sXfhcxFHA.916@TK2MSFTNGP10.phx.gbl... > ...should NEVER be allowed to touch EM, no matter how much T-SQL they > know. > > She sent 7800 records into an external "black-box" system -- records whose > status wee need to track. > > And then she deleted them from SQL Server. Now she's talking to one of > our C# guys about using a hex editor to crack the LDF file format to > extract the records that were deleted and restore them. > > PLEASE have more intelligent suggestions? > > Anyone who's an MCDBA will recall the MOC 2072 course in database > administration. As a former MCT, I still have the CD for that course, if > anyone has a chapter or lesson for me to refer to? > > -- > Peace & happy computing, > > Mike Labosh, MCSD > > "When you kill a man, you're a murderer. > Kill many, and you're a conqueror. > Kill them all and you're a god." -- Dave Mustane > > Sounds like the DBA needs to be a bit more stingy with the access HAH! What DBA?!? Why do you think me, a developer is on this group so > permissions and management needs to spend a bit more time peering over > their shoulders. much??! I'm just an MCSD code monkey, and I'm probably the one here that's most qualified as a DBA. Did that send a shiver up your spine? -- Peace & happy computing, Mike Labosh, MCSD "When you kill a man, you're a murderer. Kill many, and you're a conqueror. Kill them all and you're a god." -- Dave Mustane Mike,
The MS-2072 curriculum is not going to help. If she could delete the records in EM then she could do it in any app. So it is more of a permissions issue here. A fix...POINT IN TIME recoverability using the transaction log. Or possibly one of the third-party log exploring tools (could help minimize data loss after the DELETE occured). HTH Jerry Show quote "Mike Labosh" <mlab***@hotmail.com> wrote in message news:OHOXzDdxFHA.720@TK2MSFTNGP15.phx.gbl... >> Sounds like the DBA needs to be a bit more stingy with the access >> permissions and management needs to spend a bit more time peering over >> their shoulders. > > HAH! What DBA?!? Why do you think me, a developer is on this group so > much??! I'm just an MCSD code monkey, and I'm probably the one here > that's most qualified as a DBA. > > Did that send a shiver up your spine? > -- > Peace & happy computing, > > Mike Labosh, MCSD > > "When you kill a man, you're a murderer. > Kill many, and you're a conqueror. > Kill them all and you're a god." -- Dave Mustane > > A fix...POINT IN TIME recoverability using the transaction log. Or Yes, that's precisely what I'm looking for. I just found it at Module 7, > possibly one of the third-party log exploring tools (could help minimize > data loss after the DELETE occured). page 20. -- Peace & happy computing, Mike Labosh, MCSD "When you kill a man, you're a murderer. Kill many, and you're a conqueror. Kill them all and you're a god." -- Dave Mustane All good software engineers start out as common code monkeys but eventually
evolve into a DBA. Show quote "Mike Labosh" <mlab***@hotmail.com> wrote in message news:OHOXzDdxFHA.720@TK2MSFTNGP15.phx.gbl... >> Sounds like the DBA needs to be a bit more stingy with the access >> permissions and management needs to spend a bit more time peering over >> their shoulders. > > HAH! What DBA?!? Why do you think me, a developer is on this group so > much??! I'm just an MCSD code monkey, and I'm probably the one here > that's most qualified as a DBA. > > Did that send a shiver up your spine? > -- > Peace & happy computing, > > Mike Labosh, MCSD > > "When you kill a man, you're a murderer. > Kill many, and you're a conqueror. > Kill them all and you're a god." -- Dave Mustane > Some thoughts here... http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Mike Labosh" <mlab***@hotmail.com> wrote in message news:O9sXfhcxFHA.916@TK2MSFTNGP10.phx.gbl... > ...should NEVER be allowed to touch EM, no matter how much T-SQL they know. > > She sent 7800 records into an external "black-box" system -- records whose > status wee need to track. > > And then she deleted them from SQL Server. Now she's talking to one of our > C# guys about using a hex editor to crack the LDF file format to extract the > records that were deleted and restore them. > > PLEASE have more intelligent suggestions? > > Anyone who's an MCDBA will recall the MOC 2072 course in database > administration. As a former MCT, I still have the CD for that course, if > anyone has a chapter or lesson for me to refer to? > > -- > Peace & happy computing, > > Mike Labosh, MCSD > > "When you kill a man, you're a murderer. > Kill many, and you're a conqueror. > Kill them all and you're a god." -- Dave Mustane > >  |
|||||||||||||||||||||||
Other interesting topics