Tema: Re: Padekit del SQL
Autorius: PxYra
Data: 2011-07-26 15:23:38
microsoft grupse klausk
"Night" <vkumpikas_@gmail.com> parase naujienu 
news:j0kdja$tcu$1@trimpas.omnitel.net...
> Viena duombaze, kuri laika nenaudota, bandau priattachint - gaunu sekancia 
> klaida... Atrodo, kazkas nesutampa mdf ir ldf failuose. Prisiskaiciau 
> cisokiu sprendimu internete, pagrinde kaip sukurti nauja log faila, 
> sukuriau, priattachinau - truksta gero gabalo duomenu, naturalu, truksta 
> tu - kurie buvo tame log faile. Gal kas zinot koki stebuklinga buda, kaip 
> tuos failus "sutaisyti"?
>
>
> TITLE: Microsoft SQL Server Management Studio Express
> ------------------------------
>
> Attach database failed for Server 'xxx-SRV\SQLEXPRESS'. 
> (Microsoft.SqlServer.Express.Smo)
>
> For help, click: 
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> An exception occurred while executing a Transact-SQL statement or batch. 
> (Microsoft.SqlServer.Express.ConnectionInfo)
>
> ------------------------------
>
> The log scan number (1297:459:2) passed to log scan in database 'yyy' is 
> not valid. This error may indicate data corruption or that the log file 
> (.ldf) does not match the data file (.mdf). If this error occurred during 
> replication, re-create the publication. Otherwise, restore from backup if 
> the problem results in a failure during startup.
> Could not open new database 'yyy'. CREATE DATABASE is aborted. (Microsoft 
> SQL Server, Error: 9003)
>
> For help, click: 
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=9003&LinkId=20476
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>