Solved

SQL Server backup fails from vb6 application

Posted on 2010-11-09
4
545 Views
Last Modified: 2012-05-10
I have a backup stored procedure gratiously provided by a member of this great establishment.  It runs fine from the server but fails occasionally when run from my vb6 app.  It doesn't timeout because it only runs about 20 seconds and the timeout is set for 60 seconds.

The error message simply says: 'Backup Failed'

Any ideas would be appreciated!!!

Jerry
0
Comment
Question by:JDL129
  • 2
4 Comments
 
LVL 7

Expert Comment

by:tlovie
ID: 34096653
Does the VB6 application run with the same login credentials as when you run it from the server?  What does the proc do?
0
 

Author Comment

by:JDL129
ID: 34097569
Thanks for the response!!!

Attached is the stored procedure that I run from vb6.  The error I get is:Backup Failed
The application logs into the SQLServer database and calls the attached.

Thanks,

Jerry
set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[sp_Backup]

@BackupPath nvarchar(200)

As

Declare @WeekDay tinyint

     Declare @Backup_File nvarchar(200)

     Declare @Desc nvarchar(255)                 

     Declare @Name nvarchar(128)                 



SET @WeekDay = DATEPART(weekday, CURRENT_TIMESTAMP)



IF @WeekDay = 7 -- change this value to meet the weekday you want to perform FULL BACKUP

BEGIN



     Set @Backup_File = @BackupPath + '\BarCodeSQL.bak'

     Set @Desc = 'Full Backup'

     Set @Name = 'Barcode FULL BACKUP'



     BACKUP DATABASE [BarCodeSQL] TO DISK = @Backup_File 

      WITH 

       DESCRIPTION = @Desc

     ,NAME = @Name

Return @@Error

END

ELSE

BEGIN



     Set @Backup_File = @BackupPath + '\BarCodeSQL.bak_' + DATENAME(weekday, CURRENT_TIMESTAMP) + '.bak'

     Set @Desc = 'Incremental Backup'

     Set @Name = 'Barcode ' + DATENAME(weekday, CURRENT_TIMESTAMP) + ' DIFF BACKUP'



     BACKUP DATABASE [BarCodeSQL] TO DISK = @Backup_File

     WITH DIFFERENTIAL,

      DESCRIPTION = @Desc, NOFORMAT, NOINIT

     ,NAME = @Name

     ,SKIP, NOREWIND, NOUNLOAD

Return @@Error

END

Open in new window

0
 
LVL 2

Accepted Solution

by:
SQLLover earned 125 total points
ID: 34114355
run a profiler to monitor what happed , i think the problem is in passing @BackupPath parameter from vb  
0
 

Author Closing Comment

by:JDL129
ID: 34138403
Thanks for the input!!!!!!!!!!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

914 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

21 Experts available now in Live!

Get 1:1 Help Now