Home Forums SQL Server 2012 SQL 2012 - General How to create backup using Mdf and ldf files to another location RE: How to create backup using Mdf and ldf files to another location

  • May 28, 2017 at 11:14 pm

    #1944458

    poornima.s_pdi - Sunday, May 28, 2017 8:13 PM

    Yes I am taking Database offfline and detaching from DB then I copy MDF,LDF files and paste into another location.For eg) From C - drive to E-drive.

    Why?

    I created my Database  using  Sqlserver Authentication using 'sa'.
    But still the problem exists.

    Because the account under which SQL Server is running does not have permission to access files in that location.
    Don't put database files in the root folders of drives, and if you put the files in a new location, you'll have to give the account under which SQL Server is running permission to that location.

    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