I encountered a problem when I installed SQL server 2005, Can anyone help?
There is a waring message in System configuration Check When I tried to install SQL server 2005:
Warning: SQL Server Edition Operating System Compatibility
Although I ignored the message and installed successfully, then I try to attach a existing database, i got this:
Failed to retrieve data for this request.( microsoft. SqlServer.SmoEnum)
Additional information:
An exception occurred while executing a Transact -SQL statement or batch.
( Microsoft.SqlServer.ConnectionInfo)
CREATE FILE encountered operating system error5(error not found) while attempting to open or create the physical file 'F:\Datases|Sqlserver\mydata.mdf'.( Microsoft SQL Server, Error: 5123)
then I tried to create a new database and restored data from a backup, I got error message said:
An exception occurred whtile executing a Transact - SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Additional information:
Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally.( Microsoft SQL server, Error: 3205)
Is anyone can help ? many thanks