September 11, 2013 at 4:36 am
Hi Guys
We have a VB application which includes SQL Express 2008R2. As part of that, we include an application which runs on the server and allows non-technical users to perform various admin tasks including backup.
The problem is that occasionally the backup appears to be created but is in fact marked *** INCOMPLETE ***
The sql that performs the backup is created like this:
sql = "BACKUP DATABASE " & dbname & " TO DISK = '" & buPath & "' WITH COPY_ONLY"
The strings are held in the application and not just typed in by the user.
I have searched on here and via Google for clues as to why this happens but I can only find suggestions about what to do with an incomplete backup when you've got one, but nothing on what might cause it. Any suggestions much appreciated.
Thanks
September 11, 2013 at 4:53 am
did you check the sqlserver errorlog file if it holds error messages from the failed backup requests ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 11, 2013 at 8:14 am
I have managed to contact the client and get them to look at the log. No, there's nothing untoward there at all.
Our program starts the backup and then ftp's the .BAK file to our server, so it relies on the fact that the backup is complete before that line of code returns.
Most of the time it works perfectly but occasionally we get incomplete backups, but of course it never happens when we try to repro it .
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply