Re: SQL 2005 Failing Backups Because it Exits The Query Prematurely

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

My apologies, I had zipped up an older version of my test app, but that still should have worked.

If it isn't too much trouble, could you please double check that:
- The "Change default database to:" in the Northwind ODBC datasource is checked and set to NorthWind.
- The dbo.usp_Backup.sql is pointing to the correct backup path for your local sql environment.
- That dbo.usp_Backup.sql was ran against Northwind.
- Check that when you execute usp_Backup in Northwind from query analyzer, it functions normally.

If the above is all correct, then the test app ought to work.

http://espnsti.in2hosting.org/BackupTest/BackupTest.zip
http://espnsti.in2hosting.org/BackupTest/BackupTestSource.zip
http://espnsti.in2hosting.org/BackupTest/dbo.usp_Backup.sql

I probably will end up contacting MS Support, but for now I'm mostly just interested in seeing if someone can reproduce it. :)

Thanks,
Erik

"Peter Yang [MSFT]" <petery@xxxxxxxxxxxxxxxxxxxx> wrote in message news:bJpN8ZcPGHA.6304@xxxxxxxxxxxxxxxxxxxxxxxx
Hello,

I tried to run the exe directly on my test machine, and it seems the odbc
query failed and it returned immediately with the time label. The same
thing happens to SQL 2000.

Since I don't have Delphi to test, I was not able to troubleshoot in the
source code level. Since you are not able to reproduce the issue
consistently, it might be a behavior change in SQL 2005. Please rest
assured I have reported this situation to the proper channel.

If you need further assistance on this issue, I recommend that you open a
Support incident with Microsoft Product Support Services so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.

For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.


.