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