I recently installed arcserve small business version for a client who
is running SQL server. It seems that at the beginning of the backup
cycle the files are skipped due to a sharing violation (I mean the
database files). Later during the part when the SQL agent backs up
files it seems to back up fine. Is this normal or is something wrong
here. Below is a log...sorry if it is a little long. Thanks so much
for youe help.
20030701 010009 16 Run Backup Job Scheduled for 7/01/03 at 1:00 AM.
20030701 010009 16 Start Backup Operation. (QUEUE=1, JOB=2)
20030701 010010 16 Overwrite media Monthly2, ID DBA9, sequence #1
20030701 010037 TAPE Tape Engine finished formatting media.(new name:
Monthly2, old name: Monthly2)
20030701 010037 Begin cleaning database.
20030701 010044 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=1, RECS=18130)
20030701 010047 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=2, RECS=11705)
20030701 010048 TAPE Format Successful!
20030701 010048 16 Use media Monthly2, ID 2542, sequence #1
20030701 010054 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=3, RECS=27896)
20030701 010129 16 Source Directory: C:
20030701 010129 16 Back up Session 1 on Media Monthly2
20030701 010129 16 Backed up volume disk quota.
20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=4, RECS=151242)
20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=5, RECS=7)
20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=6, RECS=12)
20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=7, RECS=12)
20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=8, RECS=12)
20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=9, RECS=12)
20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=10, RECS=12)
20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=11, RECS=12)
20030701 010159 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=12, RECS=13291)
20030701 010159 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=13, RECS=225)
20030701 010159 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
SES=14, RECS=123)
20030701 010159 End cleaning database. (CLEANED=222691)
20030701 010233 16 W3404 Unable to open file. (FILE=C:\Documents and
Settings\All Users\Application
Data\Microsoft\Network\Downloader\qmgr0.dat, EC=SHARING VIOLATION)
20030701 010233 16 W3404 Unable to open file. (FILE=C:\Documents and
Settings\All Users\Application
Data\Microsoft\Network\Downloader\qmgr1.dat, EC=SHARING VIOLATION)
20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSDYNAMICSDat.mdf,
EC=SHARING VIOLATION)
20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSDYNAMICSLog.ldf,
EC=SHARING VIOLATION)
20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSSBM01Dat.mdf,
EC=SHARING VIOLATION)
20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSSBM01Log.ldf,
EC=SHARING VIOLATION)
20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSTWODat.mdf,
EC=SHARING VIOLATION)
20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSTWOLog.ldf,
EC=SHARING VIOLATION)
20030701 010601 16 Catalog File Backed Up
20030701 010601 16 Registry Files Backed Up
20030701 010601 16 1,049 Directories 17,088 Files (1,404.55 MB) Backed
Up to Media.
20030701 010601 16 8 Directories/Files Skipped.
20030701 010601 16 1,463.31 MB Written to Media.
20030701 010601 16 Elapsed Time: 4m 30s
20030701 010601 16 Average Throughput: 325.17 MB/min
20030701 010601 16 Number of Errors/Warnings: 0/8
20030701 010611 16 Source Directory: E:
20030701 010611 16 Back up Session 2 on Media Monthly2
20030701 010611 16 Backed up volume disk quota.
20030701 011115 16 Catalog File Backed Up
20030701 011115 16 563 Directories 11,142 Files (1,254.87 MB) Backed
Up to Media.
20030701 011115 16 1,292.68 MB Written to Media.
20030701 011115 16 Elapsed Time: 5m 0s
20030701 011115 16 Average Throughput: 258.53 MB/min
20030701 011201 16 Source Directory: F:
20030701 011201 16 Back up Session 3 on Media Monthly2
20030701 011201 16 Backed up volume disk quota.
20030701 012213 16 Catalog File Backed Up
20030701 012213 16 4,665 Directories 23,262 Files (3,229.25 MB) Backed
Up to Media.
20030701 012213 16 3,320.18 MB Written to Media.
20030701 012213 16 Elapsed Time: 10m 9s
20030701 012213 16 Average Throughput: 327.11 MB/min
20030701 012213 16 Source Directory: Registry
20030701 012213 16 Back up Session 4 on Media Monthly2
20030701 012244 16 Registry Files Backed Up
20030701 012244 16 54,946 Directories 96,295 Files (21.42 MB) Backed
Up to Media.
20030701 012244 16 404.87 MB Written to Media.
20030701 012244 16 Elapsed Time: 28s
20030701 012244 16 Average Throughput: 867.58 MB/min
20030701 012244 16 Source Directory: dbaexchis\First Storage Group
20030701 012244 16 Back up Session 5 on Media Monthly2
20030701 012301 16 1 Databases/Transaction Logs (103.04 MB) Backed Up
to Media.
20030701 012301 16 103.12 MB Written to Media.
20030701 012301 16 Elapsed Time: 15s
20030701 012301 16 Average Throughput: 412.50 MB/min
20030701 012302 16 Source Directory: dbasql@.MSGPSBM\TWO
20030701 012302 16 Back up Session 6 on Media Monthly2
20030701 012311 16 1 Databases/Transaction Logs (90.07 MB) Backed Up
to Media.
20030701 012311 16 90.18 MB Written to Media.
20030701 012311 16 Elapsed Time: 7s
20030701 012311 16 Average Throughput: 773.03 MB/min
20030701 012311 16 Source Directory: dbasql@.MSGPSBM\SBM01
20030701 012311 16 Back up Session 7 on Media Monthly2
20030701 012355 16 1 Databases/Transaction Logs (548.07 MB) Backed Up
to Media.
20030701 012355 16 548.37 MB Written to Media.
20030701 012355 16 Elapsed Time: 42s
20030701 012355 16 Average Throughput: 783.39 MB/min
20030701 012355 16 Source Directory: dbasql@.MSGPSBM\msdb
20030701 012355 16 Back up Session 8 on Media Monthly2
20030701 012357 16 1 Databases/Transaction Logs (2.32 MB) Backed Up to
Media.
20030701 012357 16 2.37 MB Written to Media.
20030701 012357 16 Elapsed Time: 1s
20030701 012357 16 Average Throughput: 142.50 MB/min
20030701 012357 16 Source Directory: dbasql@.MSGPSBM\model
20030701 012357 16 Back up Session 9 on Media Monthly2
20030701 012400 16 1 Databases/Transaction Logs (721 KB) Backed Up to
Media.
20030701 012400 16 768 KB Written to Media.
20030701 012400 16 Elapsed Time: 1s
20030701 012400 16 Average Throughput: 45.00 MB/min
20030701 012400 16 Source Directory: dbasql@.MSGPSBM\master
20030701 012400 16 Back up Session 10 on Media Monthly2
20030701 012407 16 1 Databases/Transaction Logs (10.51 MB) Backed Up
to Media.
20030701 012407 16 10.56 MB Written to Media.
20030701 012407 16 Elapsed Time: 0s
20030701 012407 16 Average Throughput: 633.75 MB/min
20030701 012407 16 Source Directory: dbasql@.MSGPSBM\DYNAMICS
20030701 012407 16 Back up Session 11 on Media Monthly2
20030701 012412 16 1 Databases/Transaction Logs (29.95 MB) Backed Up
to Media.
20030701 012412 16 30.00 MB Written to Media.
20030701 012412 16 Elapsed Time: 3s
20030701 012412 16 Average Throughput: 600.00 MB/min
20030701 012413 16 Source Directory: System State
20030701 012413 16 Back up Session 12 on Media Monthly2
20030701 012413 16 Backing Up Files : Boot and System Protected Files
20030701 012445 16 Backing Up Files : Active Directory
20030701 012448 16 Backing Up Files : SysVol
20030701 012448 16 Backing Up Files : COM+ Class Registration Database
20030701 012448 16 Backing Up Files : Registry
20030701 012455 16 Registry Files Backed Up
20030701 012455 16 91 Directories 1,963 Files (287.99 MB) Backed Up to
Media.
20030701 012455 16 294.56 MB Written to Media.
20030701 012455 16 Elapsed Time: 39s
20030701 012455 16 Average Throughput: 453.17 MB/min
20030701 012455 16 Source Directory: dbaxchg2
20030701 012455 16 Back up Session 13 on Media Monthly2
20030701 012516 16 11 Databases/Transaction Logs (40.19 MB) Backed Up
to Media.
20030701 012516 16 40.50 MB Written to Media.
20030701 012516 16 Elapsed Time: 19s
20030701 012516 16 Average Throughput: 127.89 MB/min
20030701 012516 16 ** Summary for My Computer **
20030701 012516 16 13 Sessions.
20030701 012516 16 61,314 Directories 149,750 Files (6,198.15 MB)
Backed Up to Media.
20030701 012516 16 18 Databases/Transaction Logs (824.89 MB) Backed Up
to Media.
20030701 012516 16 8 Directories/Files Skipped.
20030701 012516 16 7,601.50 MB Written to Media.
20030701 012516 16 Elapsed Time: 22m 14s
20030701 012516 16 Average Throughput: 341.89 MB/min
20030701 012516 16 Number of Errors/Warnings: 0/8
20030701 012519 16 Backup ARCserve Database...
20030701 012520 16 Source Directory: C:\Program
Files\ComputerAssociates\ARCserve\DATABASE
20030701 012520 16 Back up Session 14 on Media Monthly2
20030701 012529 16 Catalog File Backed Up
20030701 012529 16 1 Directories 118 Files (104.17 MB) Backed Up to
Media.
20030701 012529 16 104.62 MB Written to Media.
20030701 012529 16 Elapsed Time: 7s
20030701 012529 16 Average Throughput: 896.78 MB/min
20030701 012529 16 ARCServe Database Backed Up
20030701 012538 [CAT] Monthly2 [ID:2542,SESSION:1] is
merged.(files=17088)
20030701 012542 [CAT] Monthly2 [ID:2542,SESSION:2] is
merged.(files=11142)
20030701 012555 [CAT] Monthly2 [ID:2542,SESSION:3] is
merged.(files=23262)
20030701 012631 16 ** Summary for Job **
20030701 012631 16 14 Sessions.
20030701 012631 16 61,315 Directories 149,868 Files (6,302.33 MB)
Backed Up to Media.
20030701 012631 16 18 Databases/Transaction Logs (824.89 MB) Backed Up
to Media.
20030701 012631 16 8 Directories/Files Skipped.
20030701 012631 16 7,706.12 MB Written to Media.
20030701 012631 16 Elapsed Time: 22m 21s
20030701 012631 16 Average Throughput: 344.79 MB/min
20030701 012631 16 Number of Errors/Warnings: 0/8
20030701 012631 16 Backup Operation Incomplete.
20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:4] is
merged.(files=96295)
20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:5] is merged.(files=5)
20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:6] is merged.(files=3)
20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:7] is merged.(files=3)
20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:8] is merged.(files=3)
20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:9] is merged.(files=3)
20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:10] is
merged.(files=3)
20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:11] is
merged.(files=3)
20030701 012708 [CAT] Monthly2 [ID:2542,SESSION:12] is
merged.(files=1963)
20030701 012708 [CAT] Monthly2 [ID:2542,SESSION:13] is
merged.(files=110)
20030701 012708 [CAT] Monthly2 [ID:2542,SESSION:14] is
merged.(files=118)
20030701 012709 16 Reschedule Backup Job for 7/02/03 at 1:00 AM.You can't normally backup the database files with ArcServe since they are
always in use. I believe they have a way to bypass that but then what good
is backing up a file that is constantly changing. You can't restore the db
using these backups made from Arcserve since they are not consistent. What
you can do is basically one of 2 things. Either use the SQL Server plug-in
for ArcServe to have it issue the equivalent of a sql server backup or don't
even attempt to backup the database files with Arcserve and have it backup
the files generated by the SQL Server backup.
--
Andrew J. Kelly
SQL Server MVP
"Devin G" <devin@.spamhole.com> wrote in message
news:495ba422.0307021902.4a418a32@.posting.google.com...
> I recently installed arcserve small business version for a client who
> is running SQL server. It seems that at the beginning of the backup
> cycle the files are skipped due to a sharing violation (I mean the
> database files). Later during the part when the SQL agent backs up
> files it seems to back up fine. Is this normal or is something wrong
> here. Below is a log...sorry if it is a little long. Thanks so much
> for youe help.
>
> 20030701 010009 16 Run Backup Job Scheduled for 7/01/03 at 1:00 AM.
> 20030701 010009 16 Start Backup Operation. (QUEUE=1, JOB=2)
> 20030701 010010 16 Overwrite media Monthly2, ID DBA9, sequence #1
> 20030701 010037 TAPE Tape Engine finished formatting media.(new name:
> Monthly2, old name: Monthly2)
> 20030701 010037 Begin cleaning database.
> 20030701 010044 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=1, RECS=18130)
> 20030701 010047 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=2, RECS=11705)
> 20030701 010048 TAPE Format Successful!
> 20030701 010048 16 Use media Monthly2, ID 2542, sequence #1
> 20030701 010054 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=3, RECS=27896)
> 20030701 010129 16 Source Directory: C:
> 20030701 010129 16 Back up Session 1 on Media Monthly2
> 20030701 010129 16 Backed up volume disk quota.
> 20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=4, RECS=151242)
> 20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=5, RECS=7)
> 20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=6, RECS=12)
> 20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=7, RECS=12)
> 20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=8, RECS=12)
> 20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=9, RECS=12)
> 20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=10, RECS=12)
> 20030701 010154 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=11, RECS=12)
> 20030701 010159 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=12, RECS=13291)
> 20030701 010159 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=13, RECS=225)
> 20030701 010159 Session is cleaned. (MEDIA=Monthly2, ID=FFFFDBA9,
> SES=14, RECS=123)
> 20030701 010159 End cleaning database. (CLEANED=222691)
> 20030701 010233 16 W3404 Unable to open file. (FILE=C:\Documents and
> Settings\All Users\Application
> Data\Microsoft\Network\Downloader\qmgr0.dat, EC=SHARING VIOLATION)
> 20030701 010233 16 W3404 Unable to open file. (FILE=C:\Documents and
> Settings\All Users\Application
> Data\Microsoft\Network\Downloader\qmgr1.dat, EC=SHARING VIOLATION)
> 20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
> Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSDYNAMICSDat.mdf,
> EC=SHARING VIOLATION)
> 20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
> Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSDYNAMICSLog.ldf,
> EC=SHARING VIOLATION)
> 20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
> Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSSBM01Dat.mdf,
> EC=SHARING VIOLATION)
> 20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
> Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSSBM01Log.ldf,
> EC=SHARING VIOLATION)
> 20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
> Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSTWODat.mdf,
> EC=SHARING VIOLATION)
> 20030701 010338 16 W3404 Unable to open file. (FILE=C:\Program
> Files\Microsoft SQL Server\MSSQL$MSGPSBM\Data\GPSTWOLog.ldf,
> EC=SHARING VIOLATION)
> 20030701 010601 16 Catalog File Backed Up
> 20030701 010601 16 Registry Files Backed Up
> 20030701 010601 16 1,049 Directories 17,088 Files (1,404.55 MB) Backed
> Up to Media.
> 20030701 010601 16 8 Directories/Files Skipped.
> 20030701 010601 16 1,463.31 MB Written to Media.
> 20030701 010601 16 Elapsed Time: 4m 30s
> 20030701 010601 16 Average Throughput: 325.17 MB/min
> 20030701 010601 16 Number of Errors/Warnings: 0/8
> 20030701 010611 16 Source Directory: E:
> 20030701 010611 16 Back up Session 2 on Media Monthly2
> 20030701 010611 16 Backed up volume disk quota.
> 20030701 011115 16 Catalog File Backed Up
> 20030701 011115 16 563 Directories 11,142 Files (1,254.87 MB) Backed
> Up to Media.
> 20030701 011115 16 1,292.68 MB Written to Media.
> 20030701 011115 16 Elapsed Time: 5m 0s
> 20030701 011115 16 Average Throughput: 258.53 MB/min
> 20030701 011201 16 Source Directory: F:
> 20030701 011201 16 Back up Session 3 on Media Monthly2
> 20030701 011201 16 Backed up volume disk quota.
> 20030701 012213 16 Catalog File Backed Up
> 20030701 012213 16 4,665 Directories 23,262 Files (3,229.25 MB) Backed
> Up to Media.
> 20030701 012213 16 3,320.18 MB Written to Media.
> 20030701 012213 16 Elapsed Time: 10m 9s
> 20030701 012213 16 Average Throughput: 327.11 MB/min
> 20030701 012213 16 Source Directory: Registry
> 20030701 012213 16 Back up Session 4 on Media Monthly2
> 20030701 012244 16 Registry Files Backed Up
> 20030701 012244 16 54,946 Directories 96,295 Files (21.42 MB) Backed
> Up to Media.
> 20030701 012244 16 404.87 MB Written to Media.
> 20030701 012244 16 Elapsed Time: 28s
> 20030701 012244 16 Average Throughput: 867.58 MB/min
> 20030701 012244 16 Source Directory: dbaexchis\First Storage Group
> 20030701 012244 16 Back up Session 5 on Media Monthly2
> 20030701 012301 16 1 Databases/Transaction Logs (103.04 MB) Backed Up
> to Media.
> 20030701 012301 16 103.12 MB Written to Media.
> 20030701 012301 16 Elapsed Time: 15s
> 20030701 012301 16 Average Throughput: 412.50 MB/min
> 20030701 012302 16 Source Directory: dbasql@.MSGPSBM\TWO
> 20030701 012302 16 Back up Session 6 on Media Monthly2
> 20030701 012311 16 1 Databases/Transaction Logs (90.07 MB) Backed Up
> to Media.
> 20030701 012311 16 90.18 MB Written to Media.
> 20030701 012311 16 Elapsed Time: 7s
> 20030701 012311 16 Average Throughput: 773.03 MB/min
> 20030701 012311 16 Source Directory: dbasql@.MSGPSBM\SBM01
> 20030701 012311 16 Back up Session 7 on Media Monthly2
> 20030701 012355 16 1 Databases/Transaction Logs (548.07 MB) Backed Up
> to Media.
> 20030701 012355 16 548.37 MB Written to Media.
> 20030701 012355 16 Elapsed Time: 42s
> 20030701 012355 16 Average Throughput: 783.39 MB/min
> 20030701 012355 16 Source Directory: dbasql@.MSGPSBM\msdb
> 20030701 012355 16 Back up Session 8 on Media Monthly2
> 20030701 012357 16 1 Databases/Transaction Logs (2.32 MB) Backed Up to
> Media.
> 20030701 012357 16 2.37 MB Written to Media.
> 20030701 012357 16 Elapsed Time: 1s
> 20030701 012357 16 Average Throughput: 142.50 MB/min
> 20030701 012357 16 Source Directory: dbasql@.MSGPSBM\model
> 20030701 012357 16 Back up Session 9 on Media Monthly2
> 20030701 012400 16 1 Databases/Transaction Logs (721 KB) Backed Up to
> Media.
> 20030701 012400 16 768 KB Written to Media.
> 20030701 012400 16 Elapsed Time: 1s
> 20030701 012400 16 Average Throughput: 45.00 MB/min
> 20030701 012400 16 Source Directory: dbasql@.MSGPSBM\master
> 20030701 012400 16 Back up Session 10 on Media Monthly2
> 20030701 012407 16 1 Databases/Transaction Logs (10.51 MB) Backed Up
> to Media.
> 20030701 012407 16 10.56 MB Written to Media.
> 20030701 012407 16 Elapsed Time: 0s
> 20030701 012407 16 Average Throughput: 633.75 MB/min
> 20030701 012407 16 Source Directory: dbasql@.MSGPSBM\DYNAMICS
> 20030701 012407 16 Back up Session 11 on Media Monthly2
> 20030701 012412 16 1 Databases/Transaction Logs (29.95 MB) Backed Up
> to Media.
> 20030701 012412 16 30.00 MB Written to Media.
> 20030701 012412 16 Elapsed Time: 3s
> 20030701 012412 16 Average Throughput: 600.00 MB/min
> 20030701 012413 16 Source Directory: System State
> 20030701 012413 16 Back up Session 12 on Media Monthly2
> 20030701 012413 16 Backing Up Files : Boot and System Protected Files
> 20030701 012445 16 Backing Up Files : Active Directory
> 20030701 012448 16 Backing Up Files : SysVol
> 20030701 012448 16 Backing Up Files : COM+ Class Registration Database
> 20030701 012448 16 Backing Up Files : Registry
> 20030701 012455 16 Registry Files Backed Up
> 20030701 012455 16 91 Directories 1,963 Files (287.99 MB) Backed Up to
> Media.
> 20030701 012455 16 294.56 MB Written to Media.
> 20030701 012455 16 Elapsed Time: 39s
> 20030701 012455 16 Average Throughput: 453.17 MB/min
> 20030701 012455 16 Source Directory: dbaxchg2
> 20030701 012455 16 Back up Session 13 on Media Monthly2
> 20030701 012516 16 11 Databases/Transaction Logs (40.19 MB) Backed Up
> to Media.
> 20030701 012516 16 40.50 MB Written to Media.
> 20030701 012516 16 Elapsed Time: 19s
> 20030701 012516 16 Average Throughput: 127.89 MB/min
> 20030701 012516 16 ** Summary for My Computer **
> 20030701 012516 16 13 Sessions.
> 20030701 012516 16 61,314 Directories 149,750 Files (6,198.15 MB)
> Backed Up to Media.
> 20030701 012516 16 18 Databases/Transaction Logs (824.89 MB) Backed Up
> to Media.
> 20030701 012516 16 8 Directories/Files Skipped.
> 20030701 012516 16 7,601.50 MB Written to Media.
> 20030701 012516 16 Elapsed Time: 22m 14s
> 20030701 012516 16 Average Throughput: 341.89 MB/min
> 20030701 012516 16 Number of Errors/Warnings: 0/8
> 20030701 012519 16 Backup ARCserve Database...
> 20030701 012520 16 Source Directory: C:\Program
> Files\ComputerAssociates\ARCserve\DATABASE
> 20030701 012520 16 Back up Session 14 on Media Monthly2
> 20030701 012529 16 Catalog File Backed Up
> 20030701 012529 16 1 Directories 118 Files (104.17 MB) Backed Up to
> Media.
> 20030701 012529 16 104.62 MB Written to Media.
> 20030701 012529 16 Elapsed Time: 7s
> 20030701 012529 16 Average Throughput: 896.78 MB/min
> 20030701 012529 16 ARCServe Database Backed Up
> 20030701 012538 [CAT] Monthly2 [ID:2542,SESSION:1] is
> merged.(files=17088)
> 20030701 012542 [CAT] Monthly2 [ID:2542,SESSION:2] is
> merged.(files=11142)
> 20030701 012555 [CAT] Monthly2 [ID:2542,SESSION:3] is
> merged.(files=23262)
> 20030701 012631 16 ** Summary for Job **
> 20030701 012631 16 14 Sessions.
> 20030701 012631 16 61,315 Directories 149,868 Files (6,302.33 MB)
> Backed Up to Media.
> 20030701 012631 16 18 Databases/Transaction Logs (824.89 MB) Backed Up
> to Media.
> 20030701 012631 16 8 Directories/Files Skipped.
> 20030701 012631 16 7,706.12 MB Written to Media.
> 20030701 012631 16 Elapsed Time: 22m 21s
> 20030701 012631 16 Average Throughput: 344.79 MB/min
> 20030701 012631 16 Number of Errors/Warnings: 0/8
> 20030701 012631 16 Backup Operation Incomplete.
> 20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:4] is
> merged.(files=96295)
> 20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:5] is merged.(files=5)
> 20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:6] is merged.(files=3)
> 20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:7] is merged.(files=3)
> 20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:8] is merged.(files=3)
> 20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:9] is merged.(files=3)
> 20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:10] is
> merged.(files=3)
> 20030701 012702 [CAT] Monthly2 [ID:2542,SESSION:11] is
> merged.(files=3)
> 20030701 012708 [CAT] Monthly2 [ID:2542,SESSION:12] is
> merged.(files=1963)
> 20030701 012708 [CAT] Monthly2 [ID:2542,SESSION:13] is
> merged.(files=110)
> 20030701 012708 [CAT] Monthly2 [ID:2542,SESSION:14] is
> merged.(files=118)
> 20030701 012709 16 Reschedule Backup Job for 7/02/03 at 1:00 AM.|||Hello,
Arcserver has an Open File Agent, as do most of these large backup software
products. This is supposed to allow the backing up of files that Andrew
says are always in use. It is my experience that this can be a hit and miss
affair and is one that I am not comfortable with. Yes I have been bitten by
it. I always now backup using SQL Server to a .bak file and have Arcserve.*
back that file up.
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
: You can't normally backup the database files with ArcServe since they are
: always in use. I believe they have a way to bypass that but then what
good
: is backing up a file that is constantly changing. You can't restore the
db
: using these backups made from Arcserve since they are not consistent.
What
: you can do is basically one of 2 things. Either use the SQL Server
plug-in
: for ArcServe to have it issue the equivalent of a sql server backup or
don't
: even attempt to backup the database files with Arcserve and have it backup
: the files generated by the SQL Server backup.
-- Microsoft Outlook Express 6.00.2800.1158|||Yes that is what I meant by bypass. Poor choice of word but it will allow
it to backup up the file anyway. That does no one any good since it is in
an inconsistent state database wise.
--
Andrew J. Kelly
SQL Server MVP
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OK7gauSQDHA.2852@.tk2msftngp13.phx.gbl...
> Hello,
> Arcserver has an Open File Agent, as do most of these large backup
software
> products. This is supposed to allow the backing up of files that Andrew
> says are always in use. It is my experience that this can be a hit and
miss
> affair and is one that I am not comfortable with. Yes I have been bitten
by
> it. I always now backup using SQL Server to a .bak file and have
Arcserve.*
> back that file up.
>
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> : You can't normally backup the database files with ArcServe since they
are
> : always in use. I believe they have a way to bypass that but then what
> good
> : is backing up a file that is constantly changing. You can't restore the
> db
> : using these backups made from Arcserve since they are not consistent.
> What
> : you can do is basically one of 2 things. Either use the SQL Server
> plug-in
> : for ArcServe to have it issue the equivalent of a sql server backup or
> don't
> : even attempt to backup the database files with Arcserve and have it
backup
> : the files generated by the SQL Server backup.
> -- Microsoft Outlook Express 6.00.2800.1158
>|||it might behoove you to test the viability of your recovery resources.
"Devin G" <devin@.spamhole.com> wrote in message
news:495ba422.0307031210.57474c7@.posting.google.com...
> From what I think:
> 1) The error messages during the beginning are because Arcserve is
> trying to backup the files on C:. These particular files are skipped
> doe to them being open and in use.
> 2) Later on during the backup I -think- Arcserve is backing up the
> database using the SQL agent which I installed. I can see that in the
> log.
>
> I was just wondering if this looks normal. Has anyone else used
> Arcserve? Is it normal to have the files skipped during the C: but
> then (it looks like) backed up during the SQL agent runs?
> Thanks|||I agree with that assessment but like I said, why bother to have it attempt
to backup those files (in the beginning) if you know they will only fail and
are useless anyway? And as nttp states, it wouldn't be a bad idea to
restore your backups somewhere to see if it's really doing what you hope it
is.
--
Andrew J. Kelly
SQL Server MVP
"Devin G" <devin@.spamhole.com> wrote in message
news:495ba422.0307031210.57474c7@.posting.google.com...
> From what I think:
> 1) The error messages during the beginning are because Arcserve is
> trying to backup the files on C:. These particular files are skipped
> doe to them being open and in use.
> 2) Later on during the backup I -think- Arcserve is backing up the
> database using the SQL agent which I installed. I can see that in the
> log.
>
> I was just wondering if this looks normal. Has anyone else used
> Arcserve? Is it normal to have the files skipped during the C: but
> then (it looks like) backed up during the SQL agent runs?
> Thanks
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment