Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Back up Database
 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 but still no joy. Help please


I learn something new everyday.

James K
Flowing Fount of Yak Knowledge

3873 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:

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)

17689 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

38200 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
2179 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  
 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.03 seconds. Powered By: Snitz Forums 2000