I cannot take sql full backup to see all data because permis

ahmedbaahmedba Member Posts: 424
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

Comments

  • strykstryk Member Posts: 645
    Well, it is a matter of security that NOT EVERYONE could easily create backups! So please contact the system-administrator to give you permission to create such a backup, e.g. by assigning the "db_backupoperator" database role to you.
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
Sign In or Register to comment.