Ms sql ошибка 1073548784

  • Remove From My Forums

  • Question

  • Hello,

    I am running SQL Server 2008 R2 (Microsoft SQL Server Management Studio      10.50.2500.0
    Strumenti client di Microsoft Analysis Services      10.50.2500.0
    Microsoft Data Access Components (MDAC)      6.1.7601.17514
    Microsoft MSXML      3.0 6.0
    Microsoft Internet Explorer      9.0.8112.16421
    Microsoft .NET Framework      2.0.50727.5456
    Sistema operativo      6.1.7601)

    I have two backup plans, one Daily, with Differential backup, and one Weekly with FULL backup. I keep all files for 30 days.

    Since I want to be really really sure of backing up my precious data, I installed Cobian Backup, and created a task to daily zip and transfer the (incremental) files via FTP to some other place in the world.

    Since  running Cobian Backup, the Daily plan has broken. It complains that it cannot find the backup information any more, and returns a -1073548784 error.

    the log files are not very helpful:

    «Possible failure reasons: Problems with the query, «ResultSet» property not set correctly, parameters not set correctly, or connection not established correctly.»

    Why is the zip and ftp shorting the SQL?

    Any help is welcome!

    thanks

Answers

  • Hello,

    the error detail for -1073548784 suggests that SQL Server is unable to find the latest Full backup, on which to run the Differential.

    I tried disabling the Volume Shadow Copy option on Cobian Backup. Now the differential backup on SQL Server works.

    Something will not work if one of the two processes try to access the backup files in the same time frame. I will have to find some workaround for this.

    My conclusion is:

    SQL Server 2008 R2 differential backups are incompatible with Volume Shadow Copy service on Windows Server 2008 R2.

    Somehow, somewhere Volume Shadow Copy (or Cobian Backup’s use of it) breaks the ability of SQL Server to find the latest Full backup.

    • Marked as answer by

      Friday, September 28, 2012 1:20 PM

Источник

null

MS SQL error 1073548784 access to path … denied

Ошибка с кодом -1073548784 

ms sql error 1073548784 access to path ... denied

при выполнении планов обслуживания (maintenance plan) в ms sql server.

Несмотря на пользователей от которых работают сервисы, необходимо дать разрешения на уровне файловой системы для пользователя NT Service\MSSQLSERVER на уровне rw или full controll 

Источник

SQL Server 2014 Developer — duplicate (do not use) SQL Server 2014 Enterprise — duplicate (do not use) SQL Server 2014 Standard — duplicate (do not use) More…Less

Symptoms

Consider the following scenario:

  • You use the AlwaysOn Availability Groups feature in Microsoft SQL Server 2014.

  • You have an availability group whose backup-preference setting is set as «Prefer Secondary» or «Secondary only.»

  • You create a maintenance plan that uses a backup database task to back up a database, and the database belongs to the availability group.

  • You select the «Verify backup integrity» option, and click to clear the «For availability databases, ignore replica priority for backup and backup on primary settings» option for the backup database task.

  • You execute the maintenance plan.

In this scenario, you receive the following error message:

Error Number:
-1073548784
Error Message:
Executing the query «<Query statement>» failed with the following error: «Cannot open backup device ‘<File path of the backup file>’. Operating system error 2(The system cannot find the file specified.). VERIFY DATABASE is terminating abnormally.». Possible failure reasons: Problems with the query, «ResultSet» property not set correctly, parameters not set correctly, or connection not established correctly.

Resolution

The issue was first fixed in the following cumulative updates of SQL Server:

  • Cumulative Update 2 for SQL Server 2014 SP1

  • Cumulative Update 9 for SQL Server 2014

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the «Applies to» section.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Источник
  • Remove From My Forums

  • Question

  • Hello,

    I am running SQL Server 2008 R2 (Microsoft SQL Server Management Studio      10.50.2500.0
    Strumenti client di Microsoft Analysis Services      10.50.2500.0
    Microsoft Data Access Components (MDAC)      6.1.7601.17514
    Microsoft MSXML      3.0 6.0
    Microsoft Internet Explorer      9.0.8112.16421
    Microsoft .NET Framework      2.0.50727.5456
    Sistema operativo      6.1.7601)

    I have two backup plans, one Daily, with Differential backup, and one Weekly with FULL backup. I keep all files for 30 days.

    Since I want to be really really sure of backing up my precious data, I installed Cobian Backup, and created a task to daily zip and transfer the (incremental) files via FTP to some other place in the world.

    Since  running Cobian Backup, the Daily plan has broken. It complains that it cannot find the backup information any more, and returns a -1073548784 error.

    the log files are not very helpful:

    «Possible failure reasons: Problems with the query, «ResultSet» property not set correctly, parameters not set correctly, or connection not established correctly.»

    Why is the zip and ftp shorting the SQL?

    Any help is welcome!

    thanks

