sql server - When backup run on the schedule time 12am every night, It says the backup job completed successfully but I cannot see the backup file on the drive -

anybody have solution this. when backup run on schedule time 12am every night, says backup job completed cannot see backup file on drive.

job message details

date 10/6/2013 12:00:02 log job history (maintenancejob_fullbackup) step id 2 server sgksltusql04clt job name maintenancejob_fullbackup step name 2 - taking full backup of database duration 00:27:16 sql severity 0 sql message id 3014 operator emailed
operator net sent
operator paged
retries attempted 0

message executed user: xxx\yyy. ...e 'workforcedw' on file 1. [sqlstate 01000] (message 4035) processed 4 pages database 'workforcedw', file 'workforcedw_log' on file 1. [sqlstate 01000] (message 4035) backup database processed 1396804 pages in 118.187 seconds (96.817 mb/sec). [sqlstate 01000] (message 3014) processed 12616 pages database 'msdb', file 'msdbdata' on file 1. [sqlstate 01000] (message 4035) processed 8 pages database 'msdb', file 'msdblog' on file 1. [sqlstate 01000] (message 4035) backup database processed 12624 pages in 1.474 seconds (70.159 mb/sec). [sqlstate 01000] (message 3014) processed 160 pages database 'model', file 'modeldev' on file 1. [sqlstate 01000] (message 4035) processed 2 pages database 'model', file 'modellog' on file 1. [sqlstate 01000] (message 4035) backup database processed 162 pages in 0.300 seconds (4.410 mb/sec). [sqlstate 01000] (message 3014) processed 488 pages database... step succeeded.

but when run job manually, backups lying on drive. there no issue.

the job contains 3 2 steps;

1st step, delete previous day backup

2nd step - take full backup of database

error log info

2013-10-06 23:30:06.98 backup log backed up. database: bi_scm, creation date(time): 2011/06/01(17:33:39), first lsn: 1258:42:1, last lsn: 1260:42:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\bi_scm_201310062330.trn'}). informational message only. no user action required.

2013-10-06 23:30:07.34 backup log backed up. database: castorone, creation date(time): 2011/08/24(13:21:36), first lsn: 1165:42:1, last lsn: 1167:42:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\castorone_201310062330.trn'}). informational message only. no user action required.

2013-10-07 00:00:15.47 spid17s instance of sql server has been using process id of 11984 since 10/6/2013 1:01:43 (local) 10/5/2013 5:01:43 pm (utc). informational message only; no user action required.

2013-10-07 00:02:05.63 backup database backed up. database: workforcedw, creation date(time): 2013/05/16(11:05:26), pages dumped: 1398413, first lsn: 7664:61792:77, last lsn: 7664:61877:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\full backup\workforcedw_20131007_000006.bak'}). informational message only. no user action required.

2013-10-07 00:02:07.82 backup database backed up. database: msdb, creation date(time): 2005/10/14(01:54:05), pages dumped: 12705, first lsn: 160998:536:291, last lsn: 160998:728:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\full backup\msdb_20131007_000006.bak'}). informational message only. no user action required.

2013-10-07 00:02:08.66 backup database backed up. database: model, creation date(time): 2003/04/08(09:13:36), pages dumped: 179, first lsn: 325:304:37, last lsn: 325:328:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\full backup\model_20131007_000006.bak'}). informational message only. no user action required.

2013-10-07 00:02:09.62 backup database backed up. database: master, creation date(time): 2013/10/06(01:01:39), pages dumped: 523, first lsn: 19299:168:68, last lsn: 19299:208:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\full backup\master_20131007_000006.bak'}). informational message only. no user action required.

2013-10-07 00:02:11.20 backup database backed up. database: jde_moto, creation date(time): 2011/07/05(08:36:10), pages dumped: 9485, first lsn: 1330:45:37, last lsn: 1330:61:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\full backup\jde_moto_20131007_000006.bak'}). informational message only. no user action required.

2013-10-07 00:27:15.87 backup database backed up. database: isrpctr, creation date(time): 2008/11/29(09:14:29), pages dumped: 17088688, first lsn: 9274017:21496:124, last lsn: 9274018:8346:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\full backup\isrpctr_20131007_000006.bak'}). informational message only. no user action required.

2013-10-07 00:27:20.38 backup database backed up. database: distribution, creation date(time): 2008/11/12(10:54:54), pages dumped: 38947, first lsn: 293959:3426:111, last lsn: 293959:3495:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\full backup\distribution_20131007_000006.bak'}). informational message only. no user action required.

2013-10-07 00:27:21.36 backup database backed up. database: datamirror, creation date(time): 2008/11/12(13:45:51), pages dumped: 299, first lsn: 27820:44:37, last lsn: 27820:60:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\full backup\datamirror_20131007_000006.bak'}). informational message only. no user action required.

