Post reply

Timeout expired error

  • February 8, 2004 at 8:48 pm

    #160724

    Calling the procedure below from visual basic 6.0, I get a timeout expired error on large databases. It runs well on 200 M databases, but at about 350 M is when the error is starting.  The help section pointed me to the TOOLS, OPTIONS menu, but then the final section of the instructions did not match the screen that I was viewing.  Any recommendations.

    CREATE PROCEDURE [BackUpMe] 

     (@MyBackup  [nvarchar](75),

      @MyName  [nvarchar](75),

      @MyTable  [nvarchar](75),

      @MyDescription [nvarchar](75))

     

    AS

    backup database @MyTable to disk = @MyBackup

      WITH

         DESCRIPTION = @MyDescription,

         RETAINDAYS = 1,

         INIT,

         SKIP,

         NAME = @MyName

    GO

  • February 10, 2004 at 5:34 am

    #493356

    Try increasing the connectiontimout for the ado connection

  • February 10, 2004 at 12:15 pm

    #493465

    WSquared, You are a genius!  Actually the commandtimeout property fixed everything.  I would have never found that without your recommendation.  Thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply