Will I get the bakup file on drive or will I get error?

Question

Will I get the bakup file on drive or will I get error?

forsqlserver

SSCoach

Points: 18902
More actions
April 18, 2011 at 6:59 am

#235800

:cool:I have one confusion:
I have a windows user 'USER' who has not the write permission on disks.
I have logged in using that user and open the SSMS.in SSMS I have logged in as 'sa' and run the back up command.
Will I get the bakup file on drive or will I get error and Why?
Thanks

Viewing 10 posts - 1 through 9 (of 9 total)

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

As long as the SQL Server service account had write permissions on the directory you should get a proper backup. A user logs into SQL Server and then any actions that take place outside the context of SQL Server use the SQL Server service account credentials, not the user's credentials.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

forsqlserver SSCoach Points: 18902 More actions · Answer 2

SQL Server service account had write permissions on the directory you should get a proper backup

Please throw some more light,How will I check that either sql user has what permissions on hard disk drives.

Thanks

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

First, backing up to the network is not recommended. You usually want to back up locally and then copy to the network.

Second, permissions on a drive/folder is a Windows function, not a SQL one. You would need to check in Active Directory or on the folder itself that the SQL Server service account, or a group in which it is a member, has permissions

forsqlserver SSCoach Points: 18902 More actions · Answer 4

Thanx..

But in AD only Windows login will display,How Will I check the permission of a SQL Login?

Please more clear it...

Thanks

Warwick Rudd Ten Centuries Points: 1240 More actions · Answer 5

A SQL Server account is exactly that. It only has permissions inside the instance of SQL Server. The account may be given permissions to perform backing up a database. As stated previously this will use the Service account the instance is running under and place the backup in the default backup location if performing the backup via SSMS or to a specific location if you are running the TSQL commands, as long as AD permissions are in place.

MCT
MCITP Database Admin 2008
MCITP Database Admin 2008
MCITP Database Dev 2008
www.jnrit.com.au/Blog.aspx

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 6

Right click the folder, properties, select security. Look for the account or a group.

http://technet.microsoft.com/en-us/library/cc757520%28WS.10%29.aspx

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 7

check the SQL Server service account should have rights to do this and if you are using SQL Server agent job to taking a backup then you should check the SQL Server agent job service account also for the rights

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

My Blog
www.aureus-salah.com

forsqlserver SSCoach Points: 18902 More actions · Answer 8

Dear Syed,

U mean to say,

If We are taking a backup from Query Editor then the service account of SQL Server Service is impersonate.

If a Job is taking a backup then service account of SQL Server Agent is impersonate.

If from SSIS backup is taking then service account of SSIS is impersonate.

Correct?

Thanks

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 9

SSIS typically runs as a job under Agent.

If an Agent job issues a BACKUP DATABASE, it is no different than if you issue it from SSMS. SQL Server still performs the backup.