Database Backup

I am ultimately trying to backup my database from a deployed site to my PC's disk, because tools such as MyLittleBackup, which is provided by my hosting company, is done under http and not https.

But  initally I am trying to get a backup working on my local ASP.Net development server.  I am getting the following error message;

 "Could not locate entry in sysdatabases for database 'MyDatabase'. No entry found with that name. Make sure that the name is entered correctly. BACKUP DATABASE is terminating abnormally." 

My stored procedure is;

ALTER PROCEDURE dbo.DBBK1

AS

BEGIN

BACKUP DATABASE MyDatabase

TO DISK = 'C:Documents and SettingsBBBNMy DocumentsMyDatabase.bak''

WITH FORMAT;

END

RETURN

My Stored Procedure is called by the following script:

cnn1.ConnectionString = "Data Source=.sqlexpress;" & "Integrated Security=SSPI;" & "User Instance=True;" & "AttachDBFileName=" & My.Computer.FileSystem.CombinePath( _
              Server.MapPath("/MyWebSite/App_Data"), "MyDatabase.mdf")

        cmd3.Connection = cnn1
        cmd3.CommandText = "DBBK1"
        cmd3.CommandType = Data.CommandType.StoredProcedure
       
        cnn1.Open()
        Try
            cmd3.ExecuteNonQuery()
        Catch ex As Exception
            Message1.Text = (ex.Message)
        Finally
            cnn1.Close()
        End Try

I'm not sure what I need to consider to progress this.  Any help would be appreciated.

 

Chris