Comments
Sort by recent activity
Peter- yes the LSN details are missing. That was informative. My only question - how do i find what might be holding that file and causing this to error? I have moved this backup out of the drive tape backup so that is not an issue. I do not have my logs going to this drive location - the only thing would be this backup. It was working fine until about 2 weeks ago. Nothing has changed on this clustered server that i know of. We backup to a file sharepoint drive. I am not having this issue with any other backup.
Any help is great.
g / comments
Peter- yes the LSN details are missing. That was informative. My only question - how do i find what might be holding that file and causing this to error? I have moved this backup out of the driv...
I will check with my Unix admins today. My history shows i have not had a successful backup prior to 4/24/08. If I manually run the procedure to backup - database by database - it will run. I have 36 client databases that are being affected.
Thank you...
Geri / comments
I will check with my Unix admins today. My history shows i have not had a successful backup prior to 4/24/08. If I manually run the procedure to backup - database by database - it will run. I hav...
Peter - this is the entire log file for this process. We are using Redgate Sql Backup 4.2.0.511.
geri / comments
Peter - this is the entire log file for this process. We are using Redgate Sql Backup 4.2.0.511.
geri
Thanks / comments
Thanks
I would like a chance to pull backup file size also.... / comments
I would like a chance to pull backup file size also....
Thank you again Petey. this is very helpful. I do appreciate it.
:P / comments
Thank you again Petey. this is very helpful. I do appreciate it.
:P
so because it has passed all the info to sql server before it really knows it can't access the backup location - sql server thinks it is successful. But my SQL server is alerting me to a failed backup and the SQL Backup log is showing the success.
Does SQL Backup have a retry and it fails first then is successful but by this time it has informed SQL SErver that it has failed?
Thanks / comments
so because it has passed all the info to sql server before it really knows it can't access the backup location - sql server thinks it is successful. But my SQL server is alerting me to a failed ba...
Thank you.... again... / comments
Thank you.... again...
It was due to the license expiring.
g / comments
It was due to the license expiring.
g
Peter - Thank you. I tried to create that folder - and discovered that we did have that folder. It was hidden and all the files in it were hidden. I have since found the log and discovered the reason that the backup failed. The file was in use - I believe there was a tape backup at that time and the backup process could not access the file.
I do very much appreciate your help and responsiveness to my issue. Thanks
Geri [image] / comments
Peter - Thank you. I tried to create that folder - and discovered that we did have that folder. It was hidden and all the files in it were hidden. I have since found the log and discovered the r...