Error 2809 on SQL Restore
Hi,
i've this problem when i try to restore SQL DB on same client from Backup Archive and Restore application.
This is log:
12:16:00 30/09/2015: Restore Started
12:16:03 (1303.xxx) Found (35) files in (10) images for Restore Job ID 1303.xxx
12:16:04 (1303.xxx) Searched (35) files of (35) files for Restore Job ID 1303.xxx
12:16:04 (1303.001) Restoring from copy 1 of image created 29/09/2015 20:00:23 from policy GE_SQL_TIAP
12:16:15 (1303.001) Status of restore from copy 1 of image created 29/09/2015 20:00:23 = cannot connect on socket
12:16:15 (1303.001) The following files/folders were not restored:
12:16:15 (1303.001) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.master.~.7.002of002.20150929200111..C
12:16:15 (1303.001) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.master.~.7.002of002.20150929200111..C
12:16:16 (1303.xxx) Found (35) files in (10) images for Restore Job ID 1303.xxx
12:16:16 (1303.002) Restoring from copy 1 of image created 29/09/2015 20:00:27 from policy GE_SQL_TIAP
12:16:25 (1303.002) Status of restore from copy 1 of image created 29/09/2015 20:00:27 = cannot connect on socket
12:16:25 (1303.002) The following files/folders were not restored:
12:16:25 (1303.002) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.master.~.7.001of002.20150929200111..C
12:16:25 (1303.002) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.master.~.7.001of002.20150929200111..C
12:16:25 (1303.002) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.master.~.7.001of002.20150929200111..C
12:16:25 (1303.002) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.master.~.7.001of002.20150929200111..C
12:16:25 (1303.002) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.master.~.7.001of002.20150929200111..C
12:16:26 (1303.xxx) Found (35) files in (10) images for Restore Job ID 1303.xxx
12:16:26 (1303.003) Restoring from copy 1 of image created 29/09/2015 20:01:15 from policy GE_SQL_TIAP
12:16:36 (1303.003) Status of restore from copy 1 of image created 29/09/2015 20:01:15 = cannot connect on socket
12:16:36 (1303.003) The following files/folders were not restored:
12:16:36 (1303.003) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.model.~.7.001of002.20150929200203..C
12:16:36 (1303.003) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.model.~.7.001of002.20150929200203..C
12:16:36 (1303.003) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.model.~.7.001of002.20150929200203..C
12:16:36 (1303.003) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.model.~.7.001of002.20150929200203..C
12:16:36 (1303.003) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.model.~.7.001of002.20150929200203..C
12:16:37 (1303.xxx) Found (35) files in (10) images for Restore Job ID 1303.xxx
12:16:37 (1303.004) Restoring from copy 1 of image created 29/09/2015 20:01:16 from policy GE_SQL_TIAP
12:16:46 (1303.004) Status of restore from copy 1 of image created 29/09/2015 20:01:16 = cannot connect on socket
12:16:46 (1303.004) The following files/folders were not restored:
12:16:46 (1303.004) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.model.~.7.002of002.20150929200203..C
12:16:46 (1303.004) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.model.~.7.002of002.20150929200203..C
12:16:47 (1303.xxx) Found (35) files in (10) images for Restore Job ID 1303.xxx
12:16:47 (1303.005) Restoring from copy 1 of image created 29/09/2015 20:02:04 from policy GE_SQL_TIAP
12:16:56 (1303.005) Status of restore from copy 1 of image created 29/09/2015 20:02:04 = cannot connect on socket
12:16:56 (1303.005) The following files/folders were not restored:
12:16:56 (1303.005) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.msdb.~.7.001of002.20150929200250..C
12:16:56 (1303.005) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.msdb.~.7.001of002.20150929200250..C
12:16:56 (1303.005) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.msdb.~.7.001of002.20150929200250..C
12:16:56 (1303.005) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.msdb.~.7.001of002.20150929200250..C
12:16:56 (1303.005) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.msdb.~.7.001of002.20150929200250..C
12:16:57 (1303.xxx) Found (35) files in (10) images for Restore Job ID 1303.xxx
12:16:57 (1303.006) Restoring from copy 1 of image created 29/09/2015 20:02:05 from policy GE_SQL_TIAP
12:17:06 (1303.006) Status of restore from copy 1 of image created 29/09/2015 20:02:05 = cannot connect on socket
12:17:06 (1303.006) The following files/folders were not restored:
12:17:06 (1303.006) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.msdb.~.7.002of002.20150929200250..C
12:17:06 (1303.006) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.msdb.~.7.002of002.20150929200250..C
12:17:07 (1303.xxx) Found (35) files in (10) images for Restore Job ID 1303.xxx
12:17:07 (1303.007) Restoring from copy 1 of image created 29/09/2015 20:02:51 from policy GE_SQL_TIAP
12:17:16 (1303.007) Status of restore from copy 1 of image created 29/09/2015 20:02:51 = cannot connect on socket
12:17:16 (1303.007) The following files/folders were not restored:
12:17:16 (1303.007) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.ReGe.~.7.001of002.20150929200340..C
12:17:16 (1303.007) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.ReGe.~.7.001of002.20150929200340..C
12:17:16 (1303.007) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.ReGe.~.7.001of002.20150929200340..C
12:17:16 (1303.007) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.ReGe.~.7.001of002.20150929200340..C
12:17:16 (1303.007) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.ReGe.~.7.001of002.20150929200340..C
12:17:17 (1303.xxx) Found (35) files in (10) images for Restore Job ID 1303.xxx
12:17:17 (1303.008) Restoring from copy 1 of image created 29/09/2015 20:02:52 from policy GE_SQL_TIAP
12:17:27 (1303.008) Status of restore from copy 1 of image created 29/09/2015 20:02:52 = cannot connect on socket
12:17:27 (1303.008) The following files/folders were not restored:
12:17:27 (1303.008) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.ReGe.~.7.002of002.20150929200340..C
12:17:27 (1303.008) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.ReGe.~.7.002of002.20150929200340..C
12:17:28 (1303.xxx) Found (35) files in (10) images for Restore Job ID 1303.xxx
12:17:28 (1303.009) Restoring from copy 1 of image created 29/09/2015 20:03:37 from policy GE_SQL_TIAP
12:17:37 (1303.009) Status of restore from copy 1 of image created 29/09/2015 20:03:37 = cannot connect on socket
12:17:37 (1303.009) The following files/folders were not restored:
12:17:37 (1303.009) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.Tiap.~.7.002of002.20150929200426..C
12:17:37 (1303.009) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.Tiap.~.7.002of002.20150929200426..C
12:17:38 (1303.xxx) Found (35) files in (10) images for Restore Job ID 1303.xxx
12:17:38 (1303.010) Restoring from copy 1 of image created 29/09/2015 20:03:38 from policy GE_SQL_TIAP
12:17:48 (1303.010) Status of restore from copy 1 of image created 29/09/2015 20:03:38 = cannot connect on socket
12:17:48 (1303.010) The following files/folders were not restored:
12:17:48 (1303.010) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.Tiap.~.7.001of002.20150929200426..C
12:17:48 (1303.010) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.Tiap.~.7.001of002.20150929200426..C
12:17:48 (1303.010) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.Tiap.~.7.001of002.20150929200426..C
12:17:48 (1303.010) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.Tiap.~.7.001of002.20150929200426..C
12:17:48 (1303.010) UTF - /APCEDGEAPP017.MSSQL7.APCEDGEAPP017.db.Tiap.~.7.001of002.20150929200426..C
12:17:48 INF - Server status = 2809
12:17:48 (1303.xxx) INF - Status = MS-SQL-Server policy restore error.
NBU enviroment is 7.6.1 version
Server is Windows 2008 R2 STD
Can help me?
You cannot use Backup Archive and Restore to restore SQL db's.
You need to restore from the client using 'Start' -> Symantec NetBackup -> NetBackup Agents -> NetBackup MS SQL Client
See NetBackup for Microsoft SQL Server Administrator's Guide for detailed restore instructions.