SQL Server backup error

Error While creating BACKUP:
I am Creating FullBackup for one database Named Postings.
I executed below Query and i am getting The Below error message.

USE master
go
EXEC SP_ADDUMPDEVICE 'disk','PostingsBac',
'E:BACKUPPostingsBac.BAK'
BACKUP DATABASE Postings TO PostingsBac

ERROR:'Device Created'
One Row Effected.

Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'PostingsBac'.
Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally
  • Interview Candidate
  • 3
  • 1717

Showing Answers 1 - 3 of 3 Answers

debasis.yours

  • Dec 14th, 2007
 

This is basically a problem with the physical path of the Backup device, I suppose. Be sure the physical path that you are giving has full access from your Windows user Account or not.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions