|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
I've just installed SqlBackupAndFTP, and am trying to back up a remote database. The database connection tests out just fine. However, when I hit the Run Now button I get the following error:
SqlBackupAndFtp 3.2.2.39290 (Free)
SUMMARY:
Database XXX: Backup - Failure
DETAILED LOG:
8/17/2009 12:40:20 AM Creating backup of XXX
8/17/2009 12:40:20 AM ERROR: Backup of XXX failed: Cannot open backup device 'D:\Temp\speg20sr.e2e\CYT20090817.bak'. Operating system error 3(The system cannot find the path specified.).
BACKUP DATABASE is terminating abnormally.
8/17/2009 12:40:20 AM Removing temporary folder D:\Temp\speg20sr.e2e
Is the software trying to create a temporary file on the remote server, or my local machine? Any ideas as to why this doesn't work?
Dave
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
This seem to be not remote, but local database.
SQL Server does not have sufficient permissions to your "D:\Temp\" folder. Give it's process sufficient permissions to this folder or change your temp folder location in environment variables.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
ruslan wrote:This seem to be not remote, but local database.
SQL Server does not have sufficient permissions to your "D:\Temp\" folder. Give it's process sufficient permissions to this folder or change your temp folder location in environment variables. Yes, it is a remote database that I am trying to back up. Again, is the software trying to create the temporary file(s) on the remote machine, or on my local machine? If it's on my local (Windows XP) machine, then I don't think it's a permission issue. If it's trying to create the temporary files on the remote machine, then it's likely a permission issue, yes .. and I'll never get permission to create temporary files on the remote server, so that means SqlBackupAndFTP won't work for me. Hopefully that's not the case!
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
You do not need permission for temp folders to do script backup. But your log is from local DB backup - trust me on this. Here's the example of log for script backup - compare with yours:
>>> run 8/18/2009 6:20:29 PM by Ruslan
SqlBackupAndFtp 3.2.0.15637 (Free)
SUMMARY:
Database HouseRallyModel: Backup - Success
DETAILED LOG:
8/18/2009 6:18:41 PM Creating backup of HouseRallyModel (using scripting)
8/18/2009 6:18:41 PM Scripting to HouseRallyModel001.sql
8/18/2009 6:18:41 PM Scripting database creation
8/18/2009 6:18:45 PM Scripting users
8/18/2009 6:18:46 PM Scripting roles
8/18/2009 6:18:47 PM Scripting users in roles
8/18/2009 6:18:47 PM Scripting schemas
8/18/2009 6:18:49 PM Scripting user defiend types
8/18/2009 6:18:51 PM Scripting table structures
8/18/2009 6:19:34 PM Scripting contents of Person table
and so on
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
ruslan wrote:You do not need permission for temp folders to do script backup. But your log is from local DB backup - trust me on this. It appears, then, that I have set up the backup for a local machine, even though a) the local machine does not have SQL Server installed and b) I put in the connection parameters for the remote machine and tested the connection successfully. How do I set up a remote / scripted backup? Are there any different or extra steps I need to take? Thanks!
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Dave, I share you skepticism - the situation seems impossible. But what can I say - the log you've posted is from local backup! Let's assume SqlBackupAndFTP mistakenly thinks your remote server is a local server and tries to do standard instead of script backup. Easy to test - in advanced settings set "Use Scripting" to Always.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
I figured that out, and set "Use Scripting" to Always, and it worked!! I got a very nice backup of my remote database.
HOWEVER ...
When I save the job and exit the program, and then run it again and load my job file, the Scripting is set back to Automatic. It appears that that setting is not getting stored :(
Because of this error, my timed backups are failing. Can someone please look into this?
Thanks!
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
We are looking into the issue of not saving scripting setting - the fix will be ready in a day or two.
Another original issue was with SqlBackupAndFTP incorrectly identifying remote server as local. Could you send me (privately if necessary) the connection string you were using?
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
Check out the new thread I started called "Error saving configuration" in this same forum. It has my complete .job file, with the naughty bits covered up ;)
Thanks for digging into this! SqlBackupAndFTP looks like it'll work great for me, once these issues are resolved.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Thank you. Will do our best.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
I had the same problem with two remote databases on two different Windows installations. I could use the same workaround, so my problem is solved but I thought I should mention that this seems to happen for multiple users.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
you mean a problem when sqlbackupandftp considers your remote database as a local one?
|
|
|
|
|
