[dba-Tech] Restore Question

artful at rogers.com artful at rogers.com
Thu Feb 22 11:38:19 CST 2007


I think you can do what you want, yes. Just hoping that you can step through the backups starting just before anyone noticed data was going missing.

 
Arthur Fuller
Technical Writer, Data Modeler, SQL Sensei
Artful Databases Organization
www.artfulsoftware.com




----- Original Message ----
From: "Tesiny, Ed" <EdTesiny at oasas.state.ny.us>
To: dba-ot at databaseadvisors.com; Discussion of Hardware and Software issues <dba-tech at databaseadvisors.com>
Sent: Thursday, February 22, 2007 10:51:25 AM
Subject: [dba-Tech] Restore Question


I hope I can explain this so it makes sense.  I had an application built
to capture data on clients who are utilizing high cost Medicaid
services.  Case managers enter direct services (services provided by the
case manager) and referrals for services provided by other entities.
The back end of the application is Sql Server 2000.  The front end, Cold
Fusion and Java Script.  The system went live January 4.  Case managers
(CM) were entering services and were finding that some were disappearing
from the system.  So we brought the problem to the programmer.  When a
CM looked at a screen that summarized what direct services and referrals
were provided to a client, there was a delete "button" for direct
services.  If a CM entered a service say psychosocial assessment and
then decided it was a mistake and deleted it, it deleted ALL occurrences
of psychosocial assessments across all CMs, basically it deleted all
instances of psychological assessments in the entire system.  Nice
programming, eh.  He says that 476 services were deleted but he can't
tell which ones, don't ask he can't explain.  He claims he can restore
195 services, that's it.  The system is backed up every hour.  He's
taken this as far as he can and he's also the Sql Administrator.

Here's the question.  If I could get a copy of the services table that
is in production now and then get the back up services tables.  Bring
them into MS Access and do a series of queries, match the production
table against the last back up and append unmatched services from the
back up to the production table...then take the previous back up and
match again and append.  Does this make any sense?
MTIA
Ed

Edward P. Tesiny
Assistant Director for Evaluation
Bureau of Evaluation and Practice Improvement
New York State OASAS
1450 Western Ave.
Albany, New York  12203-3526
Phone:  (518) 485-7189
Fax:  (518) 485-5769
Email: EdTesiny at oasas.state.ny.us

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com


More information about the dba-Tech mailing list