Shulou(Shulou.com)05/31 Report--

This article shows you how to solve the 5118 error in the SQL Server 2000 database. The content is concise and easy to understand, and it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

1. Error message:

Attach failed for server "192.168.0.121". (Microsoft.SqlServer.Smo)

For help, click:?

ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.

SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText

& EvtID= additional database + Server&LinkId=20476

-

Additional information:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne

CtionInfo)

-

The file "G:DataTrafficCollege_Data.MDF" is compressed but does not reside in a read-only database or

In the filegroup. This file must be extracted. Unable to open new database TrafficCollege. CREA

TE DATABASE aborted. (Microsoft SQL Server, error: 5118) help information

Click: &

ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=5118&LinkId=20476

Second, Microsoft's explanation

Details

ID:

5118

Source:

MSSQLServer

Were sorry

There is no additional information about this issue in the Error and Event Log

Messages or Knowledge Base databases at this time. You can use the links in

The Support area to determine whether any additional information might be

Available elsewhere.

Third, the reason

The logical hard drive where your database files are located chose "compress the drive to save disk space."

And 2005 can't recognize compressed files. At this point, Microsoft says Were sorry I.

I don't complain at all.

IV. Solutions

Test the file on a logical hard disk that does not have a compressed disk, or put the compressed attribute of the logical hard disk

Get rid of sex.

5. Tips

&

ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=5118&LinkId=20476

See 5118 of them? that's your error code. I'll encounter an error later.

Replace this code and you can find Microsoft's standard explanation.

The above content is how to solve the database 5118 error of SQL Server 2000 Compact 2005. have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.