AnsweredAssumed Answered

Backup Error. Why?

Question asked by fchanampa on Mar 12, 2020
Latest reply on Mar 20, 2020 by fchanampa

In the backup file .txt that creates automatically with the backup, i searched for the word "Error" and i found this:

 

Creating directory "C:\Backup\Automated\AF"
Thu 03/12/2020 12:31:59.88
Backup AF data...

 

C:\Windows\system32>SET SQLINSTANCE=.\sqlexpress

 

C:\Windows\system32>sqlcmd -S .\sqlexpress -d PIFD -Q "EXEC dbo.usp_backup @outpath = N'C:\Backup\Automated\AF\';" -E
Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. .
Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Login timeout expired.
Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
Backup AF data...done.
Thu 03/12/2020 12:32:09.16

Outcomes