Re: just wondering about MSKB 828481
From: Steve Foster [SBS MVP] (steve.foster_at_picamar.co.uk)
Date: 09/16/04
- Next message: dognosh: "new to SBS 2003"
- Previous message: Steve Foxon: "Back Up Fails with SBS 2003"
- In reply to: SuperGumby [SBS MVP]: "Re: just wondering about MSKB 828481"
- Next in thread: SuperGumby [SBS MVP]: "Re: just wondering about MSKB 828481"
- Reply: SuperGumby [SBS MVP]: "Re: just wondering about MSKB 828481"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 16 Sep 2004 01:16:11 -0700
SuperGumby [SBS MVP] wrote:
> The package accessing the database is supplied by a third party. An
> available function, the ability to rollback the database to a
> particular point, seems to depend on the database being in other than
> simple recovery mode. If I can patch and retain the recovery mode and
> rollback I'll be OK.
>
> and despite the fact that their implementation has broken my backup
> I'm going to try not to break their database.
SQL Server doesn't, AFAIK, offer any native method for unravelling
data, other than by using an older backup and restoring it. The SQL
Transaction logs are there so that you can roll forward from a previous
backup when doing DR. SQL does allow some control over the roll forward
process, but I doubt that an application would be using this
methodology to provide user rollback capabilities (I'd have thought it
too unwieldy).
-- Steve Foster [SBS MVP] --------------------------------------- MVPs do not work for Microsoft. Please reply only to the newsgroups.
- Next message: dognosh: "new to SBS 2003"
- Previous message: Steve Foxon: "Back Up Fails with SBS 2003"
- In reply to: SuperGumby [SBS MVP]: "Re: just wondering about MSKB 828481"
- Next in thread: SuperGumby [SBS MVP]: "Re: just wondering about MSKB 828481"
- Reply: SuperGumby [SBS MVP]: "Re: just wondering about MSKB 828481"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|