litespeed full bakcup job

  • Hi,

    litespeed full user db bakcup failed with below error...anyone have any idea. please help

    Message

    Executed as user: domain\sqlservice. ...CANE' with Windows Authentication Logged on to SQL Server server123 Starting maintenance plan 'LITESPEED - FULL BACKUP all SYSTEM databases - NIGHTLY 11_55 PM [Subplan 1]' on 7/21/2012 12:40:45 AM [1] Enum database list... Selected database list: master model msdb [1] Execution Time: 0 hrs, 0 mins, 1 secs. [2] Database "master": Backup database and verify backup... LiteSpeed(R) for SQL Server Version 6.5.2.1042 Copyright 2011 Quest Software, Inc. Msg 60405, Level 16, State 1, Line 1179648: LiteSpeed for SQL Server could not open backup file: (F:\MSSQL\BACKUPS\NIGHTLY SYSTEM\master_Full_2012-07-21-004045.LSP). The previous system message is the reason for the failure. [2] Execution Time: 0 hrs, 0 mins, 1 secs. [3] Database "model": Backup database and verify backup... LiteSpeed(R) for SQL Server Version 6.5.2.1042 Copyright 2011 Quest Software, Inc. Msg 60405, Level 16, State 1, Line 1179648: LiteSpeed for SQ... The step failed.

  • laddu4700 (7/20/2012)


    Hi,

    litespeed full user db bakcup failed with below error...anyone have any idea. please help

    Message

    Executed as user: domain\sqlservice. ...CANE' with Windows Authentication Logged on to SQL Server server123 Starting maintenance plan 'LITESPEED - FULL BACKUP all SYSTEM databases - NIGHTLY 11_55 PM [Subplan 1]' on 7/21/2012 12:40:45 AM [1] Enum database list... Selected database list: master model msdb [1] Execution Time: 0 hrs, 0 mins, 1 secs. [2] Database "master": Backup database and verify backup... LiteSpeed(R) for SQL Server Version 6.5.2.1042 Copyright 2011 Quest Software, Inc. Msg 60405, Level 16, State 1, Line 1179648: LiteSpeed for SQL Server could not open backup file: (F:\MSSQL\BACKUPS\NIGHTLY SYSTEM\master_Full_2012-07-21-004045.LSP). The previous system message is the reason for the failure. [2] Execution Time: 0 hrs, 0 mins, 1 secs. [3] Database "model": Backup database and verify backup... LiteSpeed(R) for SQL Server Version 6.5.2.1042 Copyright 2011 Quest Software, Inc. Msg 60405, Level 16, State 1, Line 1179648: LiteSpeed for SQ... The step failed.

    Please verify the permissions on backup file / folders.

  • ok try running the following command:

    Exec master.dbo.xp_backup_database

    @database = 'master',

    @filename = 'F:\MSSQL\BACKUPS\master_manual_test.bak'

    if that works then try running the following command:

    Exec master.dbo.xp_backup_database

    @database = 'master',

    @filename = 'F:\MSSQL\BACKUPS\NIGHTLY SYSTEM\master_manual_test.bak'

    Maybe that space (in the NIGHTLY SYSTEM folder name ) 'is causing a problem, this is just a wild guess though.

    Also you can try performing the backup to a local drive as well to rule out a permission issue (assuming that F is a SAN storage)

  • You can also use the tools from Sysinternals to find out if the file has a lock on it.

  • yup agree with Steve, it could that good old lock on the backup file.

    Further, you usually get a specific message like the following of there are locks on backup file:

    Msg 50032, Sev 16, State 1: The process cannot access the file because it is being used by another process. LiteSpeed for SQL Server could not open the backup file.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply