MySql Backup

Welcome Guest Search | Active Topics | Log In | Register
Error while getting stored procedures, triggers,functions or views information Options · View
dynafish
#1 Posted : Wednesday, March 22, 2017 12:29:54 PM
Rank: Newbie

Groups: Registered

Joined: 3/22/2017
Posts: 2
Location: Algarve, Portugal
I've run the program a few times on a remote database, and it goes ok - saving tables etc, amd creating 10 .sql files - until right at the end of the run it terminates with the following error. Any idea what might be causing this?

It's working fine on another database (although that is on a different server).

Quote:
03/22/2017 17:10:32 Scripting contents of DYN_TableDefs.151127 table
03/22/2017 17:10:34 Scripting primary keys
03/22/2017 17:10:34 Scripting foreign keys
03/22/2017 17:10:35 Scripting executing entities
03/22/2017 17:10:58 ERROR: Database scripting failed > An error occured while getting stored procedures, triggers,functions or views information. > A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
SQL Server: "". > The network path was not found
03/22/2017 17:10:58 ERROR: Database scripting failed > An error occured while getting stored procedures, triggers,functions or views information. > A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
SQL Server: "". > The network path was not found
03/22/2017 17:10:58 Delete temporary folder: "C:\Users\David\AppData\Local\Temp\Pranas.NET\SQLBackupAndFTP\kunuvwlq"
03/22/2017 17:10:58 ERROR: Job finished (With Errors)


TIA :)
Alexander Omelchenko
#2 Posted : Thursday, March 23, 2017 4:41:14 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 457
Hello,

Remote backup is unsupported permanent beta, please find more information at http://sqlbackupandftp.com/remote/

We'd recommend you use SQLBackupAndFTP on the same computer where SQL Server is installed. If it's not possible for you, please try to make backups with or without "Use SMO for remote backup" option. To enable or disable this option open "Advanced backup settings" and press "More backup options".
Alexander Omelchenko attached the following image(s):
Backup Options SQLBackupAndFTP.png
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com