Post reply

Error restoring Filestream enabled database

  • March 27, 2012 at 7:23 am

    #258315

    Using SQL Server 2008R2 enterprise ed, 64bit instance on Windows Server 2008 R2 enterprise, 16Gb memory.

    This has Sharepoint installed. We enabled three of our content databases for Filestream.

    The other day we switched 2 drives by renaming them. So all paths should look the same.

    Our goal was to get the blob data onto a bigger drive. And we rebooted the server.

    Now the first filestream database is ok , but the other two are not. They are in Recovery Pending state.

    I tried bringing them online using ALTER DATABASE WSS_Content_sphr SET ONLINE but got this:

    Msg 5120, Level 16, State 106, Line 1

    Unable to open the physical file "U:\RBSDataStore_hr". Operating system error -1073741790: "0xc0000022(failed to retrieve text for this error. Reason: 317)".

    Msg 5105, Level 16, State 14, Line 1

    A file activation error occurred. The physical file name 'U:\RBSDataStore_hr' may be incorrect. Diagnose and correct additional errors, and retry the operation.

    Msg 945, Level 14, State 2, Line 1

    Database 'WSS_Content_sphr' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

    Msg 5069, Level 16, State 1, Line 1

    ALTER DATABASE statement failed.

    The file U:\RBSDataStore_hr does exist. Both the login that is running the command and the account that SQLSERVER runs as are administrators on the server.

    I also tried restoring one of the databases using:

    use master

    go

    restore FILELISTONLY

    from disk = N'c:\temp\WSS_Content_spapp_backup_2012_03_23_190002_2530589.bak'

    go

    restore database WSS_Content_spapp

    from disk = N'c:\temp\WSS_Content_spapp_backup_2012_03_23_190002_2530589.bak'

    with recovery, file = 1

    go

    But got errors:

    Msg 3634, Level 16, State 1, Line 1

    The operating system returned the error '5(Access is denied.)' while attempting 'RemoveContainer' on 'U:'.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    This is the first time I've used Filestream so I'm at a loss here. There is plenty of dispspace and memory.

    I really appreciate any help with this.

    Thanks.

  • March 27, 2012 at 10:06 am

    #1465104

    I had the server administrator increase permissions on the U drive and everything worked. I was able to bring database online and restore the other.

    Thanks anyway, and maybe this will help someone else.

  • March 27, 2012 at 10:33 am

    #1465134

    Denise McMillan (3/27/2012)

    I had the server administrator increase permissions on the U drive and everything worked. I was able to bring database online and restore the other.

    Thanks anyway, and maybe this will help someone else.

    Denise,

    Thanks for posting the solution. Could you please answer below queries.

    1) What permissions you initially had on the U drive

    2) What permission was eventually granted to you

    Thanks

    M&M

  • March 27, 2012 at 10:42 am

    #1465144

    The account that I was logged in as and the account that SQLService runs as did not have any permission to files on the U drive. Our SA added them full access to the files. They had been ok before the drive name switch. So all path information was ok but access went along with the different underlying drives.

  • March 27, 2012 at 10:50 am

    #1465158

    Thank you Denise.

    M&M

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply