What are the challenges you face when working across database platforms? Take the survey
Options

Deleting files after restoring logs

Jeff RandallJeff Randall Posts: 41
edited March 17, 2006 2:44PM in SQL Backup Previous Versions
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-sql "RESTORE LOG [PEPPER_ic001Prd] FROM DISK = ''\\beet\d$\sqlbackups\atlanta\PEPPER_ic001Prd_*.sqb'' WITH STANDBY = ''D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\UNDO_PEPPER_ic001Prd.DAT'', ERASEFILES = 1h, FILEOPTIONS = 1, MOVETO = ''\\beet\d$\sqlbackups\Complete''"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
IF (@exitcode <>0) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup job failed with exitcode: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END


I believe that this SHOULD delete files from \\beet\d$\sqlbackups\Complete\ older than 1 hour, but it does not delelte them... Can somebody spot what I'm doing wrong?

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Does the SQL Backup Agent service account has read and deletion rights to the [\\beet\d$\sqlbackups\Complete] folder?

    Try running the following from Query Analyzer:

    exec master..sqbutility 999, 'RWE', '\\beet\d$\sqlbackups\Complete'

    Or if the SQL Backup service user is identical to that of the SQL Server service user, try the following:

    xp_cmdshell 'dir \\beet\d$\sqlbackups\Complete'

    To test deletion, you can create a text file in that folder, and try to delete it e.g.

    xp_cmdshell 'erase \\beet\d$\sqlbackups\Complete\<filename>'
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    petey wrote:
    exec master..sqbutility 999, 'RWE', '\\beet\d$\sqlbackups\Complete'
    <SQBUTILITYRESULT>:1:
    petey wrote:
    xp_cmdshell 'dir \\beet\d$\sqlbackups\Complete'
    Volume in drive \\beet\d$ is Data
    Volume Serial Number is 20B1-FE87
    NULL
    Directory of \\beet\d$\sqlbackups\Complete
    NULL
    03/17/2006 09:40 AM <DIR> .
    03/17/2006 09:40 AM <DIR> ..
    03/13/2006 09:02 AM 1,296,384 PEPPER_ic001prd_20060313_090200.sqb
    03/13/2006 09:17 AM 998,400 PEPPER_ic001prd_20060313_091700.sqb
    03/13/2006 09:32 AM 1,120,768 PEPPER_ic001prd_20060313_093201.sqb
    03/13/2006 09:47 AM 1,239,040 PEPPER_ic001prd_20060313_094700.sqb
    03/13/2006 10:02 AM 1,314,304 PEPPER_ic001prd_20060313_100200.sqb
    03/13/2006 10:17 AM 1,258,496 PEPPER_ic001prd_20060313_101700.sqb
    03/13/2006 10:32 AM 1,786,880 PEPPER_ic001prd_20060313_103200.sqb
    03/13/2006 10:47 AM 1,359,360 PEPPER_ic001prd_20060313_104700.sqb
    03/13/2006 11:02 AM 1,575,936 PEPPER_ic001prd_20060313_110200.sqb
    03/13/2006 11:17 AM 1,230,336 PEPPER_ic001prd_20060313_111703.sqb
    03/13/2006 11:32 AM 1,519,616 PEPPER_ic001prd_20060313_113200.sqb
    03/13/2006 11:47 AM 1,687,040 PEPPER_ic001prd_20060313_114700.sqb
    03/13/2006 12:02 PM 1,881,088 PEPPER_ic001prd_20060313_120200.sqb
    03/13/2006 12:17 PM 1,616,896 PEPPER_ic001prd_20060313_121700.sqb
    03/13/2006 12:32 PM 2,599,936 PEPPER_ic001prd_20060313_123200.sqb
    03/13/2006 12:47 PM 1,771,008 PEPPER_ic001prd_20060313_124700.sqb
    03/13/2006 01:02 PM 1,513,984 PEPPER_ic001prd_20060313_130200.sqb
    03/13/2006 01:17 PM 1,575,936 PEPPER_ic001prd_20060313_131700.sqb
    03/13/2006 01:32 PM 1,246,720 PEPPER_ic001prd_20060313_133200.sqb
    03/13/2006 01:47 PM 1,557,504 PEPPER_ic001prd_20060313_134700.sqb
    03/13/2006 02:02 PM 1,451,008 PEPPER_ic001prd_20060313_140200.sqb
    03/13/2006 02:17 PM 1,401,856 PEPPER_ic001prd_20060313_141700.sqb
    03/13/2006 02:32 PM 1,337,856 PEPPER_ic001prd_20060313_143200.sqb
    03/13/2006 02:47 PM 1,707,520 PEPPER_ic001prd_20060313_144700.sqb
    03/13/2006 03:02 PM 1,709,056 PEPPER_ic001prd_20060313_150200.sqb
    03/13/2006 03:17 PM 1,369,088 PEPPER_ic001prd_20060313_151700.sqb
    03/13/2006 03:32 PM 1,494,528 PEPPER_ic001prd_20060313_153200.sqb
    03/13/2006 03:47 PM 1,435,136 PEPPER_ic001prd_20060313_154700.sqb
    03/13/2006 04:02 PM 1,431,552 PEPPER_ic001prd_20060313_160200.sqb
    03/13/2006 04:17 PM 1,430,528 PEPPER_ic001prd_20060313_161700.sqb
    03/13/2006 04:32 PM 1,145,344 PEPPER_ic001prd_20060313_163200.sqb
    03/13/2006 04:47 PM 1,654,272 PEPPER_ic001prd_20060313_164700.sqb
    03/13/2006 05:02 PM 1,505,792 PEPPER_ic001prd_20060313_170200.sqb
    03/13/2006 05:17 PM 1,847,808 PEPPER_ic001prd_20060313_171700.sqb
    03/13/2006 05:32 PM 1,366,016 PEPPER_ic001prd_20060313_173200.sqb
    03/13/2006 05:47 PM 1,378,816 PEPPER_ic001prd_20060313_174700.sqb
    03/13/2006 06:02 PM 1,312,256 PEPPER_ic001prd_20060313_180200.sqb
    03/13/2006 06:17 PM 1,009,152 PEPPER_ic001prd_20060313_181700.sqb
    03/13/2006 06:32 PM 1,288,704 PEPPER_ic001prd_20060313_183200.sqb
    03/13/2006 06:47 PM 1,307,136 PEPPER_ic001prd_20060313_184700.sqb
    03/13/2006 07:02 PM 1,250,304 PEPPER_ic001prd_20060313_190200.sqb
    03/13/2006 07:17 PM 1,192,960 PEPPER_ic001prd_20060313_191700.sqb
    03/13/2006 07:32 PM 1,362,432 PEPPER_ic001prd_20060313_193200.sqb
    03/13/2006 07:47 PM 1,483,776 PEPPER_ic001prd_20060313_194700.sqb
    03/13/2006 08:02 PM 1,451,008 PEPPER_ic001prd_20060313_200200.sqb
    03/13/2006 08:17 PM 1,308,160 PEPPER_ic001prd_20060313_201700.sqb
    03/13/2006 08:32 PM 1,211,904 PEPPER_ic001prd_20060313_203200.sqb
    03/13/2006 08:47 PM 1,305,088 PEPPER_ic001prd_20060313_204700.sqb
    03/13/2006 09:02 PM 1,489,920 PEPPER_ic001prd_20060313_210200.sqb
    03/13/2006 09:17 PM 1,078,784 PEPPER_ic001prd_20060313_211700.sqb
    03/13/2006 09:32 PM 1,241,088 PEPPER_ic001prd_20060313_213200.sqb
    03/13/2006 09:47 PM 1,122,816 PEPPER_ic001prd_20060313_214700.sqb
    03/14/2006 12:02 AM 14,229,504 PEPPER_ic001prd_20060314_000200.sqb
    03/14/2006 12:17 AM 6,381,056 PEPPER_ic001prd_20060314_001700.sqb
    03/14/2006 12:32 AM 1,296,896 PEPPER_ic001prd_20060314_003200.sqb
    03/14/2006 12:47 AM 1,040,384 PEPPER_ic001prd_20060314_004700.sqb
    03/14/2006 01:02 AM 1,259,008 PEPPER_ic001prd_20060314_010201.sqb
    03/14/2006 01:17 AM 1,076,224 PEPPER_ic001prd_20060314_011700.sqb
    03/14/2006 01:32 AM 915,968 PEPPER_ic001prd_20060314_013200.sqb
    03/14/2006 01:47 AM 913,920 PEPPER_ic001prd_20060314_014700.sqb
    03/14/2006 02:02 AM 1,228,800 PEPPER_ic001prd_20060314_020200.sqb
    03/14/2006 02:17 AM 869,376 PEPPER_ic001prd_20060314_021700.sqb
    03/14/2006 02:32 AM 741,376 PEPPER_ic001prd_20060314_023201.sqb
    03/14/2006 02:47 AM 862,720 PEPPER_ic001prd_20060314_024701.sqb
    03/14/2006 03:02 AM 879,104 PEPPER_ic001prd_20060314_030200.sqb
    03/14/2006 03:17 AM 723,456 PEPPER_ic001prd_20060314_031705.sqb
    03/14/2006 03:32 AM 674,816 PEPPER_ic001prd_20060314_033206.sqb
    03/14/2006 03:47 AM 866,304 PEPPER_ic001prd_20060314_034700.sqb
    03/14/2006 04:02 AM 904,704 PEPPER_ic001prd_20060314_040201.sqb
    03/14/2006 04:17 AM 578,560 PEPPER_ic001prd_20060314_041700.sqb
    03/14/2006 04:32 AM 707,072 PEPPER_ic001prd_20060314_043200.sqb
    03/14/2006 04:47 AM 500,224 PEPPER_ic001prd_20060314_044700.sqb
    03/14/2006 05:02 AM 656,896 PEPPER_ic001prd_20060314_050200.sqb
    03/14/2006 05:17 AM 584,192 PEPPER_ic001prd_20060314_051701.sqb
    03/14/2006 05:32 AM 473,600 PEPPER_ic001prd_20060314_053200.sqb
    03/14/2006 05:47 AM 325,632 PEPPER_ic001prd_20060314_054700.sqb
    03/14/2006 06:02 AM 9,026,560 PEPPER_ic001prd_20060314_060201.sqb
    03/14/2006 06:17 AM 81,245,696 PEPPER_ic001prd_20060314_061700.sqb
    03/14/2006 06:32 AM 39,567,360 PEPPER_ic001prd_20060314_063200.sqb
    03/14/2006 06:47 AM 10,042,880 PEPPER_ic001prd_20060314_064700.sqb
    03/14/2006 07:02 AM 403,456 PEPPER_ic001prd_20060314_070200.sqb
    03/14/2006 07:17 AM 330,240 PEPPER_ic001prd_20060314_071700.sqb
    03/14/2006 07:32 AM 470,016 PEPPER_ic001prd_20060314_073200.sqb
    03/14/2006 07:47 AM 519,680 PEPPER_ic001prd_20060314_074700.sqb
    03/14/2006 08:02 AM 586,752 PEPPER_ic001prd_20060314_080200.sqb
    03/14/2006 08:17 AM 752,128 PEPPER_ic001prd_20060314_081700.sqb
    03/14/2006 08:32 AM 786,432 PEPPER_ic001prd_20060314_083200.sqb
    03/14/2006 08:47 AM 657,920 PEPPER_ic001prd_20060314_084700.sqb
    03/14/2006 09:02 AM 936,960 PEPPER_ic001prd_20060314_090200.sqb
    03/14/2006 09:17 AM 861,184 PEPPER_ic001prd_20060314_091700.sqb
    03/14/2006 09:32 AM 980,992 PEPPER_ic001prd_20060314_093200.sqb
    03/14/2006 09:47 AM 1,150,976 PEPPER_ic001prd_20060314_094700.sqb
    03/14/2006 10:02 AM 1,126,912 PEPPER_ic001prd_20060314_100200.sqb
    03/14/2006 10:17 AM 1,222,144 PEPPER_ic001prd_20060314_101700.sqb
    03/14/2006 10:32 AM 1,726,464 PEPPER_ic001prd_20060314_103200.sqb
    03/14/2006 10:47 AM 1,419,264 PEPPER_ic001prd_20060314_104700.sqb
    03/14/2006 11:02 AM 1,895,424 PEPPER_ic001prd_20060314_110200.sqb
    03/14/2006 11:17 AM 2,022,400 PEPPER_ic001prd_20060314_111700.sqb
    03/14/2006 11:32 AM 1,482,752 PEPPER_ic001prd_20060314_113200.sqb
    03/14/2006 11:47 AM 1,352,704 PEPPER_ic001prd_20060314_114700.sqb
    03/14/2006 12:02 PM 1,538,560 PEPPER_ic001prd_20060314_120200.sqb
    03/14/2006 12:17 PM 1,316,352 PEPPER_ic001prd_20060314_121700.sqb
    03/14/2006 12:32 PM 1,444,352 PEPPER_ic001prd_20060314_123200.sqb
    03/14/2006 12:47 PM 1,557,504 PEPPER_ic001prd_20060314_124700.sqb
    03/14/2006 01:02 PM 1,451,008 PEPPER_ic001prd_20060314_130200.sqb
    03/14/2006 01:17 PM 1,686,528 PEPPER_ic001prd_20060314_131700.sqb
    03/14/2006 01:32 PM 1,812,480 PEPPER_ic001prd_20060314_133200.sqb
    03/14/2006 01:47 PM 1,852,928 PEPPER_ic001prd_20060314_134700.sqb
    03/14/2006 02:02 PM 1,793,024 PEPPER_ic001prd_20060314_140200.sqb
    03/14/2006 02:17 PM 1,653,248 PEPPER_ic001prd_20060314_141700.sqb
    03/14/2006 02:32 PM 2,017,792 PEPPER_ic001prd_20060314_143200.sqb
    03/14/2006 02:47 PM 1,795,072 PEPPER_ic001prd_20060314_144700.sqb
    03/14/2006 03:02 PM 1,718,272 PEPPER_ic001prd_20060314_150200.sqb
    03/14/2006 03:17 PM 1,882,112 PEPPER_ic001prd_20060314_151700.sqb
    03/14/2006 03:32 PM 1,585,152 PEPPER_ic001prd_20060314_153200.sqb
    03/14/2006 03:47 PM 1,977,856 PEPPER_ic001prd_20060314_154700.sqb
    03/14/2006 04:02 PM 2,057,216 PEPPER_ic001prd_20060314_160200.sqb
    03/14/2006 04:17 PM 2,015,232 PEPPER_ic001prd_20060314_161700.sqb
    03/14/2006 04:32 PM 2,200,064 PEPPER_ic001prd_20060314_163200.sqb
    03/14/2006 04:47 PM 1,896,448 PEPPER_ic001prd_20060314_164700.sqb
    03/14/2006 05:02 PM 1,777,152 PEPPER_ic001prd_20060314_170200.sqb
    03/14/2006 05:17 PM 3,192,832 PEPPER_ic001prd_20060314_171700.sqb
    03/14/2006 05:32 PM 3,558,400 PEPPER_ic001prd_20060314_173200.sqb
    03/14/2006 05:47 PM 1,693,184 PEPPER_ic001prd_20060314_174700.sqb
    03/14/2006 06:02 PM 1,761,280 PEPPER_ic001prd_20060314_180200.sqb
    03/14/2006 06:17 PM 1,739,264 PEPPER_ic001prd_20060314_181700.sqb
    03/14/2006 06:32 PM 1,590,784 PEPPER_ic001prd_20060314_183200.sqb
    03/14/2006 06:47 PM 1,338,880 PEPPER_ic001prd_20060314_184700.sqb
    03/14/2006 07:02 PM 1,671,680 PEPPER_ic001prd_20060314_190200.sqb
    03/14/2006 07:17 PM 1,500,160 PEPPER_ic001prd_20060314_191700.sqb
    03/14/2006 07:32 PM 1,574,912 PEPPER_ic001prd_20060314_193200.sqb
    03/14/2006 07:47 PM 1,599,488 PEPPER_ic001prd_20060314_194701.sqb
    03/14/2006 08:02 PM 1,415,680 PEPPER_ic001prd_20060314_200200.sqb
    03/14/2006 08:17 PM 1,648,128 PEPPER_ic001prd_20060314_201700.sqb
    03/14/2006 08:32 PM 1,302,528 PEPPER_ic001prd_20060314_203200.sqb
    03/14/2006 08:47 PM 1,729,536 PEPPER_ic001prd_20060314_204700.sqb
    03/14/2006 09:02 PM 1,953,792 PEPPER_ic001prd_20060314_210200.sqb
    03/14/2006 09:17 PM 1,751,552 PEPPER_ic001prd_20060314_211700.sqb
    03/14/2006 09:32 PM 1,717,760 PEPPER_ic001prd_20060314_213200.sqb
    03/14/2006 09:47 PM 1,807,872 PEPPER_ic001prd_20060314_214700.sqb
    03/15/2006 12:02 AM 17,073,152 PEPPER_ic001prd_20060315_000200.sqb
    03/15/2006 12:17 AM 6,635,008 PEPPER_ic001prd_20060315_001700.sqb
    03/15/2006 12:32 AM 1,547,264 PEPPER_ic001prd_20060315_003200.sqb
    03/15/2006 12:47 AM 1,445,376 PEPPER_ic001prd_20060315_004700.sqb
    03/15/2006 01:02 AM 1,972,736 PEPPER_ic001prd_20060315_010201.sqb
    03/15/2006 01:17 AM 1,891,840 PEPPER_ic001prd_20060315_011700.sqb
    03/15/2006 01:32 AM 1,496,576 PEPPER_ic001prd_20060315_013200.sqb
    03/15/2006 01:47 AM 1,442,816 PEPPER_ic001prd_20060315_014700.sqb
    03/15/2006 02:02 AM 1,934,848 PEPPER_ic001prd_20060315_020200.sqb
    03/15/2006 02:17 AM 1,454,080 PEPPER_ic001prd_20060315_021701.sqb
    03/15/2006 02:32 AM 1,465,856 PEPPER_ic001prd_20060315_023201.sqb
    03/15/2006 02:47 AM 1,175,040 PEPPER_ic001prd_20060315_024701.sqb
    03/15/2006 03:02 AM 1,380,864 PEPPER_ic001prd_20060315_030202.sqb
    03/15/2006 03:17 AM 1,231,872 PEPPER_ic001prd_20060315_031704.sqb
    03/15/2006 03:32 AM 1,147,904 PEPPER_ic001prd_20060315_033204.sqb
    03/15/2006 03:47 AM 1,401,344 PEPPER_ic001prd_20060315_034700.sqb
    03/15/2006 04:02 AM 1,246,720 PEPPER_ic001prd_20060315_040200.sqb
    03/15/2006 04:17 AM 1,157,120 PEPPER_ic001prd_20060315_041700.sqb
    03/15/2006 04:32 AM 1,177,600 PEPPER_ic001prd_20060315_043200.sqb
    03/15/2006 04:47 AM 798,208 PEPPER_ic001prd_20060315_044700.sqb
    03/15/2006 05:02 AM 798,208 PEPPER_ic001prd_20060315_050201.sqb
    03/15/2006 05:17 AM 753,152 PEPPER_ic001prd_20060315_051700.sqb
    03/15/2006 05:32 AM 660,480 PEPPER_ic001prd_20060315_053200.sqb
    03/15/2006 05:47 AM 837,120 PEPPER_ic001prd_20060315_054700.sqb
    03/15/2006 06:02 AM 9,656,832 PEPPER_ic001prd_20060315_060200.sqb
    03/15/2006 06:17 AM 85,882,368 PEPPER_ic001prd_20060315_061703.sqb
    03/15/2006 06:32 AM 45,670,912 PEPPER_ic001prd_20060315_063201.sqb
    03/15/2006 06:47 AM 950,272 PEPPER_ic001prd_20060315_064700.sqb
    03/15/2006 07:02 AM 773,632 PEPPER_ic001prd_20060315_070200.sqb
    03/15/2006 07:17 AM 502,784 PEPPER_ic001prd_20060315_071700.sqb
    03/15/2006 07:32 AM 864,768 PEPPER_ic001prd_20060315_073200.sqb
    03/15/2006 07:47 AM 763,392 PEPPER_ic001prd_20060315_074700.sqb
    03/15/2006 08:02 AM 1,125,376 PEPPER_ic001prd_20060315_080200.sqb
    03/15/2006 08:17 AM 1,161,216 PEPPER_ic001prd_20060315_081700.sqb
    03/15/2006 08:32 AM 1,693,184 PEPPER_ic001prd_20060315_083200.sqb
    03/15/2006 08:47 AM 1,466,368 PEPPER_ic001prd_20060315_084700.sqb
    03/15/2006 09:02 AM 1,444,352 PEPPER_ic001prd_20060315_090200.sqb
    03/15/2006 09:17 AM 1,371,648 PEPPER_ic001prd_20060315_091700.sqb
    03/15/2006 09:32 AM 1,642,496 PEPPER_ic001prd_20060315_093200.sqb
    03/15/2006 09:47 AM 1,720,320 PEPPER_ic001prd_20060315_094700.sqb
    03/15/2006 10:02 AM 1,686,016 PEPPER_ic001prd_20060315_100200.sqb
    03/15/2006 10:17 AM 1,709,056 PEPPER_ic001prd_20060315_101700.sqb
    03/15/2006 10:32 AM 1,587,200 PEPPER_ic001prd_20060315_103200.sqb
    03/15/2006 10:47 AM 1,724,416 PEPPER_ic001prd_20060315_104700.sqb
    03/15/2006 11:02 AM 1,840,128 PEPPER_ic001prd_20060315_110200.sqb
    03/15/2006 11:17 AM 1,836,032 PEPPER_ic001prd_20060315_111700.sqb
    03/15/2006 11:32 AM 1,861,120 PEPPER_ic001prd_20060315_113200.sqb
    03/15/2006 11:47 AM 2,001,920 PEPPER_ic001prd_20060315_114700.sqb
    03/15/2006 12:02 PM 2,118,144 PEPPER_ic001prd_20060315_120200.sqb
    03/15/2006 12:17 PM 2,149,376 PEPPER_ic001prd_20060315_121700.sqb
    03/15/2006 12:32 PM 2,234,880 PEPPER_ic001prd_20060315_123200.sqb
    03/15/2006 12:47 PM 2,052,608 PEPPER_ic001prd_20060315_124701.sqb
    03/15/2006 01:02 PM 2,177,536 PEPPER_ic001prd_20060315_130200.sqb
    03/15/2006 01:17 PM 2,131,968 PEPPER_ic001prd_20060315_131700.sqb
    03/15/2006 01:32 PM 1,969,152 PEPPER_ic001prd_20060315_133200.sqb
    03/15/2006 01:47 PM 2,768,896 PEPPER_ic001prd_20060315_134700.sqb
    03/15/2006 02:02 PM 3,205,632 PEPPER_ic001prd_20060315_140200.sqb
    03/15/2006 02:17 PM 2,322,944 PEPPER_ic001prd_20060315_141700.sqb
    03/15/2006 02:32 PM 2,276,864 PEPPER_ic001prd_20060315_143200.sqb
    03/15/2006 02:47 PM 2,207,232 PEPPER_ic001prd_20060315_144700.sqb
    03/15/2006 03:02 PM 2,668,032 PEPPER_ic001prd_20060315_150200.sqb
    03/15/2006 03:17 PM 2,529,280 PEPPER_ic001prd_20060315_151700.sqb
    03/15/2006 03:32 PM 2,390,016 PEPPER_ic001prd_20060315_153200.sqb
    03/15/2006 03:47 PM 2,232,320 PEPPER_ic001prd_20060315_154700.sqb
    03/15/2006 04:02 PM 2,347,520 PEPPER_ic001prd_20060315_160200.sqb
    03/15/2006 04:17 PM 2,319,872 PEPPER_ic001prd_20060315_161700.sqb
    03/15/2006 04:32 PM 2,626,048 PEPPER_ic001prd_20060315_163201.sqb
    03/15/2006 04:47 PM 2,235,904 PEPPER_ic001prd_20060315_164700.sqb
    03/15/2006 05:02 PM 2,305,536 PEPPER_ic001prd_20060315_170200.sqb
    03/15/2006 05:17 PM 2,387,968 PEPPER_ic001prd_20060315_171700.sqb
    03/15/2006 05:32 PM 2,156,032 PEPPER_ic001prd_20060315_173200.sqb
    03/15/2006 05:47 PM 2,531,328 PEPPER_ic001prd_20060315_174700.sqb
    03/15/2006 06:02 PM 2,527,744 PEPPER_ic001prd_20060315_180200.sqb
    03/15/2006 06:17 PM 2,484,224 PEPPER_ic001prd_20060315_181700.sqb
    03/15/2006 06:32 PM 2,293,248 PEPPER_ic001prd_20060315_183200.sqb
    03/15/2006 06:47 PM 2,153,472 PEPPER_ic001prd_20060315_184700.sqb
    03/15/2006 07:02 PM 2,451,456 PEPPER_ic001prd_20060315_190200.sqb
    03/15/2006 07:17 PM 2,774,016 PEPPER_ic001prd_20060315_191700.sqb
    03/15/2006 07:32 PM 2,699,264 PEPPER_ic001prd_20060315_193200.sqb
    03/15/2006 07:47 PM 2,548,736 PEPPER_ic001prd_20060315_194700.sqb
    03/15/2006 08:02 PM 2,659,328 PEPPER_ic001prd_20060315_200200.sqb
    03/15/2006 08:17 PM 1,495,552 PEPPER_ic001prd_20060315_201700.sqb
    03/15/2006 08:32 PM 1,629,696 PEPPER_ic001prd_20060315_203200.sqb
    03/15/2006 08:47 PM 1,601,024 PEPPER_ic001prd_20060315_204700.sqb
    03/15/2006 09:02 PM 1,796,608 PEPPER_ic001prd_20060315_210200.sqb
    03/15/2006 09:17 PM 1,901,568 PEPPER_ic001prd_20060315_211700.sqb
    03/15/2006 09:32 PM 1,933,824 PEPPER_ic001prd_20060315_213200.sqb
    03/15/2006 09:47 PM 1,810,432 PEPPER_ic001prd_20060315_214700.sqb
    03/16/2006 12:02 AM 17,769,472 PEPPER_ic001prd_20060316_000200.sqb
    03/16/2006 12:17 AM 6,679,040 PEPPER_ic001prd_20060316_001700.sqb
    03/16/2006 12:32 AM 958,976 PEPPER_ic001prd_20060316_003200.sqb
    03/16/2006 12:47 AM 1,116,672 PEPPER_ic001prd_20060316_004700.sqb
    03/16/2006 01:02 AM 1,061,888 PEPPER_ic001prd_20060316_010200.sqb
    03/16/2006 01:17 AM 928,256 PEPPER_ic001prd_20060316_011700.sqb
    03/16/2006 01:32 AM 686,592 PEPPER_ic001prd_20060316_013200.sqb
    03/16/2006 01:47 AM 763,392 PEPPER_ic001prd_20060316_014700.sqb
    03/16/2006 02:02 AM 1,183,232 PEPPER_ic001prd_20060316_020200.sqb
    03/16/2006 02:17 AM 668,672 PEPPER_ic001prd_20060316_021700.sqb
    03/16/2006 02:32 AM 697,856 PEPPER_ic001prd_20060316_023201.sqb
    03/16/2006 02:47 AM 847,872 PEPPER_ic001prd_20060316_024701.sqb
    03/16/2006 03:02 AM 1,095,168 PEPPER_ic001prd_20060316_030200.sqb
    03/16/2006 03:17 AM 374,784 PEPPER_ic001prd_20060316_031700.sqb
    03/16/2006 03:32 AM 305,152 PEPPER_ic001prd_20060316_033206.sqb
    03/16/2006 03:47 AM 327,168 PEPPER_ic001prd_20060316_034702.sqb
    03/16/2006 04:02 AM 779,264 PEPPER_ic001prd_20060316_040200.sqb
    03/16/2006 04:17 AM 549,888 PEPPER_ic001prd_20060316_041700.sqb
    03/16/2006 04:32 AM 410,112 PEPPER_ic001prd_20060316_043200.sqb
    03/16/2006 04:47 AM 169,984 PEPPER_ic001prd_20060316_044700.sqb
    03/16/2006 05:02 AM 214,528 PEPPER_ic001prd_20060316_050200.sqb
    03/16/2006 05:17 AM 130,560 PEPPER_ic001prd_20060316_051700.sqb
    03/16/2006 05:32 AM 102,400 PEPPER_ic001prd_20060316_053200.sqb
    03/16/2006 05:47 AM 74,752 PEPPER_ic001prd_20060316_054700.sqb
    03/16/2006 06:02 AM 8,958,976 PEPPER_ic001prd_20060316_060211.sqb
    03/16/2006 06:17 AM 88,390,144 PEPPER_ic001prd_20060316_061700.sqb
    03/16/2006 06:32 AM 41,991,168 PEPPER_ic001prd_20060316_063201.sqb
    03/16/2006 06:47 AM 197,632 PEPPER_ic001prd_20060316_064700.sqb
    03/16/2006 07:02 AM 226,304 PEPPER_ic001prd_20060316_070200.sqb
    03/16/2006 07:17 AM 169,472 PEPPER_ic001prd_20060316_071700.sqb
    03/16/2006 07:32 AM 180,224 PEPPER_ic001prd_20060316_073200.sqb
    03/16/2006 07:47 AM 221,696 PEPPER_ic001prd_20060316_074700.sqb
    03/16/2006 08:02 AM 429,568 PEPPER_ic001prd_20060316_080200.sqb
    03/16/2006 08:17 AM 293,376 PEPPER_ic001prd_20060316_081700.sqb
    03/16/2006 08:32 AM 605,696 PEPPER_ic001prd_20060316_083200.sqb
    03/16/2006 08:47 AM 267,776 PEPPER_ic001prd_20060316_084700.sqb
    03/16/2006 09:02 AM 593,408 PEPPER_ic001prd_20060316_090200.sqb
    03/16/2006 09:17 AM 603,648 PEPPER_ic001prd_20060316_091701.sqb
    03/16/2006 09:32 AM 568,832 PEPPER_ic001prd_20060316_093200.sqb
    03/16/2006 09:47 AM 807,936 PEPPER_ic001prd_20060316_094700.sqb
    03/16/2006 10:02 AM 621,568 PEPPER_ic001prd_20060316_100200.sqb
    03/16/2006 10:17 AM 658,432 PEPPER_ic001prd_20060316_101700.sqb
    03/16/2006 10:32 AM 760,320 PEPPER_ic001prd_20060316_103200.sqb
    03/16/2006 10:47 AM 736,256 PEPPER_ic001prd_20060316_104700.sqb
    03/16/2006 11:02 AM 799,744 PEPPER_ic001prd_20060316_110200.sqb
    03/16/2006 11:17 AM 939,520 PEPPER_ic001prd_20060316_111700.sqb
    03/16/2006 11:32 AM 790,016 PEPPER_ic001prd_20060316_113200.sqb
    03/16/2006 11:47 AM 738,816 PEPPER_ic001prd_20060316_114700.sqb
    03/16/2006 12:02 PM 849,408 PEPPER_ic001prd_20060316_120200.sqb
    03/16/2006 12:17 PM 879,104 PEPPER_ic001prd_20060316_121700.sqb
    03/16/2006 12:32 PM 993,792 PEPPER_ic001prd_20060316_123200.sqb
    03/16/2006 12:47 PM 979,968 PEPPER_ic001prd_20060316_124700.sqb
    03/16/2006 01:02 PM 1,009,152 PEPPER_ic001prd_20060316_130200.sqb
    03/16/2006 01:17 PM 650,752 PEPPER_ic001prd_20060316_131700.sqb
    03/16/2006 01:32 PM 698,368 PEPPER_ic001prd_20060316_133200.sqb
    03/16/2006 01:47 PM 823,296 PEPPER_ic001prd_20060316_134700.sqb
    03/16/2006 02:02 PM 912,384 PEPPER_ic001prd_20060316_140200.sqb
    03/16/2006 02:17 PM 768,000 PEPPER_ic001prd_20060316_141700.sqb
    03/16/2006 02:32 PM 1,584,640 PEPPER_ic001prd_20060316_143200.sqb
    03/16/2006 02:47 PM 19,858,944 PEPPER_ic001prd_20060316_144706.sqb
    03/16/2006 03:02 PM 66,036,736 PEPPER_ic001prd_20060316_150201.sqb
    03/16/2006 03:17 PM 45,616,128 PEPPER_ic001prd_20060316_151701.sqb
    03/16/2006 03:32 PM 11,679,744 PEPPER_ic001prd_20060316_153201.sqb
    03/16/2006 03:47 PM 745,984 PEPPER_ic001prd_20060316_154700.sqb
    03/16/2006 04:02 PM 1,112,576 PEPPER_ic001prd_20060316_160200.sqb
    03/16/2006 04:17 PM 822,784 PEPPER_ic001prd_20060316_161700.sqb
    03/16/2006 04:32 PM 818,176 PEPPER_ic001prd_20060316_163200.sqb
    03/16/2006 04:47 PM 754,176 PEPPER_ic001prd_20060316_164700.sqb
    03/16/2006 05:02 PM 873,984 PEPPER_ic001prd_20060316_170200.sqb
    03/16/2006 05:17 PM 1,554,432 PEPPER_ic001prd_20060316_171700.sqb
    03/16/2006 05:32 PM 797,184 PEPPER_ic001prd_20060316_173200.sqb
    03/16/2006 05:47 PM 791,552 PEPPER_ic001prd_20060316_174700.sqb
    03/16/2006 06:02 PM 694,784 PEPPER_ic001prd_20060316_180200.sqb
    03/16/2006 06:17 PM 483,328 PEPPER_ic001prd_20060316_181700.sqb
    03/16/2006 06:32 PM 552,448 PEPPER_ic001prd_20060316_183200.sqb
    03/16/2006 06:47 PM 497,664 PEPPER_ic001prd_20060316_184700.sqb
    03/16/2006 07:02 PM 695,296 PEPPER_ic001prd_20060316_190200.sqb
    03/16/2006 07:17 PM 594,944 PEPPER_ic001prd_20060316_191700.sqb
    03/16/2006 07:32 PM 601,088 PEPPER_ic001prd_20060316_193200.sqb
    03/16/2006 07:47 PM 522,752 PEPPER_ic001prd_20060316_194700.sqb
    03/16/2006 08:02 PM 597,504 PEPPER_ic001prd_20060316_200200.sqb
    03/16/2006 08:17 PM 595,456 PEPPER_ic001prd_20060316_201700.sqb
    03/16/2006 08:32 PM 642,560 PEPPER_ic001prd_20060316_203200.sqb
    03/16/2006 08:47 PM 678,912 PEPPER_ic001prd_20060316_204700.sqb
    03/16/2006 09:02 PM 559,616 PEPPER_ic001prd_20060316_210200.sqb
    03/16/2006 09:17 PM 436,736 PEPPER_ic001prd_20060316_211700.sqb
    03/16/2006 09:32 PM 467,968 PEPPER_ic001prd_20060316_213200.sqb
    03/16/2006 09:47 PM 409,088 PEPPER_ic001prd_20060316_214700.sqb
    03/17/2006 12:02 AM 4,921,856 PEPPER_ic001prd_20060317_000200.sqb
    03/17/2006 12:17 AM 5,160,448 PEPPER_ic001prd_20060317_001700.sqb
    03/17/2006 12:32 AM 370,176 PEPPER_ic001prd_20060317_003200.sqb
    03/17/2006 12:47 AM 370,688 PEPPER_ic001prd_20060317_004700.sqb
    03/17/2006 01:02 AM 479,744 PEPPER_ic001prd_20060317_010200.sqb
    03/17/2006 01:17 AM 387,584 PEPPER_ic001prd_20060317_011700.sqb
    03/17/2006 01:32 AM 248,320 PEPPER_ic001prd_20060317_013200.sqb
    03/17/2006 01:47 AM 322,048 PEPPER_ic001prd_20060317_014700.sqb
    03/17/2006 02:02 AM 675,328 PEPPER_ic001prd_20060317_020200.sqb
    03/17/2006 02:17 AM 259,584 PEPPER_ic001prd_20060317_021701.sqb
    03/17/2006 02:32 AM 234,496 PEPPER_ic001prd_20060317_023201.sqb
    03/17/2006 02:47 AM 139,776 PEPPER_ic001prd_20060317_024700.sqb
    03/17/2006 03:02 AM 239,616 PEPPER_ic001prd_20060317_030203.sqb
    03/17/2006 03:17 AM 197,632 PEPPER_ic001prd_20060317_031702.sqb
    03/17/2006 03:32 AM 386,560 PEPPER_ic001prd_20060317_033200.sqb
    03/17/2006 03:47 AM 197,120 PEPPER_ic001prd_20060317_034700.sqb
    03/17/2006 04:02 AM 379,904 PEPPER_ic001prd_20060317_040200.sqb
    03/17/2006 04:17 AM 158,720 PEPPER_ic001prd_20060317_041700.sqb
    03/17/2006 04:32 AM 205,312 PEPPER_ic001prd_20060317_043200.sqb
    03/17/2006 04:47 AM 98,816 PEPPER_ic001prd_20060317_044700.sqb
    03/17/2006 05:02 AM 154,112 PEPPER_ic001prd_20060317_050200.sqb
    03/17/2006 05:17 AM 131,584 PEPPER_ic001prd_20060317_051700.sqb
    03/17/2006 05:32 AM 203,264 PEPPER_ic001prd_20060317_053200.sqb
    03/17/2006 05:47 AM 165,376 PEPPER_ic001prd_20060317_054701.sqb
    03/17/2006 06:02 AM 8,946,688 PEPPER_ic001prd_20060317_060200.sqb
    03/17/2006 06:17 AM 87,826,944 PEPPER_ic001prd_20060317_061700.sqb
    03/17/2006 06:32 AM 42,655,744 PEPPER_ic001prd_20060317_063201.sqb
    03/17/2006 06:47 AM 142,336 PEPPER_ic001prd_20060317_064700.sqb
    03/17/2006 07:02 AM 185,344 PEPPER_ic001prd_20060317_070200.sqb
    03/17/2006 07:17 AM 133,632 PEPPER_ic001prd_20060317_071700.sqb
    03/17/2006 07:32 AM 170,496 PEPPER_ic001prd_20060317_073200.sqb
    03/17/2006 07:47 AM 197,632 PEPPER_ic001prd_20060317_074700.sqb
    03/17/2006 08:02 AM 189,440 PEPPER_ic001prd_20060317_080200.sqb
    03/17/2006 08:17 AM 359,936 PEPPER_ic001prd_20060317_081700.sqb
    03/17/2006 08:32 AM 307,712 PEPPER_ic001prd_20060317_083200.sqb
    03/17/2006 08:47 AM 292,352 PEPPER_ic001prd_20060317_084700.sqb
    03/17/2006 09:02 AM 467,968 PEPPER_ic001prd_20060317_090200.sqb
    03/17/2006 09:17 AM 532,992 PEPPER_ic001prd_20060317_091700.sqb
    354 File(s) 1,176,815,616 bytes
    2 Dir(s) 124,063,428,608 bytes free
    NULL
    petey wrote:
    xp_cmdshell 'erase \\beet\d$\sqlbackups\Complete\<filename>'
    Result in Query Analyzer was: NULL
    and file was deleted
  • Options
    peteypetey Posts: 2,358 New member
    There is a bug that prevents a deletion if the backup server name and database name does not match the restore server name and database name.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    petey wrote:
    There is a bug that prevents a deletion if the backup server name and database name does not match the restore server name and database name.

    So, if I have a DB named "ProdDB" and it's being restored to another server as "ProdBackUp" it won't allow deleting the log files after processing them?
  • Options
    peteypetey Posts: 2,358 New member
    Exactly. Or if ProdDB was backed up on ServerA, but is now restored on ServerB (as ProdDB).
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    petey wrote:
    Exactly. Or if ProdDB was backed up on ServerA, but is now restored on ServerB (as ProdDB).

    So this means LogShipping could never delete the files by definition?
  • Options
    peteypetey Posts: 2,358 New member
    No.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    I'm sure you rarely get messages that are not complaints/questions, but I would liek to thank you for the quick help via PM... The new version you had me download does seem to be working well.
Sign In or Register to comment.