none
ERRO Atach DataBase - "WARNING: did not see LOP_CKPT_END" RRS feed

  • Pergunta

  • Bom Dia

     

    Alguém sabe como corrigir um arquivo “mdf” SQL. Preciso “atachar” o arquivo e esta dando o seguinte erro.

     

     

    DML

    USE [master]

    GO

    CREATE DATABASE [Cota] ON

    ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Cota.mdf' ),

    ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Cota.ldf' )

     FOR ATTACH

    GO

    if exists (select name from master.sys.databases sd where name = N'Cota' and SUSER_SNAME(sd.owner_sid) = SUSER_SNAME() ) EXEC [Cota].dbo.sp_changedbowner @loginame=N'caldas', @map=false

    GO

     

    Erro

    Msg 1813, Level 16, State 2, Line 1

    Could not open new database 'Cota'. CREATE DATABASE is aborted.

    Msg 3414, Level 21, State 2, Line 1

    An error occurred during recovery, preventing the database 'Cota' (database ID 17) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

     

     

     

    Log Do Sql

     

    05/20/2010 08:23:32,spid52,Unknown,An error occurred during recovery<c/> preventing the database 'Cota' (database ID 17) from restarting. Diagnose the recovery errors and fix them<c/> or restore from a known good backup. If errors are not corrected or expected<c/> contact Technical Support.

    05/20/2010 08:23:32,spid52,Unknown,Error: 3414<c/> Severity: 21<c/> State: 2.

    05/20/2010 08:23:32,spid52,Unknown,WARNING: did not see LOP_CKPT_END.

    Att.

    Caldas

    • Movido Gustavo Maia Aguiar quinta-feira, 20 de maio de 2010 12:31 (De:SQL Server - Desenvolvimento Geral)
    quinta-feira, 20 de maio de 2010 11:57

Respostas