Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marcusn25
Yak Posting Veteran
56 Posts |
 Posted - 2014-05-06 : 18:21:11
|
| 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.bakGOHowever 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 1BACKUP 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 pleaseMarcus I learn something new everyday. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-05-06 : 20:21:23
|
| Dup of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=194048 |
 |
|
|
|
|
|
Backing up Database