2013-10-07 00:27:22.34 backup database backed up. database: castorone, creation date(time): 2011/08/24(13:21:36), pages dumped: 1677, first lsn: 1167:44:37, last lsn: 1167:60:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\full backup\castorone_20131007_000006.bak'}). informational message only. no user action required.

2013-10-07 00:27:23.26 backup database backed up. database: bi_scm, creation date(time): 2011/06/01(17:33:39), pages dumped: 268, first lsn: 1260:44:37, last lsn: 1260:60:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\full backup\bi_scm_20131007_000006.bak'}). informational message only. no user action required.

2013-10-07 00:30:03.24 backup log backed up. database: datamirror, creation date(time): 2008/11/12(13:45:51),

first lsn: 27820:16:1, last lsn: 27820:66:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\datamirror_201310070030.trn'}). informational message only. no user action required.

2013-10-07 00:30:03.30 backup log backed up. database: jde_moto, creation date(time): 2011/07/05(08:36:10), first lsn: 1330:41:1, last lsn: 1330:67:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\jde_moto_201310070030.trn'}). informational message only. no user action required.

2013-10-07 00:30:04.17 backup log backed up. database: isrpctr, creation date(time): 2008/11/29(09:14:29), first lsn: 9274016:22762:1, last lsn: 9274018:8377:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\isrpctr_201310070030.trn'}). informational message only. no user action required.

2013-10-07 00:30:04.21 backup log backed up. database: bi_scm, creation date(time): 2011/06/01(17:33:39), first lsn: 1260:42:1, last lsn: 1260:66:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\bi_scm_201310070030.trn'}). informational message only. no user action required.

2013-10-07 00:30:04.25 backup log backed up. database: castorone, creation date(time): 2011/08/24(13:21:36), first lsn: 1167:42:1, last lsn: 1167:66:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\castorone_201310070030.trn'}). informational message only. no user action required.

2013-10-07 01:00:04.88 backup log backed up. database: datamirror, creation date(time): 2008/11/12(13:45:51), first lsn: 27820:66:1, last lsn: 27822:16:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\datamirror_201310070100.trn'}). informational message only. no user action required.

2013-10-07 01:00:05.47 backup log backed up. database: jde_moto, creation date(time): 2011/07/05(08:36:10), first lsn: 1330:67:1, last lsn: 1332:41:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\jde_moto_201310070100.trn'}). informational message only. no user action required.

2013-10-07 01:00:06.39 backup log backed up. database: isrpctr, creation date(time): 2008/11/29(09:14:29), first lsn: 9274018:8377:1, last lsn: 9274020:1617:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\isrpctr_201310070100.trn'}). informational message only. no user action required.

2013-10-07 01:00:06.58 backup log backed up. database: bi_scm, creation date(time): 2011/06/01(17:33:39), first lsn: 1260:66:1, last lsn: 1262:55:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\bi_scm_201310070100.trn'}). informational message only. no user action required.

2013-10-07 01:00:07.21 backup log backed up. database: castorone, creation date(time): 2011/08/24(13:21:36), first lsn: 1167:66:1, last lsn: 1169:41:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\castorone_201310070100.trn'}). informational message only. no user action required.

2013-10-07 01:30:04.74 backup log backed up. database: datamirror, creation date(time): 2008/11/12(13:45:51), first lsn: 27822:16:1, last lsn: 27824:16:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\datamirror_201310070130.trn'}). informational message only. no user action required.

2013-10-07 01:30:05.57 backup log backed up. database: jde_moto, creation date(time): 2011/07/05(08:36:10), first lsn: 1332:41:1, last lsn: 1334:16:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\jde_moto_201310070130.trn'}). informational message only. no user action required.

2013-10-07 01:30:06.54 backup log backed up. database: isrpctr, creation date(time): 2008/11/29(09:14:29), first lsn: 9274020:1617:1, last lsn: 9274022:880:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\isrpctr_201310070130.trn'}). informational message only. no user action required.

2013-10-07 01:30:07.05 backup log backed up. database: bi_scm, creation date(time): 2011/06/01(17:33:39), first lsn: 1262:55:1, last lsn: 1264:42:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\bi_scm_201310070130.trn'}). informational message only. no user action required.

2013-10-07 01:30:07.88 backup log backed up. database: castorone, creation date(time): 2011/08/24(13:21:36), first lsn: 1169:41:1, last lsn: 1171:41:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\castorone_201310070130.trn'}). informational message only. no user action required.

2013-10-07 01:46:17.16 spid143 configuration option 'user options' changed 0 0. run reconfigure statement install.

