SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
ahmed_elbarbary.2010
ahmed_elbarbary.2010
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1120 Visits: 230
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
anthony.green
anthony.green
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63396 Visits: 8598
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.



How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Mohammedr_mcts
Mohammedr_mcts
SSC-Enthusiastic
SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)

Group: General Forum Members
Points: 106 Visits: 446
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search