Comments
Sort by recent activity
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
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...
I have some new information:
I noticed that it is actually deleting older files, however it is saying it is not. Any ideas? / comments
I have some new information:
I noticed that it is actually deleting older files, however it is saying it is not. Any ideas?
BTW: I'm using the script that was posting in the forum to backup all databases. Is there anything wrong with that script? / comments
BTW: I'm using the script that was posting in the forum to backup all databases. Is there anything wrong with that script?
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
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...
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
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 ...
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
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. ...
No the file was not deleted. And the file does exist. It's just not getting deleted. / comments
No the file was not deleted. And the file does exist. It's just not getting deleted.
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
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...
Brian Donahue wrote:
Hi Todd,
If SQL Backup had been previously installed and the trial period expired, then you can request a trial licence key from sales@red-gate.com. Again, this will give you a 14-day trial.
Please let us know if you need anything further.
Well there-in lies the problem. It's a pain to have to keep asking for a trial license [image]
Would be nice to have some kind of license that would basically cripple the software for production use, but allow it to be used on a development server. Maybe limit the backed up DB's to only 2 or something like that. Don't allow it to restore a DB older than 4 hours even. Something like that should make it useless for production but perfect for testing ?? / comments
Brian Donahue wrote:
Hi Todd,
If SQL Backup had been previously installed and the trial period expired, then you can request a trial licence key from sales@red-gate.com. Again, this will give yo...
Yes - I think I might be able to come up with a solution like that. I can code VB6 so I could write a program that would build the list I could check-off and the run the same script over and and over against each DB.
After looking over the Toolkit more it looks like this other solution would work better for me given the .NET requirement. / comments
Yes - I think I might be able to come up with a solution like that. I can code VB6 so I could write a program that would build the list I could check-off and the run the same script over and and o...