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
Moderator
Moderator
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
Moderator
Moderator
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