Answers

  • Hello,

    the error detail for -1073548784 suggests that SQL Server is unable to find the latest Full backup, on which to run the Differential.

    I tried disabling the Volume Shadow Copy option on Cobian Backup. Now the differential backup on SQL Server works.

    Something will not work if one of the two processes try to access the backup files in the same time frame. I will have to find some workaround for this.

    My conclusion is:

    SQL Server 2008 R2 differential backups are incompatible with Volume Shadow Copy service on Windows Server 2008 R2.

    Somehow, somewhere Volume Shadow Copy (or Cobian Backup’s use of it) breaks the ability of SQL Server to find the latest Full backup.

    • Marked as answer by

      Friday, September 28, 2012 1:20 PM

Источник

Today is SQL day for me :)

I have a maintenance plan that is failing to run with the following error:

Failed:(-1073548784) Executing the
query «USE [SharedServices1_DB]»
failed with the following error:
«Database ‘SharedServices1_DB’ cannot
be opened because it is offline.».
Possible failure reasons: Problems
with the query, «ResultSet» property
not set correctly, parameters not set
correctly, or connection not
established correctly.

where SharedServices1_DB is a database that is set to offline. I would like to exclude this database from the maintenance plan, but when the database is offline, it does not show up at all as a «specific database» in the maintenance plan task, and if I bring it online, it is already unchecked in the maintenance plan task.

How can I exclude an offline database from a maintenance plan?

asked Jun 24, 2009 at 4:48

Sean Earp's user avatar

Yes we can exclude offline DB from specific maintenance plan. Please find below steps.

  1. Right click on maintenance plan -> select ‘modify’ -> you can see plan and subplans here ->right click on plan select ‘properties’ -> properties window will open in your right hand side > expand and search for the option ‘IgnoreDatabaseInNotOnlinestate’ -> check value set for this if its false then change it to ‘True’ with the help dropdown.

It works well for me without recreating maintenance plans on server.

answered Aug 21, 2014 at 2:54

sandeep pawar's user avatar

Sql server 2008 is the only solution I’ve found. It’s got ignore offline option.

This problem is driving me nuts.

answered Aug 26, 2010 at 7:22

Gats's user avatar

GatsGats

1113 bronze badges

1

We had a similar problem recently. We ended up going from an «include all» method to a ‘pick all’ method. It means that new databases are not automatically added to the maintenance plan, which means the DBAs need to let us know they’re doing it. But the maintenance jobs no longer fail. A sub optimal solution, and perhaps there is a better way.

answered Jun 24, 2009 at 5:36

sysadmin1138's user avatar

sysadmin1138♦sysadmin1138

133k18 gold badges176 silver badges300 bronze badges

Recreating the maintenance plan while the offline database remained offline ended up solving the problem. I will leave this question open in case somebody has the answer for resolving the problem without recreating the maintenance plan.

answered Jun 24, 2009 at 6:43

Sean Earp's user avatar

Sean EarpSean Earp

7,2273 gold badges36 silver badges38 bronze badges

If it’s SQL server 2000 or 2008, there won’t be ‘execlude offline databases’ option. So below is what I did in SQL server 2000 as my Check DB maintenance plan was failing with ‘couldn’t execute because ‘xo_xo’ DB is offline’ even if the offline DBs are not included in the maintenance plan.

-> Changed the Databases drop down option to ‘All databases’ and executed. Job failed again.

->Now, changed it back to ‘Specific databases’ and selected all the dbs, executed the job. Job has succeeded :)

I don’t know whether this is the solution for it or not but it worked for me. Hope it helps :D

answered Mar 28, 2016 at 23:56

Vijay's user avatar

You must log in to answer this question.

Not the answer you’re looking for? Browse other questions tagged

.

Источник

Понравилась статья? Поделить с друзьями:
  • Ms sql логирование ошибок
  • Ms sql код ошибки 3013
  • Ms sql код ошибки 1814
  • Ms sql server ошибка 1326
  • Ms sql вернуть ошибку