Home Forums SQL Server 2005 SQL Server 2005 Security I cannot take full backup of sql server 2005 database because there are permission RE: I cannot take full backup of sql server 2005 database because there are permission

  • 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.