July 20, 2012 at 11:43 pm
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.
July 21, 2012 at 8:42 am
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.
July 21, 2012 at 9:41 am
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)
July 21, 2012 at 10:54 am
You can also use the tools from Sysinternals to find out if the file has a lock on it.
July 21, 2012 at 12:41 pm
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply