SQL Scheduler Backup Error

Posted on 2009-04-27
Last Modified: 2012-05-07
Hi all,

I am using SQL Server 2005 Express version on Windows Server 2003 Small Business for my databases.  After a great deal of research on here and other website i have decided to use SQL Scheduler to manage my backups.  I have complete the setup of SQL Scheduler and i am getting an error when executing.

The script to run the back is as follows:
DECLARE @BackupName VARCHAR(255)
DECLARE @BackupFileName VARCHAR(255)

SET @BackupName = 'dbw_bentjobs_' + convert(nvarchar(20), getdate(), 112) + N'.bak'
SET @BackupFileName = 'S:\Databuild\backup\' + @BackupName

BACKUP DATABASE dbw_bentjobs TO  

The error i am getting is;
The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3201
on line 7 of procedure on server BHS1\SQLEXPRESS:
Cannot open backup device 'S:\Databuild\backup\dbw_bentjobs_20090428.bak'. Operating system error 3(The system cannot find the path specified.).
The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3013

What could the cause of this error?
Question by:andrewl77
    1 Comment
    LVL 3

    Accepted Solution

    Is the path on the database server or on the machine that you are running SQL Server Management Studio on?  

    It needs to be the path as the server sees it.


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now