October 17, 2013 at 8:15 am
A SQL Server instance was restarted and one database did not come back online. The error message below is in the log. I look in the data folder and see an APP01_Record.mdf data file but the error message points to 'APP01_Record.APP01_Record_Image' which is a folder.
Still learning on SQL Server and I'm not understanding why it is pointing to this image folder. Is there something special about this database?
A file activation error occurred. The physical file name 'T:\MSSQL10_50.APP01\MSSQL\DATA\APP01_Record.APP01_Record_Image' may be incorrect. Diagnose and correct additional errors, and retry the operation.
October 17, 2013 at 8:58 am
What are the exact errors in the SQL Server error log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2013 at 9:09 am
GilaMonster (10/17/2013)
What are the exact errors in the SQL Server error log?
This is the only message in the error log. I brought the database offline. Tried to bring it online and it still gives the same message.
"A file activation error occurred. The physical file name 'T:\MSSQL10_50.APP01\MSSQL\DATA\APP01_Record.APP01_Record_Image' may be incorrect. Diagnose and correct additional errors, and retry the operation."
I noticed under this folder T:\MSSQL10_50.APP01\MSSQL\DATA\APP01_Record.APP01_Record_Image there is another directory $FSLOG.
October 17, 2013 at 9:25 am
You have filestream enabled.
Filestream has a separate filegroup for its data and there will be a file or two in this filegroup that are actually pointing to files. These need to exist, just like the files for mdf/ndf files in filegroups need to exist.
Either you lost this folder or have a permissions change that prevented access. This needs to be corrected.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 17, 2013 at 4:16 pm
Also, you need to review the SQL log from when the error first occurred. Sometimes when errors occur SQL gets stopped and restarted, which causes a log switch. But for the full error info, you need to see the log that was active when the error actually originated.
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
March 22, 2021 at 8:17 pm
One other reason this can happen is if you have the data folder on the root of a drive (i.e. a drive used exclusively for MDF files).
For example, if we had the data drive defaulting to D:\, it may show this as the MDF file when restoring the database:
D:DBName.mdf
You may have noticed a missing backslash. which can throw the activation error. Though this is purely SSMS creating an invalid restore script, the solution is to either script the restore manually or click the "Relocate All Files To Folder" checkbox and in the Data option add the backslash after "D:", so it reads:
D:\ <-- add the missing backslash
Just in case anyone else has this issue, this will hopefully save you hours of troubleshooting if you come across this article while googling for an answer.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply