SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Back up Database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

56 Posts

Posted - 05/06/2014 :  18:04:50  Show Profile  Reply with Quote

I want to back up a database, usually i use the following script and it works.

TO DISK = C:DataBaseName.bak

However I am getting the following error message to do with Back up rights i think?

Server: Msg 262, Level 14, State 1, Line 1

BACKUP DATABASE permission denied in database 'DatabaseName'.
Server: Msg 3013, Level 16, State 1, Line 1

BACKUP DATABASE is terminating abnormally.

I found a helpful article and granted myself permission as stated in this article http://www.sqlbackuprestore.com/backupandrestorerights.htm but still no joy. Help please


I learn something new everyday.

James K
Flowing Fount of Yak Knowledge

3849 Posts

Posted - 05/06/2014 :  20:20:48  Show Profile  Reply with Quote
What that article describes appears to be correct and consistent with Microsoft documentation here: http://technet.microsoft.com/en-us/library/586561fc-dfbb-4842-84f8-204a9100a534#TsqlProcedure

Do you have permissions to write to the top of the C: drive? Even if you have, try running SSMS as administrator. Also, make sure there are no typos in your command. You have written "TO DISK = C:DataBaseName.bak". I am assuming it is a typo. You need C:\DataBaseName.bak.
Go to Top of Page

In (Som, Ni, Yak)

17684 Posts

Posted - 05/06/2014 :  21:08:32  Show Profile  Reply with Quote
also don't forget the single quote around the path + filename
TO DISK = 'C:\DataBaseName.bak'

Time is always against us

Edited by - khtan on 05/06/2014 21:09:12
Go to Top of Page

Yak Posting Veteran

56 Posts

Posted - 05/07/2014 :  02:30:06  Show Profile  Reply with Quote
Hi, yes I do have permissions as I have done it before with other databases from different Servers but I seem to be having problems with backing up this particular one.

Is there another I can take to write to the disk because I am not sure what the problem is.

Also, there are no typos. Just a mistake here.

Many Thanks,


I learn something new everyday.
Go to Top of Page

Almighty SQL Goddess

38073 Posts

Posted - 05/07/2014 :  11:50:51  Show Profile  Visit tkizer's Homepage  Reply with Quote
This is a permissions issue with the database and not with the file system. What permissions do you have for that particular database? You need:

BACKUP DATABASE and BACKUP LOG permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles.

Tara Kizer
SQL Server MVP since 2007
Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2139 Posts

Posted - 05/07/2014 :  13:16:06  Show Profile  Visit jackv's Homepage  Reply with Quote
Assign the db_backupoperator to the logon

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000