Connecting Tech Pros Worldwide Forums | Help | Site Map

Install SQL server 2005

Newbie
 
Join Date: Nov 2008
Posts: 3
#1: Nov 28 '08
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

Reply