Please start any new threads on our new site at http://forums.sqlteam.com. 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
 
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
 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

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



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