How can we help you today? How can we help you today?
appwright
Activity overview Badges (0) Posts (12) Comments (38)

Comments

Sort by recent activity
The new version 3.2 has solved the Warning problem. No more file delete warnings! / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Warning Deleting Old Files
The new version 3.2 has solved the Warning problem. No more file delete warnings!
0 votes
Can I get 3.2? I also noticed that even if I have the deletion set for 1, I will still end up with 2 files in holding instead of just the current backup. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Warning Deleting Old Files
Can I get 3.2? I also noticed that even if I have the deletion set for 1, I will still end up with 2 files in holding instead of just the current backup.
0 votes
Here is the output for that file: [image] \Backups>cscript fileattrib.js /file:TAHOE_DEV2_db_(full)_200505032206.sqb Microsoft (R) Windows Script Host Version 5.6 Copyright (C) Microsoft Corporation 1996-2001. All rights reserved. attributes of TAHOE_DEV2_db_(full)_200505032206.sqb Archive / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Warning Deleting Old Files
Here is the output for that file:\Backups>cscript fileattrib.js /file:TAHOE_DEV2_db_(full)_200505032206.sqb Microsoft (R) Windows Script Host Version 5.6 Copyright (C) Microsoft Corporation 1996-20...
0 votes
I have some new information: I noticed that it is actually deleting older files, however it is saying it is not. Any ideas? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Warning Deleting Old Files
I have some new information: I noticed that it is actually deleting older files, however it is saying it is not. Any ideas?
0 votes
BTW: I'm using the script that was posting in the forum to backup all databases. Is there anything wrong with that script? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Warning Deleting Old Files
BTW: I'm using the script that was posting in the forum to backup all databases. Is there anything wrong with that script?
0 votes
Attributes? I guess you mean ReadOnly and Hidden. Both are unchecked. File size is 7.02MB, the one that failed today we created on May 03 2005. File name is: TAHOE_DEV2_db_(full)_200505032206.sqb. Here is the warning on it: 5/5/2005 10:06:31 PM: SQL Backup 3.1.0, (c) Red Gate Software Ltd 2004 - 2005 5/5/2005 10:06:31 PM: 5/5/2005 10:06:31 PM: Backing up DEV2 (full database) on TAHOE instance to [image] \Backups\TAHOE_DEV2_db_(full)_200505052206.sqb ... 5/5/2005 10:06:31 PM: 5/5/2005 10:06:31 PM: BACKUP DATABASE [DEV2] TO DISK = 'D:\Backups\TAHOE_DEV2_db_(full)_200505052206.sqb' WITH NAME = 'Database (DEV2) Full 200505052206', DESCRIPTION = '', INIT, PASSWORD = 'XXXXXXXXXX', ERASEFILES_ATSTART = 2, MAILTO = 'porter@2morrow.com', COMPRESSION = 3 5/5/2005 10:06:31 PM: 5/5/2005 10:06:31 PM: Deleting old backup file: [image] \Backups\TAHOE_DEV2_db_(full)_200505022206.sqb 5/5/2005 10:06:31 PM: Warning 161: ERASEFILES error: Failed to delete file: [image] \Backups\TAHOE_DEV2_db_(full)_200505022206.sqb. Error code: 158 (The segment is already unlocked). 5/5/2005 10:06:32 PM: osql -S TAHOE\TAHOE -Q "BACKUP DATABASE [DEV2] TO VIRTUAL_DEVICE = 'SQLBACKUP_207628493' WITH BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = 'Database (DEV2) Full 200505052206', DESCRIPTION = '', FORMAT" -b -w 120 -U sa -P XXXXXXXXXX 5/5/2005 10:06:35 PM: Backup data size : 25.500 MB 5/5/2005 10:06:35 PM: Compressed data size: 7.024 MB 5/5/2005 10:06:35 PM: Compression rate : 72.45% 5/5/2005 10:06:38 PM: Process completed successfully. 5/5/2005 10:06:38 PM: / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Warning Deleting Old Files
Attributes? I guess you mean ReadOnly and Hidden. Both are unchecked. File size is 7.02MB, the one that failed today we created on May 03 2005. File name is: TAHOE_DEV2_db_(full)_200505032206.s...
0 votes
petey wrote: The file names need not be the same for the ERASEFILES or ERASEFILES_ATSTART options to work. Is it possible that the old file is in use by another application at the time that SQL Backup tries to delete it e.g. virus scanners, batch copy jobs etc? Nope - nothing would be touching those files. It happens when I run it from the command line also. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Warning Deleting Old Files
petey wrote: The file names need not be the same for the ERASEFILES or ERASEFILES_ATSTART options to work. Is it possible that the old file is in use by another application at the time that SQL ...
0 votes
I was looking this over. If the filename is not the same will it not delete the old files. I am using the script posted in this forum to delete all backups. This gives each file a unique name. Could that be the problem? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Warning Deleting Old Files
I was looking this over. If the filename is not the same will it not delete the old files. I am using the script posted in this forum to delete all backups. This gives each file a unique name. ...
0 votes
No the file was not deleted. And the file does exist. It's just not getting deleted. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Warning Deleting Old Files
No the file was not deleted. And the file does exist. It's just not getting deleted.
0 votes
Brian Donahue wrote: Hi, That's something that we can think about. We certainly want to prevent someone from 'trialling' the software indefinitely! I'm sure of that [image] Maybe something like limiting the databases to just MODEL, PUBS, NORTHWIND or something along those lines. That should pretty much make it useless outside of testing ?? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. License for Test Server
Brian Donahue wrote: Hi, That's something that we can think about. We certainly want to prevent someone from 'trialling' the software indefinitely! I'm sure of that Maybe something like limi...
0 votes
Total activity
63
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
13