Loading ...
Sorry, an error occurred while loading the content.

Re: MUGH-SQLCON when database backup command is running in sqlserver2000 in Query analyzer

Expand Messages
  • nitin kumar
    Hi You need to add with stats =X% in backup statement. where X is your desired percentage value. Nitin ________________________________ From: SARADA DEVI
    Message 1 of 4 , Nov 30, 2008
    • 0 Attachment
      Hi


      You need to add "with stats =X%" in backup statement. where X is your desired percentage value.

      Nitin


      ________________________________
      From: SARADA DEVI <sv_39@...>
      To: sqlcon@yahoogroups.com
      Sent: Thursday, 27 November, 2008 4:15:00 PM
      Subject: MUGH-SQLCON when database backup command is running in sqlserver2000 in Query analyzer


      when database backup command is running in sqlserver2000 in Query
      analyzer .how to see the how much % of backup completed[status of
      backup].it is sqlserver default backup.

      Thanks,
      krishna




      Be the first one to try the new Messenger 9 Beta! Go to http://in.messenger.yahoo.com/win/

      [Non-text portions of this message have been removed]
    • sunil john
      we can see the status (i mean %) only once its finished, the progress will not show while the backup is happening. correct me if am wrong. ( in sql 2k QA) Best
      Message 2 of 4 , Dec 2, 2008
      • 0 Attachment
        we can see the status (i mean %) only once its finished, the progress will not show while the backup is happening. correct me if am wrong. ( in sql 2k QA)

        Best Regards


        Sunil John




        ________________________________
        From: vikas_srivastava89 <vikas_srivastava89@...>
        To: sqlcon@yahoogroups.com
        Sent: Sunday, November 30, 2008 16:47:56
        Subject: MUGH-SQLCON Re: when database backup command is running in sqlserver2000 in Query analyzer


        --- In sqlcon@yahoogroups. com, "SARADA DEVI" <sv_39@...> wrote:
        >
        > when database backup command is running in sqlserver2000 in Query
        > analyzer .how to see the how much % of backup completed[status of
        > backup].it is sqlserver default backup.
        >
        >
        > Thanks,
        > krishna
        >
        Krishna to see % of backup use this query

        backup database dbname to disk ='c:\sql testing folder\db.bak '
        with
        stats =5

        Note
        where 5 is percent when u backup after every 5% backup it displays
        %completed




        New Email names for you!
        Get the Email name you've always wanted on the new @ymail and @rocketmail.
        Hurry before someone else does!
        http://mail.promotions.yahoo.com/newdomains/aa/

        [Non-text portions of this message have been removed]
      Your message has been successfully submitted and would be delivered to recipients shortly.