Problems in Backing up SQL Server using Stored Procedure through Silk
We are using a custom Stored Procedure through Silk script to back up a SQL Server database as a part of our test plan. However, after we are done with running the script, there is no Backup file. [img]images/icons/blush.gif[/img] Nothing is being generated and when we tried to track it by refreshing the folder (F5 hits) while the script was running, we saw it start to be created (with 0 KB) and then suddenly that vanishes! [img]images/icons/rolleyes.gif[/img]
Of course, we have a 'restore' SP to follow.
However, these same SP when run from SQL Query Manager, runs fine. [img]graemlins/blankface.gif[/img]
What the [img]images/icons/shocked.gif[/img] ?
Can anyone please help?? I have a client deadline for tomorrow..!!! [img]images/icons/confused.gif[/img]