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