cancel
Showing results for 
Search instead for 
Did you mean: 

Error 2809 on SQL Restore

PorcoDio
Level 4

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Level 6
Partner    VIP    Accredited Certified

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.
 

View solution in original post

4 REPLIES 4

sdo
Moderator
Moderator
Partner    VIP    Certified

Have you worked through this tech note:

NetBackup status code 2809: SQL restore failure

https://support.symantec.com/en_US/article.TECH147036.html

Marianne
Level 6
Partner    VIP    Accredited Certified

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.
 

PorcoDio
Level 4

Well i'll read the tech note and then update the thread.

 

Thanks for support

PorcoDio
Level 4

Thanks all for support