SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

marcusn25
Yak Posting Veteran

Germany
56 Posts

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

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

BACK UP DATABASE 'DataBaseName'
TO DISK = C:DataBaseName.bak
GO

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



Marcus

I learn something new everyday.

James K
Flowing Fount of Yak Knowledge

3760 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

khtan
In (Som, Ni, Yak)

Singapore
17681 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'



KH
Time is always against us


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

marcusn25
Yak Posting Veteran

Germany
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,


Marcus

I learn something new everyday.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37466 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:
quote:

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
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2079 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
--------------------
http://www.sqlserver-dba.com
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.06 seconds. Powered By: Snitz Forums 2000