|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/23/2010
Posts: 2
|
I got the following error message when running my first backup. I checked the temp folder and the file seems to actually be there, and this log file was also in the designated folder. It did not copy the backup file from the temp folder to the designated folder however...? running Vista 64 Bit OS
SqlBackupAndFtp 4.5.0.28757 (Free)
SUMMARY:
Database tjs3: Backup - Failure
DETAILED LOG:
4/23/2010 7:55:12 AM Creating backup of tjs3 to C:\Windows\TEMP
4/23/2010 7:55:53 AM ERROR: Backup of tjs3 failed: Backup of tjs3 failed: file C:\Windows\TEMP\tjs3201004230755.bak is not found
4/23/2010 7:55:54 AM ERROR: Writing to event log failed: The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security.
4/23/2010 7:55:54 AM ERROR: Job finished (With Errors)
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/23/2010
Posts: 2
|
Thanks, running as administrator worked. Great product, I'll be buying it.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
No, it doesn't work. I still got the same error. The .bak file is not created also in the temp directory. I've tried to run it "As Administrator", the same error. The scheduled job runs perfectly, but the "Run Now" button produces the same error.
Please help.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Did you managed to fix it?
Running as administrator or scheduling not working.
I'm using WinWebHosting, and have access to it through SQL Server Mangement Studio.
André
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Guest wrote:Did you managed to fix it?
Running as administrator or scheduling not working.
I'm using WinWebHosting, and have access to it through SQL Server Mangement Studio.
André
Edit: If I create the .bak file just before running backup manually from dos, then it says Backup completed and zipping it and removing the .bak file.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Ok, Io solved my problem.
Hopefully this helps someone else as well.
Network access: Set as Current User
Large Database backups - Temporary folder: "C:\Backup" instead of default c:\windows\temp
Log file - Log folder: c:\Backup
Database Scripting - Use Scripting: ALWAYS
And after that I could press "Run Now" and I got myself some 10MB .sql files.
/André
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Hello,
I have the same problem that initiated the thread. After trying the last solution (network access: current user;temporary folder, log folder, use scripting), when I hit the "Run now" button I get the following message:
Database scripting failed: An error occured while getting tables information. >> System.ApplicationException: An error occured while getting tables information. ---> System.Data.SqlClient.SqlException: Database 'thehoopsmarket' does not exist. Make sure that the name is entered correctly.
en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
en System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
en System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
en System.Data.SqlClient.SqlDataReader.get_MetaData()
en System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
en System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
en System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
en System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
en b.p.c(String A_0)
--- Fin del seguimiento de la pila de la excepción interna ---
en b.p.c(String A_0)
en b.x.a(Stream A_0, List`1& A_1)
Anyone knows how could I fix this? Thank you so much for helping.
|
|
|
|
|
