Unable to Restore MDF file in Vista
-
hi I want to restore mdf file in my sqlserver database. i am using: EXEC sp_attach_single_file_db @dbname = 'testerDB', @physname = 'F:\DB.mdf' to restore that mdf file but it gives the error: ERROR: ERROR: Unable to open the physical file "F:\DB.mdf". Operating system error 5: "5(Access is denied.)". I am working with SQL Server 2005 express edition and Os is Vista Ultimate. Please Help Thanks in advance
-
hi I want to restore mdf file in my sqlserver database. i am using: EXEC sp_attach_single_file_db @dbname = 'testerDB', @physname = 'F:\DB.mdf' to restore that mdf file but it gives the error: ERROR: ERROR: Unable to open the physical file "F:\DB.mdf". Operating system error 5: "5(Access is denied.)". I am working with SQL Server 2005 express edition and Os is Vista Ultimate. Please Help Thanks in advance
There are about 1.2^10 reasons why this would occur and none of them have anyting to with your OS being Vista.
“If you think you are worth what you know, you are very wrong. Your knowledge today does not have much value beyond a couple of years. Your value is what you can learn and how easily you can adapt to the changes this profession brings so often.”-– Jose M. Aguilar
-
There are about 1.2^10 reasons why this would occur and none of them have anyting to with your OS being Vista.
“If you think you are worth what you know, you are very wrong. Your knowledge today does not have much value beyond a couple of years. Your value is what you can learn and how easily you can adapt to the changes this profession brings so often.”-– Jose M. Aguilar
-
hi I want to restore mdf file in my sqlserver database. i am using: EXEC sp_attach_single_file_db @dbname = 'testerDB', @physname = 'F:\DB.mdf' to restore that mdf file but it gives the error: ERROR: ERROR: Unable to open the physical file "F:\DB.mdf". Operating system error 5: "5(Access is denied.)". I am working with SQL Server 2005 express edition and Os is Vista Ultimate. Please Help Thanks in advance
A file that ends in ".mdf" is a database, not a backup. You can restore backups (*.bak), but not the "*.mdf". You can, however, attach the database to your local server by right-clicking on the "databases"-node and choosing "attach" from the SQL Server Management Studio. Good luck with your venture :)
-
Ok, smarty pants, see Eddy's post to understand why your problem had absolutely nothing to do with the OS you are using.
“If you think you are worth what you know, you are very wrong. Your knowledge today does not have much value beyond a couple of years. Your value is what you can learn and how easily you can adapt to the changes this profession brings so often.”-– Jose M. Aguilar