How can we help you today? How can we help you today?
Jeff Randall
Activity overview Badges (0) Posts (8) Comments (25)

Comments

Sort by recent activity
It's not ideal, but you could always import the DB (structures only, not data) into a local copy of SQL and do the compare locally... / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Permissions error when trying to sync with db at web hosts
It's not ideal, but you could always import the DB (structures only, not data) into a local copy of SQL and do the compare locally...
0 votes
Update: Yesterday around noon, it failed for about 1 hour then fixed itself. Then began failing again around 3:00 PM for about 9 hours and fixed itself again around 1:00 AM this morning. petey wrote: Could you pls post the results of running the following: exec master..sqbmemory The server it has been failing on (although currently it is working): Type Minimum Maximum Average Blk count Total Commit 4096 1073479680 0 1419 -1398685696 Reserve 4096 67063808 747046 294 219631616 Free 4096 3801088 305949 344 105246720 Private 4096 1073479680 0 1043 -1229021184 Mapped 4096 1536000 165290 48 7933952 Image 4096 5836800 67577 622 42033152 One of the servers it works correctly on: Type Minimum Maximum Average Blk count Total Commit 4096 1073479680 0 1261 -1406857216 Reserve 4096 8384512 492136 239 117620736 Free 4096 15007744 797885 270 215429120 Private 4096 1073479680 0 900 -1335246848 Mapped 4096 1536000 184320 44 8110080 Image 4096 5836800 68165 556 37900288 I will post it again later when it begins to fail again. petey wrote: An upgrade does not require you to reboot the server if you can release xp_sqlbackup.dll cleanly. It also does not require you to restart the SQL Server service, only the SQL Backup Agent service. In the past it has caused problems on one of the servers during install, forcing a reboot, and my boss has made it clear that it's not worth the risk. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Log Shipping failing "randomly"
Update: Yesterday around noon, it failed for about 1 hour then fixed itself. Then began failing again around 3:00 PM for about 9 hours and fixed itself again around 1:00 AM this morning. petey wro...
0 votes
I am currently using: SQL Backup 4.1.0.207 - Professional edition And I can not upgrade to 4.2 (or reboot the server, or restart the SQL Server Service) until at least Sunday during the next scheduled Maintenance Window... / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Log Shipping failing "randomly"
I am currently using: SQL Backup 4.1.0.207 - Professional edition And I can not upgrade to 4.2 (or reboot the server, or restart the SQL Server Service) until at least Sunday during the next schedu...
0 votes
I had this same problem. petey sent me version 4.2.0.318 which solved the problem. It seemed to be caused by the primary DB name differing from the restore DB name... / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Transaction Log not deleted after Logshipping
I had this same problem. petey sent me version 4.2.0.318 which solved the problem. It seemed to be caused by the primary DB name differing from the restore DB name...
0 votes
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? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Deleting files after restoring logs
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?
0 votes
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. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Deleting files after restoring logs
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.
0 votes
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? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Deleting files after restoring logs
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...
0 votes
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 / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Deleting files after restoring logs
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$ i...
0 votes
memstat - Yohz Software (c) 2005 - 2006 NULL Type Minimum Maximum Average Blk count Total Commit 4096 1073479680 0 3468 -1268203520 Reserve 4096 4128768 390352 196 76509184 Free 4096 3735552 143414 822 117886976 Private 4096 1073479680 0 3162 -1226461184 Mapped 4096 1536000 166461 50 8323072 Image 4096 5836800 58503 452 26443776 NULL NULL / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Error: Msg 3013, Level 16, State 1, Server BEET, Line 1
memstat - Yohz Software (c) 2005 - 2006 NULL Type Minimum Maximum Average Blk count Total Commit 4096 1073479680 0 3468 -1268203520 Res...
0 votes
This houses a production DB which handles all login requests to our system As well the other production servers are using native SQL Log Shipping (yes I know, I'm planning to move it to SQL Backup Log Shipping soon) and this server is the one which they are being shipped to So there are constantly alot of processes on this machine at any moment in time, however it generally has fewers concurrent processes at any given moment than the other productions servers Once I switch to SQL Backup Log Shipping I will be doing a round robin type of setup for the Log Shipping (server 1 sends to 2, 2 sends to 3, 3 sends to 4, 4 sends to 5, 5 sends to 1) which may reduce the traffic to any one server. I do plan to upgrade to v4, but as this is a production environment, I'll have to wait for a scheduled maintenance window, and it would be nice to have this working a bit more regularly in the meantime. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Error: Msg 3013, Level 16, State 1, Server BEET, Line 1
This houses a production DB which handles all login requests to our system As well the other production servers are using native SQL Log Shipping (yes I know, I'm planning to move it to SQL Backup ...
0 votes
Total activity
43
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
10