Post reply

backup -- Restore

  • January 30, 2013 at 11:01 am

    #273471

    Hi Experts

    I am trying to take back to adventureworks but something new happend an error says user has no permission

    what should I do ?

    I am trying to make restore but when I choose the bak file an error says "no backup set to restore" there are no mdfs or ldfs

    what should I do

    Thanks lot

  • January 30, 2013 at 11:33 am

    #1582681

    How are you trying to take a backup?

    What's the exact errors?

    Where did the .bak file come from?

    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

  • January 30, 2013 at 11:42 am

    #1582683

    thanks

    I am making backup from SSMS -- dbtasks and the error says user hasno permission to perform this action

    The restore file located on the same harddesk, but there is no mdf or ldf, I made restore from the same file before"what happend"

    Thanks

  • January 30, 2013 at 12:37 pm

    #1582691

    Then ask your DBA to give you permissions to take backups.

    Don't understand about the restore. Backup files don't have mdfs and ldfs.

    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

  • January 30, 2013 at 12:48 pm

    #1582694

    are you taking a backup or trying to restore? if you are restoring you should not use mdf or ldf, only use .bak files or 3rd party vendor backups. Can you tell me your steps in detail?

    MCSE SQL Server 2012\2014\2016

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

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