locked
SMS Application Backup Issue RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    we have couple of SMS Application servers in our environment. Recently we migrated from SQL 2000 to SQL 2005 and changed SQL Service from "Local System" to our "Service account". When SMS application takes backup from their consol we are getting following error messages and backups are failing.

    We cahnged SQL Service account from "Service Account" to "Local System" then backups are running from SMS application console.

    Backup Failing Observations:
    1)Our Service Account is in Administrator Group
    2)Granted permissions in Local Security Policyes
    3) Builtin\ Administrator is Available
    4) NTAuthority \ System is available
    5) Granted Full rights to SQL Folders

    *** backup database SMS_CHE to DISK = 'E:\_SMFFB.tmp' with INIT    SMS_SITE_BACKUP   1/7/2009 6:32:02 PM      840 (0x0348)

    *** [42000][3201][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'E:\_SMFFB.tmp'. Operating system error 5(Access is denied.).   SMS_SITE_BACKUP   1/7/2009 6:32:02 PM 840 (0x0348)

    *** backup database SMS_CHE to DISK = 'E:\_SMFFB.tmp' with INIT    SMS_SITE_BACKUP   1/7/2009 6:32:02 PM      840 (0x0348)

    *** [42000][3013][Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.    SMS_SITE_BACKUP   1/7/2009 6:32:02 PM 840 (0x0348)

    Failed to backup site database SMS_CHE up to E:\mssql\data\sms_bak\CHEBackup\SiteDBServer\SMSbkSQLDBsite.dat: ~Error executing SQL backup command.          SMS_SITE_BACKUP   1/7/2009 6:32:02 PM 840 (0x0348)


    Trying database backup through temp file  SMS_SITE_BACKUP   1/7/2009 7:04:29 PM 11900 (0x2E7C)

    *** backup database SMS_HYD to DISK = 'F:\_SM128A.tmp' with INIT  SMS_SITE_BACKUP   1/7/2009 7:04:30 PM      11900 (0x2E7C)

    *** [42000][3201][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'F:\_SM128A.tmp'. Operating system error 5(Access is denied.).  SMS_SITE_BACKUP   1/7/2009 7:04:30 PM          11900 (0x2E7C)

    *** backup database SMS_HYD to DISK = 'F:\_SM128A.tmp' with INIT  SMS_SITE_BACKUP   1/7/2009 7:04:30 PM      11900 (0x2E7C)

    *** [42000][3013][Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.    SMS_SITE_BACKUP   1/7/2009 7:04:30 PM 11900 (0x2E7C)

    Failed to backup site database SMS_HYD up to E:\mssql\MSSQL\BACKUP\HYDBackup\SiteDBServer\SMSbkSQLDBsite.dat: ~Error executing SQL backup command.      SMS_SITE_BACKUP   1/7/2009 7:04:30 PM 11900 (0x2E7C) 


    kindly let us know if any other changes need to done.

    Thanks

    Srikanth.kls
    Wednesday, November 11, 2009 6:11 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote
    *** [42000][3201][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'E:\_SMFFB.tmp'. Operating system error 5(Access is denied.).   SMS_SITE_BACKUP   1/7/2009 6:32:02 PM 840 (0x0348)
    The error is clearly stated in the logs. Please double check the NTFS security permissions on the folder mentioned.
    Wednesday, November 11, 2009 10:15 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    *** [42000][3201][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'E:\_SMFFB.tmp'. Operating system error 5(Access is denied.).   SMS_SITE_BACKUP   1/7/2009 6:32:02 PM 840 (0x0348)
    The error is clearly stated in the logs. Please double check the NTFS security permissions on the folder mentioned.
    Wednesday, November 11, 2009 10:15 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    http://www.myitforum.com/forums/m_102881/printable.htm

    check abov link
    Thursday, November 12, 2009 12:33 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    http://www.eggheadcafe.com/software/aspnet/29116248/sms-backup-task-error.aspx


    take a look in above link
    Thursday, November 12, 2009 12:41 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as ‘Answered’ as the previous steps should be helpful for many similar scenarios.

    If the issue still persists and you want to return to this question, please reply this post directly so we will be notified to follow it up. You can also choose to unmark the answer as you wish.

    In addition, we’d love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems.

    Thanks!
    Tuesday, November 17, 2009 10:55 AM