October 30, 2008 at 3:28 pm
All,
I created a maintanance plan to backup all userdb full/diff/tlog. The full and diff works very good. but the tlog back failed. Here is the error message. Does anyone know the answer?
Message
Executed as user: IGTMASTER\SQL2005. ... 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:20:19 PM Progress: 2008-10-30 14:20:20.19 Source: {3EBEFB1B-DC4D-4F35-B875-706333CE2159} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2008-10-30 14:20:20.55 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'\\RNOCORPBKU".: 100% complete End Progress Progress: 2008-10-30 14:20:20.56 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'\\RNOCORPBKU".: 100% complete End Progress Progress: 2008-10-30 14:20:20.58 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'\\RNOCORPBKU".: 100% complete End Progress Progress: 2008-10-30 14:20:20.58 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_cr... The package execution fa... The step failed.
October 30, 2008 at 3:38 pm
Add logging to the maintenance plan. the logging from the job isn't great (as you can see).
Is this db in simple mode?
October 30, 2008 at 3:54 pm
The system dbs are in simple mode.
All userdbs are in full recovery mode.
October 30, 2008 at 4:25 pm
You can't backup the transaction log of databases using the simple recovery model. In addition, master can not be changed from simple recovery model.
You should seperate the system and user database backups.
October 30, 2008 at 4:39 pm
It is seperated. it is only backup tlog for all user dbs
October 30, 2008 at 8:31 pm
Hard to read the error message. Just a guess at this point, but it looks like it couldn't create a subdirectory. Two possibilities, permissions or lack of space.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply