Post reply

I cannot take full backup of sql server 2005 database because there are permission

  • August 6, 2012 at 6:10 pm

    #265328

    I have sql server 2005 connected to dynamic navision i try to take full backup today from sql but it display it doesnot have any permission to create backup and also i dont have sa user password and i cannot see data and i dont have any permission to create another user have admin rights and i canot see tables and data in database.last full backup 12/02/2010 and when i open navision it display data until today(06/08/2012 ) how i take full back up to sql database until today 06/08/2012 although there are permission in database sql server 2005 that display data in navision

    thanks

  • August 7, 2012 at 3:40 am

    #1522459

    Do you not know of anyone who has access to the SQL server as a db_owner of the database in question or db_backupoperator in the database in question, or a SysAdmin?

    If not, you will need to start SQL in single user mode, and create an account which has SA rights, then you can do what you need to do.

  • August 7, 2012 at 12:02 pm

    #1522764

    Hi Ahmed,

    Assuming the issue is with a single database,

    Please ask the DBA to add your login to db_backupoperator role which is existed on the database.

    Thanks,

    Mohammed

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

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