Re: just wondering about MSKB 828481

From: SuperGumby [SBS MVP] (not_at_your.nellie)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 10:49:56 +1000

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. 

-- 
Mick Malloy
http://www.micropol.com.au
"Steve Foster [SBS MVP]" <steve.foster@picamar.co.uk> wrote in message 
news:xn0dnau692p0jn300x@msnews.microsoft.com...
> SuperGumby [SBS MVP] wrote:
>
>> Error 800423f4 appears in the backup log file when you back up a
>> volume by using the Volume Shadow Copy service in Windows Server 2003
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;828481
>>
>> anyone done this to SBS2k3 please?
>
> So far, switching all the SQL databases to simple recovery has
> eliminated the problem for me, without requiring the hotfix.
>
> -- 
> Steve Foster [SBS MVP]
> ---------------------------------------
> MVPs do not work for Microsoft. Please reply only to the newsgroups.

Relevant Pages

  • Re: recovery from a delete statement
    ... >found out it was the wrong database. ... You can't rollback after committing the transaction. ... point in time recovery to restore yoour database to the point in time just ...
    (microsoft.public.sqlserver.programming)
  • Re: Fast roll-back
    ... locked will stay locked until the entire rollback is complete. ... If the session is killed or the database is restarted (before ... This means that killing a session (or in your extreme case bouncing ... The Co-operative Oracle Users' FAQ ...
    (comp.databases.oracle.server)
  • Re: just wondering about MSKB 828481
    ... seems to depend on the database being in other than ... > rollback I'll be OK. ... SQL Server doesn't, AFAIK, offer any native method for unravelling ... Steve Foster [SBS MVP] ...
    (microsoft.public.windows.server.sbs)
  • Re: How to transactionally update a DB Schema?
    ... You can execute DDL as part of an explicit transaction so that you can ... rollback in the case of an error. ... database prior the upgrade and restore if an error is encountered. ...
    (microsoft.public.sqlserver.server)
  • Re: ROLLBACK a transaction
    ... execute your select query, but it would ignore all non-committed records as ... > I'm reading records from one database to another database, ... We have to do a rollback of all the ... > Is there a solution for this whitout changing the select to "......with ...
    (microsoft.public.sqlserver.programming)