2013-10-07 01:46:23.77 spid211 dbcc checkdb (distribution, noindex) executed sa found 0 errors , repaired 0 errors. elapsed time: 0 hours 0 minutes 6 seconds. 2013-10-07 02:00:05.41 backup log backed up. database: datamirror, creation date(time): 2008/11/12(13:45:51), first lsn: 27824:16:1, last lsn: 27826:16:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\datamirror_201310070200.trn'}). informational message only. no user action required.

2013-10-07 02:00:07.21 backup log backed up. database: jde_moto, creation date(time): 2011/07/05(08:36:10), first lsn: 1334:16:1, last lsn: 1336:16:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\jde_moto_201310070200.trn'}). informational message only. no user action required.

2013-10-07 02:00:08.26 backup log backed up. database: isrpctr, creation date(time): 2008/11/29(09:14:29), first lsn: 9274022:880:1, last lsn: 9274024:141:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\isrpctr_201310070200.trn'}). informational message only. no user action required.

2013-10-07 02:00:09.21 backup log backed up. database: bi_scm, creation date(time): 2011/06/01(17:33:39), first lsn: 1264:42:1, last lsn: 1266:42:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\bi_scm_201310070200.trn'}). informational message only. no user action required.

2013-10-07 02:00:10.31 backup log backed up. database: castorone, creation date(time): 2011/08/24(13:21:36), first lsn: 1171:41:1, last lsn: 1173:41:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\castorone_201310070200.trn'}). informational message only. no user action required.

2013-10-07 02:12:56.81 spid211 dbcc checkdb (isrpctr, noindex) executed sa found 0 errors , repaired 0 errors. elapsed time: 0 hours 26 minutes 32 seconds.

2013-10-07 02:15:31.37 spid218 replication-replication distribution subsystem: agent sgksltusql04clt-isrpctr-ddo-sgkfepydbs02029-68 scheduled retry. tcp provider: semaphore timeout period has expired.

2013-10-07 02:30:05.61 backup log backed up. database: datamirror, creation date(time): 2008/11/12(13:45:51), first lsn: 27826:16:1, last lsn: 27828:16:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\datamirror_201310070230.trn'}). informational message only. no user action required.

2013-10-07 02:30:06.17 backup log backed up. database: jde_moto, creation date(time): 2011/07/05(08:36:10), first lsn: 1336:16:1, last lsn: 1338:41:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\jde_moto_201310070230.trn'}). informational message only. no user action required.

2013-10-07 02:30:06.75 backup log backed up. database: isrpctr, creation date(time): 2008/11/29(09:14:29), first lsn: 9274024:141:1, last lsn: 9274026:98:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\isrpctr_201310070230.trn'}). informational message only. no user action required.

2013-10-07 02:30:07.35 backup log backed up. database: bi_scm, creation date(time): 2011/06/01(17:33:39), first lsn: 1266:42:1, last lsn: 1268:41:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\bi_scm_201310070230.trn'}). informational message only. no user action required.

2013-10-07 02:30:08.08 backup log backed up. database: castorone, creation date(time): 2011/08/24(13:21:36), first lsn: 1173:41:1, last lsn: 1175:16:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\castorone_201310070230.trn'}). informational message only. no user action required.

2013-10-07 03:00:04.39 backup log backed up. database: datamirror, creation date(time): 2008/11/12(13:45:51), first lsn: 27828:16:1, last lsn: 27828:42:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\datamirror_201310070300.trn'}). informational message only. no user action required.

2013-10-07 03:00:04.45 backup log backed up. database: jde_moto, creation date(time): 2011/07/05(08:36:10), first lsn: 1338:41:1, last lsn: 1338:43:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\jde_moto_201310070300.trn'}). informational message only. no user action required.

2013-10-07 03:00:04.55 backup log backed up. database: isrpctr, creation date(time): 2008/11/29(09:14:29), first lsn: 9274026:98:1, last lsn: 9274026:2323:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\isrpctr_201310070300.trn'}). informational message only. no user action required.

2013-10-07 03:00:04.59 backup log backed up. database: bi_scm, creation date(time): 2011/06/01(17:33:39), first lsn: 1268:41:1, last lsn: 1268:43:1, number of dump devices: 1, device information: (file=1, type=disk: {'g:\backup\log backup\bi_scm_201310070300.trn'}). informational message only. no user action required.'

i assume g: network share located on drive? if so, 'g:' might pointing different path under whatever account sql server service running under. can run following command in sql server management studio (or sqlcmd.exe):

exec xp_cmdshell 'dir "g:\backup\full backup"'; 

this should show content of folder used sql server when performing backup.