Errors when testing a stored procedures

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

Errors when testing a stored procedures

Author

Topic

AutoCrib
Starting Member

1 Post

Posted - 2011-04-25 : 13:00:36

What does this mean?

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'C:\AutoCribBackup\DropBox\autocrib_Full_Monday.BAK'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-25 : 13:26:45

It means your path is wrong. Backups run in the context of the database server, so perhaps you are thinking the path is to your local machine.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

the_amol
Starting Member

6 Posts

Posted - 2011-04-27 : 01:11:24

you need to verify the path you are entering. as the SQL server takes backup on the server machines and not on local machine where sql client is installed. the path you entered should exist on server.

Thanks & Regards
Amol Verma
MCTS SQL Server 2005, OCA/OCP Oracle 9i/10g
http://qualityassurancecentral.com
http://qualityassurancecentral.com/forum

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-27 : 13:06:17

Isn't that what I already said 2 days ago?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources