Restoring database

  • Hello everybody.

    I'm trying to restore the database in SQL Server Management.

    By the way the following message is shown.

    Can you help me?

    you want to see the error screen and then click the following link.

    http://rapidshare.com/files/112916387/error.bmp.html

  • Link doesn't want to show. Please convert the image to jpg and attach it to a post here. Is much easier.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • boyfriend-alex (5/6/2008)


    Hello everybody.

    I'm trying to restore the database in SQL Server Management.

    By the way the following message is shown.

    Can you help me?

    you want to see the error screen and then click the following link.

    http://rapidshare.com/files/112916387/error.bmp.html%5B/quote%5D

    Alex,

    Make sure SQLService account has modify privilege to the path "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL". If not provide modify privilege to SQLService account and then try restoring the database.

    Hi GilaMonster,

    I've attached the picture.. Check it out!!

  • Thanks

    Yup, looks like a permissions problem. Just note, it's the SQL Server Service account that needs rights to that directory. Not the account that you are logged in as.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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