Agent Job:LSBackup_TCD does not create a T-Log file?

Hi experts,

  I setup a log shipping to archive transaction log but it does not create a T-Log file. What's wrong?

The file 9/16 2:39am is created by T-SQL manually. By the way, I have checked the start-up account for SQL agent and authorization for shared folder.

---

C:\Scripts>"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\sqllogship.exe"
 -Backup AB94D6DA-9C27-4BF4-868C-0FFBA18D1220 -server TCCQAS2

Microsoft (R) SQL Server Log Shipping Agent
[Assembly Version = 11.0.0.0, File Version = 11.0.2100.60 ((SQL11_RTM).120210-19
17 )]
Copyright (c) 2012 Microsoft. All rights reserved.

2013-09-16 15:18:48.50  ----- START OF TRANSACTION LOG BACKUP -----
2013-09-16 15:18:48.59  Starting transaction log backup. Primary ID: 'ab94d6da-9
c27-4bf4-868c-0ffba18d1220'
2013-09-16 15:18:48.60  Retrieving backup settings. Primary ID: 'ab94d6da-9c27-4
bf4-868c-0ffba18d1220'
2013-09-16 15:18:48.61  Retrieved backup settings. Primary Database: 'TCD', Back
up Directory: 'w:\LogA', Backup Retention Period: 4320 minute(s), Backup Compres
sion: Server Default
2013-09-16 15:18:48.72  Deleting old log backup files. Primary Database: 'TCD'
2013-09-16 15:18:48.73  The backup operation was successful. Primary Database: '
TCD', Log Backup File: ''
2013-09-16 15:18:48.74  ----- END OF TRANSACTION LOG BACKUP   -----

Exit Status: 0 (Success)

C:\Scripts>dir w:\LogA
 Volume in drive W is SysVol2
 Volume Serial Number is C8B2-D565

 Directory of w:\LogA

09/15/2013  06:15 PM    <DIR>          .
09/15/2013  06:15 PM    <DIR>          ..
09/14/2013  04:30 PM     1,043,250,176 TCD_20130914083001.trn
09/14/2013  04:45 PM         7,930,880 TCD_20130914084501.trn
09/14/2013  05:00 PM         2,181,120 TCD_20130914090001.trn
09/16/2013  02:39 PM       979,136,000 TCD_20130914091501.trn
               4 File(s)  2,032,498,176 bytes
               2 Dir(s)  565,729,554,432 bytes free

C:\Scripts>

September 16th, 2013 3:30am

can you check once again on the shared folder what permission given for the sqls server service accounts, requires at least R/W or full permissions.

http://support.microsoft.com/kb/314515/en-us

Any errors reported in the Job logs and also from the sql errorlog ?

Free Windows Admin Tool Kit Click here and download it now
September 16th, 2013 4:58am

Hi Rama,

  Thanks for your reply. I check again and I create a job with the SQL service agent account and backup log to the same folder(w:\LogA\) and shared folder(\\tccqas2\LogA). It works. By the way, I set the shared authorization with everyone R/W but the problem persists.

  No, just as you can see above. There is no "*** ERROR: ... ***"  messages in job logs or SQL errorlog.

Also, I have another job LSBackup_QA2 in this SQL instance and it works fine.

September 16th, 2013 5:38am

your issue is that the log backups are not getting generating in the shared folder where the database that involved in the log shipping, Also is that same shared folder shared b/w other DB which uses the log shipping?

Also what is the schedule on those, will that also falls during other one runs?From when it is started or you  are just creating new one for the database?

Free Windows Admin Tool Kit Click here and download it now
September 16th, 2013 9:50am

Hi Rama,

  No, not the same shared folder but the authorization setting is the same.

No, the other works just fine always. (not an AlwaysOn availability database though)

From the screenshot I showed you, it seems it worked before.

Actually, this is an AlwaysOn availability database and I guess it stopped after I failed over a couple times before.

September 16th, 2013 10:02pm

Hi,
Thanks for posting question here.
I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.
Thank you for your understanding and support.
Thanks
Candy Zhou
Free Windows Admin Tool Kit Click here and download it now
September 17th, 2013 4:57am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics