Welcome to Sign in | Help

Re: update neglijent.

  •  10-16-2006, 5:32 PM

    Re: update neglijent.

    Sau aici: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_0cvi.asp

    Din discutiile offline am inteles ca aveti un full backup si atat iar problema a avut loc la 15:58. In acest caz faceti backup la transaction log conform descrierii de mai sus iar pe urma rulati:

    RESTORE DATABASE myDB FROM DISK='C:\fisierfullbackup.bak' WITH NO RECOVERY
    RESTORE LOG MyDB FROM DISK='C:\log.bak' WITH RECOVERY STOPAT = '2006/10/16 15:57:00'


    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems