Re: just wondering about MSKB 828481

From: Steve Foster [SBS MVP] (steve.foster_at_picamar.co.uk)
Date: 09/16/04


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.


Relevant Pages

  • Re: SBS Team HELP PLEASE bug!?!
    ... Javier [SBS MVP] ... > Unable to connect to the database STS_Config when trying to received ... Our SQL is located on a SQL farm. ... > The Fax Service failed to execute a specific routing method. ...
    (microsoft.public.windows.server.sbs)
  • Re: sharepoint crashed, along with most of the server
    ... Les Connor [SBS MVP] ... 'MSSQL$Sharepoint instance is not using SQL 2000 SP 4' not sure yet how to ... > Companyweb and Sharepoint and Exchange of course were non functional. ... > MSDE in a database? ...
    (microsoft.public.windows.server.sbs)
  • Re: just wondering about MSKB 828481
    ... The package accessing the database is supplied by a third party. ... If I can patch and retain the recovery mode and rollback I'll be OK. ... > Steve Foster [SBS MVP] ...
    (microsoft.public.windows.server.sbs)
  • Testing Environment + TestData + QA Setup
    ... Database is SQL 2005 and Front End is in C# ... One way to achieve this would be DROP THE DATABASE and RESTORE THE PREVIOUS ... Another approach to this would be to write .sql scripts which delete the ... DELETE, then depending on the entry in the history table, we can rollback ...
    (microsoft.public.sqlserver.dts)
  • Re: SBS2003 and SQL
    ... I used the osql -U sa command to verify sql login. ... >Chad A. Gross - SBS MVP ... The database works fine except ...
    (microsoft.public.windows.server.sbs)