Restore runs longer in batch mode

From: cbriscoejr (cbriscoejr_at_discussions.microsoft.com)
Date: 08/06/04

  • Next message: HelloWebWorld: "Re: BLOB" 
    Date: Fri, 6 Aug 2004 07:27:03 -0700

    I have created a Job that uses "cmcexec" to execute a SQL script. This Job
    brings SQL to single_user mode then restores from a directory that is local
    to the server.

    1) When I run this restore in the GUI it takes 15 minutes but is still
    executing
    (1 + hours).

    2) How can I tell that it is actually running and not hung up?

  • Next message: HelloWebWorld: "Re: BLOB"

    Relevant Pages

    • SMS 2003 SP2 installation - Error during upgrade database
      ... SP2 starts execute SQL Scripts: ... SQL Script: Creating indexes on AttributeMap ... SQL Script: Creating indexes on SoftwareFile ... SQL Script: Create SQL object vSecurityInstancePermissions ...
      (microsoft.public.sms.admin)
    • Re: SMS 2003 SP2 installation - Error during upgrade database
      ... SP2 starts execute SQL Scripts: ... SQL Script: Creating indexes on AttributeMap ... SQL Script: Creating indexes on SoftwareFile ... SQL Script: Create SQL object vSecurityInstancePermissions ...
      (microsoft.public.sms.admin)
    • Re: running an sql script
      ... I have an many SQL Script that has a series of inserts, updates, selects. ... want to be able to run execute it from VB or VB.net. ... general, you will need to use ADO or ADO.NET, depending on platform. ...
      (microsoft.public.vb.database)
    • My Scripts wont execute correctly..what am I missing?
      ... SQL Script in VB.Net. ... My code uses a connection string similar to: ... CREATE DATABASE test ... just not possible to execute more than one sql statement in one big string? ...
      (microsoft.public.sqlserver.programming)
    • Error 25002: The specified buffer size is not valid.
      ... I am building a SQL script having several "INSERT INTO" ... which I read & execute line by line. ... "TEMP" directory in Pocket PC, ... Francisco Rodríguez ...
      (microsoft.public.sqlserver.ce)