<< An explicit value for the identity column in table '' can only be specified when a column list is used and IDENTITY_INSERT is ON | SQL Server - Add multiple email addresses for an operator >>

Attach Database Error Unable to open the physical file Operating system error

by Administrator 2. November 2009 23:56

This one caused a bit of a panic I can tell you! We had major trouble reattaching a very large database file. We kept getting the error below (Running SQL 2008 on Windows 7):

Unable to open the physical file Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". (Microsoft SQL Server, Error: 5

This occured both when using the Management Console and if running the stored procedures 'sp_attach_db' and 'sp_attach_single_file_db'

Solution

Not sure if there is a 'better' way of doing this but we found that connecting using 'sa' and attaching the database as normal solved the problem

Tags:

SQL Server Errors

SQL Server - Force Database Log File ShrinkHandy script to force the log file to shrinkIntermittent error using DirectoryServices (The directory service is unavailable)If you're putting heavy load on your AD server using DirectoryServices you may find you get intermit...SQL Server - Move TempDb Log File[code:tsql] ALTER DATABASE TempDB MODIFY FILE(NAME = templog, FILENAME = 't:\templog.ldf') [/code]...

Buy Me a Beer ?

If you've found this site useful, you could help support its running costs by either checking out the adverts on the page if you find anything that interests you - or by making a small donation

Blog Entries

Useful Web Pages

Attach Database Error Unable to open the physical file Operating system error

Solution