Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
Course Of The Month
2 days, 6 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
OS admin can't backup
Posted on 2011-03-08
The service account (SQL) is a OS admin, but that does not allow it to do backup? the error message is
--------------------
Msg 916, Level 14, State 1, Line 2
The server principal "SRBSV\POSRESTEST" is not able to access the database "TRACKER" under the current security context.
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
-------------------
being a OS admin - does it give any privilege in SQL Server?
what permission will this service account need to be able to do backup/restore?
--------------------
Msg 916, Level 14, State 1, Line 2
The server principal "SRBSV\POSRESTEST" is not able to access the database "TRACKER" under the current security context.
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
-------------------
being a OS admin - does it give any privilege in SQL Server?
what permission will this service account need to be able to do backup/restore?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
- +3
7 Comments
Active today
OS Admin and SQL Admin are two very different things....
Why don't you place into the db_backupoperator role. See Dataabase-Level Roles in BOL:
db_backupoperator
Members of the db_backupoperator fixed database role can back up the database.
Why don't you place into the db_backupoperator role. See Dataabase-Level Roles in BOL:
db_backupoperator
Members of the db_backupoperator fixed database role can back up the database.
from sql 2008 builtin\admin is no longer automatically given access ...
You have to decide who and what requires access and grant them the appropiate priveleges...
You have to decide who and what requires access and grant them the appropiate priveleges...
db_backupoperator will let you backup a database and T-log sp_dbfixedrolepermission to see all rights in the database
but for restore you need more so that account needs to be at least server role - 'dbcreator'
you can check permissions for that by running
EXEC sp_srvrolepermission 'dbcreator';
but for restore you need more so that account needs to be at least server role - 'dbcreator'
you can check permissions for that by running
EXEC sp_srvrolepermission 'dbcreator';
It's kind of odd they did it like this and other than sysadmin there's not a single role that gives backup/restore capabilities but if you grant the two - db_backupoperator at db level and dbcreator at server level to that NT user starting your SQL SErver Sevrice then you have minimum granted rights. Other than that you could use sysadmin sql server fixed role.
Featured Post
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses
Course of the Month2 days, 6 hours left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.