Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Killing users before restore

    Actually, in this case, I would just fire up the Lumigent Log Explorer, locate the 'awry update' and simply undo it..

    This assumes you have full transaction logs and lumigent,...

  • RE: Killing users before restore

    here's a script i've used for quite a while...

    ------------------------

    USE master

    go

    ALTER DATABASE yourdatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    RESTORE DATABASE yourdatabase

    FROM DISK = 'c:\path\filename'

    with replace

    ALTER DATABASE yourdatabase SET MULTI_USER

    go

    ------------------------

    I generally run...

Viewing 2 posts - 1 through 2 (of 2 total)