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
 SQL Server Administration (2005)
 Backing up Database
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

marcusn25
Starting Member

Germany
39 Posts

Posted - 05/06/2014 :  18:21:11  Show Profile
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

3555 Posts

Posted - 05/06/2014 :  20:21:23  Show Profile
Dup of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=194048
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 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