Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ARCserve Backup 9.0 (Build 2020) on Windows 2000 Server

Status
Not open for further replies.

heffo

IS-IT--Management
Sep 9, 2004
52
IE
I have a Windows 2000 Server running ARCserve 9.0 on a Windows 2000 Server. There are five backup tapes and it normally backsup directories from three different Servers.
Normally, after inserting the tapes into the drive, I go into Quick Start/Device & Right Click on the Backup Device and Select 'Inventory Offline Slots'. I then right Click again & Select 'Erase' - Quick Erase plus - destroy label & serial no'. The Backup runs automatically @ 2am, but lately it is only writing to one of the tapes. When I mount the magazine the next morning, the other four appear as <Blank Media>.

Here is an example of what is appearing in BrightStor.log for the latest backup:

-----

[09/11/2004-00:00:07 ,1,572,0,0,-1,2,18,0,0] Run Prune Database Job Scheduled for 9/11/04 at 12:00 AM.
[09/11/2004-00:00:07 ,1,572,0,0,-1,2,18,0,0] Begin pruning database.
[09/11/2004-00:00:07 ,1,572,0,0,-1,2,18,0,0] Pruning sessions older than 30 days.
[09/11/2004-00:00:08 ,1,572,0,0,-1,2,18,0,0] End pruning database. (PRUNED=0)
[09/11/2004-00:00:08 ,1,572,0,0,-1,2,18,0,0] ** Summary for Job **
[09/11/2004-00:00:08 ,1,572,0,0,-1,2,18,0,0] Prune Database Operation Successful.
[09/11/2004-00:00:28 ,1,572,0,0,-1,2,18,0,0] Begin pruning logs.
[09/11/2004-00:00:28 ,1,572,0,0,-1,2,18,0,0] End pruning logs
[09/11/2004-00:00:28 ,1,572,0,0,-1,2,18,0,0] Reschedule Prune Database Job for 9/12/04 at 12:00 AM.
[09/11/2004-02:00:10 ,1,573,0,0,-1,2,18,0,0] Run Backup Job Scheduled for 9/11/04 at 2:00 AM.
[09/11/2004-02:00:10 ,1,573,0,0,-1,2,18,0,0] Start Backup Operation. (QUEUE=1, JOB=12)
[09/11/2004-02:00:10 ,1,573,0,0,-1,2,18,0,0] Description: Transaction Log Backup.
[09/11/2004-02:02:34 ,1,573,0,0,-1,2,18,0,0] Use media 8/21/04 2:02 AM, ID AA77, sequence #1
[09/11/2004-02:03:24 ,1,573,49,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\pubs
[09/11/2004-02:03:24 ,1,573,49,0,-1,2,18,0,0] Backup Session 49 on Media 8/21/04 2:02 AM
[09/11/2004-02:03:28 ,1,573,49,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (513 KB) Backed Up to Media.
[09/11/2004-02:03:28 ,1,573,49,0,-1,2,18,0,0] 576 KB Written to Media.
[09/11/2004-02:03:28 ,1,573,49,0,-1,2,18,0,0] Elapsed Time: 1s
[09/11/2004-02:03:28 ,1,573,49,0,-1,2,18,0,0] Average Throughput: 33.75 MB/min
[09/11/2004-02:03:28 ,1,573,50,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\JDE7333
[09/11/2004-02:03:28 ,1,573,50,0,-1,2,18,0,0] Backup Session 50 on Media 8/21/04 2:02 AM
[09/11/2004-02:03:35 ,1,573,50,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (20.00 MB) Backed Up to Media.
[09/11/2004-02:03:35 ,1,573,50,0,-1,2,18,0,0] 20.06 MB Written to Media.
[09/11/2004-02:03:35 ,1,573,50,0,-1,2,18,0,0] Elapsed Time: 1s
[09/11/2004-02:03:35 ,1,573,50,0,-1,2,18,0,0] Average Throughput: 1,203.75 MB/min
[09/11/2004-02:03:35 ,1,573,51,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\JDE_CRP
[09/11/2004-02:03:35 ,1,573,51,0,-1,2,18,0,0] Backup Session 51 on Media 8/21/04 2:02 AM
[09/11/2004-02:03:38 ,1,573,51,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (2.18 MB) Backed Up to Media.
[09/11/2004-02:03:38 ,1,573,51,0,-1,2,18,0,0] 2.25 MB Written to Media.
[09/11/2004-02:03:38 ,1,573,51,0,-1,2,18,0,0] Elapsed Time: 1s
[09/11/2004-02:03:38 ,1,573,51,0,-1,2,18,0,0] Average Throughput: 135.00 MB/min
[09/11/2004-02:03:39 ,1,573,52,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\JDE_DEVELOPMENT
[09/11/2004-02:03:39 ,1,573,52,0,-1,2,18,0,0] Backup Session 52 on Media 8/21/04 2:02 AM
[09/11/2004-02:03:44 ,1,573,52,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (7.75 MB) Backed Up to Media.
[09/11/2004-02:03:44 ,1,573,52,0,-1,2,18,0,0] 7.81 MB Written to Media.
[09/11/2004-02:03:44 ,1,573,52,0,-1,2,18,0,0] Elapsed Time: 1s
[09/11/2004-02:03:44 ,1,573,52,0,-1,2,18,0,0] Average Throughput: 468.75 MB/min
[09/11/2004-02:03:44 ,1,573,53,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\JDE_DV7333
[09/11/2004-02:03:44 ,1,573,53,0,-1,2,18,0,0] Backup Session 53 on Media 8/21/04 2:02 AM
[09/11/2004-02:03:48 ,1,573,53,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (2.56 MB) Backed Up to Media.
[09/11/2004-02:03:48 ,1,573,53,0,-1,2,18,0,0] 2.62 MB Written to Media.
[09/11/2004-02:03:48 ,1,573,53,0,-1,2,18,0,0] Elapsed Time: 0s
[09/11/2004-02:03:48 ,1,573,53,0,-1,2,18,0,0] Average Throughput: 157.50 MB/min
[09/11/2004-02:03:48 ,1,573,54,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\JDE_JD7333
[09/11/2004-02:03:48 ,1,573,54,0,-1,2,18,0,0] Backup Session 54 on Media 8/21/04 2:02 AM
[09/11/2004-02:03:51 ,1,573,54,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (513 KB) Backed Up to Media.
[09/11/2004-02:03:51 ,1,573,54,0,-1,2,18,0,0] 576 KB Written to Media.
[09/11/2004-02:03:51 ,1,573,54,0,-1,2,18,0,0] Elapsed Time: 0s
[09/11/2004-02:03:51 ,1,573,54,0,-1,2,18,0,0] Average Throughput: 33.75 MB/min
[09/11/2004-02:03:51 ,1,573,55,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\JDE_PD7333
[09/11/2004-02:03:51 ,1,573,55,0,-1,2,18,0,0] Backup Session 55 on Media 8/21/04 2:02 AM
[09/11/2004-02:03:57 ,1,573,55,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (12.50 MB) Backed Up to Media.
[09/11/2004-02:03:57 ,1,573,55,0,-1,2,18,0,0] 12.56 MB Written to Media.
[09/11/2004-02:03:57 ,1,573,55,0,-1,2,18,0,0] Elapsed Time: 1s
[09/11/2004-02:03:57 ,1,573,55,0,-1,2,18,0,0] Average Throughput: 753.75 MB/min
[09/11/2004-02:03:58 ,1,573,56,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\JDE_PRISTINE
[09/11/2004-02:03:58 ,1,573,56,0,-1,2,18,0,0] Backup Session 56 on Media 8/21/04 2:02 AM
[09/11/2004-02:04:01 ,1,573,56,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (513 KB) Backed Up to Media.
[09/11/2004-02:04:01 ,1,573,56,0,-1,2,18,0,0] 576 KB Written to Media.
[09/11/2004-02:04:01 ,1,573,56,0,-1,2,18,0,0] Elapsed Time: 0s
[09/11/2004-02:04:01 ,1,573,56,0,-1,2,18,0,0] Average Throughput: 33.75 MB/min
[09/11/2004-02:04:01 ,1,573,57,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\JDE_PRODUCTION
[09/11/2004-02:04:01 ,1,573,57,0,-1,2,18,0,0] Backup Session 57 on Media 8/21/04 2:02 AM
[09/11/2004-02:04:49 ,1,573,57,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (419.62 MB) Backed Up to Media.
[09/11/2004-02:04:49 ,1,573,57,0,-1,2,18,0,0] 419.68 MB Written to Media.
[09/11/2004-02:04:49 ,1,573,57,0,-1,2,18,0,0] Elapsed Time: 43s
[09/11/2004-02:04:49 ,1,573,57,0,-1,2,18,0,0] Average Throughput: 585.61 MB/min
[09/11/2004-02:04:49 ,1,573,58,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\JDE_PY7333
[09/11/2004-02:04:49 ,1,573,58,0,-1,2,18,0,0] Backup Session 58 on Media 8/21/04 2:02 AM
[09/11/2004-02:04:52 ,1,573,58,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (513 KB) Backed Up to Media.
[09/11/2004-02:04:52 ,1,573,58,0,-1,2,18,0,0] 576 KB Written to Media.
[09/11/2004-02:04:52 ,1,573,58,0,-1,2,18,0,0] Elapsed Time: 1s
[09/11/2004-02:04:52 ,1,573,58,0,-1,2,18,0,0] Average Throughput: 33.75 MB/min
[09/11/2004-02:04:53 ,1,573,59,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\master
[09/11/2004-02:04:53 ,1,573,59,0,-1,2,18,0,0] Backup Session 59 on Media 8/21/04 2:02 AM
[09/11/2004-02:06:53 ,1,573,59,0,-1,2,1,0,0] E8602 Failed to read from database. (DBNAME=master, EC=JORDAN:[SQL Server] szSqlState = 37000,fNativeError = 4212, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot back up the log of the master database. Use BACKUP DATABASE instead.)
[09/11/2004-02:06:56 ,1,573,59,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (0 KB) Backed Up to Media.
[09/11/2004-02:06:56 ,1,573,59,0,-1,2,18,0,0] 64 KB Written to Media.
[09/11/2004-02:06:56 ,1,573,59,0,-1,2,18,0,0] Elapsed Time: 2m 0s
[09/11/2004-02:06:56 ,1,573,59,0,-1,2,18,0,0] Average Throughput: 32 KB/min
[09/11/2004-02:06:56 ,1,573,59,0,-1,2,18,0,0] Number of Error(s)/Warning(s): 1/0
[09/11/2004-02:06:56 ,1,573,60,0,-1,2,18,0,0] Source Directory: \\JORDAN\dbasql@MSSQLSERVER\model
[09/11/2004-02:06:56 ,1,573,60,0,-1,2,18,0,0] Backup Session 60 on Media 8/21/04 2:02 AM
[09/11/2004-02:06:59 ,1,573,60,0,-1,2,18,0,0] 1 Database(s)/Transaction Log(s) (513 KB) Backed Up to Media.
[09/11/2004-02:06:59 ,1,573,60,0,-1,2,18,0,0] 576 KB Written to Media.
[09/11/2004-02:06:59 ,1,573,60,0,-1,2,18,0,0] Elapsed Time: 0s
[09/11/2004-02:06:59 ,1,573,60,0,-1,2,18,0,0] Average Throughput: 33.75 MB/min
[09/11/2004-02:06:59 ,1,573,60,0,-1,2,18,0,0] Number of Error(s)/Warning(s): 1/0
[09/11/2004-02:06:59 ,1,573,0,0,-1,2,18,0,0] ** Summary for JORDAN **
[09/11/2004-02:06:59 ,1,573,0,0,-1,2,18,0,0] 12 Session(s).
[09/11/2004-02:06:59 ,1,573,0,0,-1,2,18,0,0] 11 Database(s)/Transaction Log(s) (467.13 MB) Backed Up to Media.
[09/11/2004-02:06:59 ,1,573,0,0,-1,2,18,0,0] 467.87 MB Written to Media.
[09/11/2004-02:06:59 ,1,573,0,0,-1,2,18,0,0] Elapsed Time: 2m 49s
[09/11/2004-02:06:59 ,1,573,0,0,-1,2,18,0,0] Average Throughput: 166.10 MB/min
[09/11/2004-02:06:59 ,1,573,0,0,-1,2,18,0,0] Number of Error(s)/Warning(s): 1/0
[09/11/2004-02:07:01 ,1,573,49,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:49] is merged.(files=2)
[09/11/2004-02:07:01 ,1,573,50,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:50] is merged.(files=2)
[09/11/2004-02:07:01 ,1,573,51,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:51] is merged.(files=2)
[09/11/2004-02:07:01 ,1,573,52,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:52] is merged.(files=2)
[09/11/2004-02:07:01 ,1,573,53,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:53] is merged.(files=2)
[09/11/2004-02:07:01 ,1,573,54,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:54] is merged.(files=2)
[09/11/2004-02:07:01 ,1,573,55,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:55] is merged.(files=2)
[09/11/2004-02:07:02 ,1,573,56,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:56] is merged.(files=2)
[09/11/2004-02:07:02 ,1,573,57,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:57] is merged.(files=2)
[09/11/2004-02:07:02 ,1,573,58,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:58] is merged.(files=2)
[09/11/2004-02:07:02 ,1,573,59,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:59] is merged.(files=2)
[09/11/2004-02:07:02 ,1,573,60,0,-1,2,18,0,0] [CAT] 8/21/04 2:02 AM [ID:AA77,SESSION:60] is merged.(files=2)
[09/11/2004-02:07:03 ,1,573,0,0,-1,2,18,0,0] Media Remaining Capacity : 33,416 MB
[09/11/2004-02:07:03 ,1,573,0,0,-1,2,18,0,0] Media Compression Ratio : 3.40
[09/11/2004-02:07:03 ,1,573,0,0,-1,2,18,0,0] *** Backup Summary for Job ID 573 ***
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] Device Group........................... GROUP0
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] Media Pool............................. N/A
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] Media Name............................. 8/21/04 2:02 AM
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] Media ID............................... AA77
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] Total number of sessions............... 12
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] Serial No [Seq 1]...................... N/A
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] Total Nodes to be backed up............ 1
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] -- Complete and Incomplete status...... 0
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] -- Failed and Canceled status.......... 1
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] Total Volumes to be backed up.......... 1
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] -- Complete and Incomplete status...... 0
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] -- Failed and Canceled status.......... 1
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] Total Directories backed up............ 0
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] Total Files backed up.................. 11
[09/11/2004-02:07:03 ,1,573,60,0,-1,2,18,0,0] Total MB processed..................... 478.35
[09/11/2004-02:07:03 ,1,573,0,0,-1,2,18,0,0] Missed Nodes/Volumes:
[09/11/2004-02:07:03 ,1,573,0,0,-1,2,18,0,0] \\JORDAN\dbasql@MSSQLSERVER
[09/11/2004-02:07:03 ,1,573,0,0,-1,2,18,0,0] Backup Operation Failed.
[09/11/2004-02:07:23 ,1,573,0,0,-1,2,18,0,0] Reschedule Backup Job for 9/12/04 at 2:00 AM.
 
If you are suddenly using less tapes, then the backup may not be complete. The only error I see in the job log is this:

E8602 Failed to read from database. (DBNAME=master, EC=JORDAN:[SQL Server] szSqlState = 37000,fNativeError = 4212, errMsg = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot back up the log of the master database. Use BACKUP DATABASE instead.)

However, this is the master database only. I highly doubt this caused the rest of the backup to fail. A master database is not typically very big.

The job is backing up 467MB of data. Is that usual?

11 Database(s)/Transaction Log(s) (467.13 MB) Backed Up to Media.

I don't see any mention of file system backups in the job log you posted. Are the other machines backed up in separate jobs? You should review the job logs for all jobs to see how much data was backed up and what was missed.
 
Thanks ACiDelic for the feedback, it should be backing up far more than 420Mb of data, it backsup the Homefolders of approx 40 users, a few SQL Server Databases, some Exchange Mailboxes and other directories.

I am using the same number of tapes as always and have not done anything different (That I am aware of).

Would it be easier to just setup a new Backup Job from scratch?
 
according to the log information. This is only a backup of the SQL transaction log files using the SQL agent. I don't see any folders or exchange mailboxes as mentioned. The job is even called 'transaction log backup'. Transaction log backups don't use any data so according to the log nothing is wrong.
Check the 'source' view of the backup when modifying the job. Also check the SQL agent settings (by right clicking the SQL agent icon in the source view

regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top