Back up of SQL server database using command line

Question

I am trying to create a back up for an SQL Server database using command line.I have used the following command:

C:\>SqlCmd -E -S DEVE-PC3/SQLEXPRESS -Q "BACKUP DATABASE Exam_Db To Disk='d:\Exam_db.bak'"

But I am getting an error message

Msg 3201,cannot open backup device Operating System Error 5.
Msg 3013,Backup database is terminating abnormally.

What am I missing?

Ben Thul · Accepted Answer · 2014-03-08 14:50:54Z

2

That error message tells you that whatever account is running the SQL Server service doesn't have permission to write to the location that you've specified. Either choose another location or give the service account permission.

answered Mar 8, 2014 at 14:50

Ben Thul

32.9k4 gold badges52 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Back up of SQL server database using command line

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related