SQL 2012 Log shipping standard edition


I am having 3 server with same configuration one is production and other two is DR and Near DR I am using log shipping as high availability.

Suddenly something happens and DR and Near DR databases goes to restoring mode from standby/readonlymode.

I find the below error in error log.

Date        10/7/2014 3:00:01 PM
Log        Job History (LSRestore_JDCCBSQL_JDCCBPROD)

Step ID        1
Server        DB-SERVER
Job Name        LSRestore_JDCCBSQL_JDCCBPROD
Step Name        Log shipping restore log job step.
Duration        00:00:20
Sql Severity    0
Sql Message ID    0
Operator Emailed    
Operator Net sent    
Operator Paged    
Retries Attempted    0

Message
2014-10-07 15:00:21.11    *** Error: Could not apply log backup file '\\DB-SERVER\Jdccbprod_logshipping\JDCCBPROD_20141007054512.trn' to secondary database 'JDCCBPROD'.(Microsoft.SqlServer.Management.LogShipping) ***
2014-10-07 15:00:21.11    *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-10-07 15:00:21.11    *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-10-07 15:00:21.11    *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-10-07 15:00:21.11    Skipping log backup file '\\DB-SERVER\Jdccbprod_logshipping\JDCCBPROD_20141007054512.trn' for secondary database 'JDCCBPROD' because the file could not be verified.
2014-10-07 15:00:21.11    *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-10-07 15:00:21.11    *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-10-07 15:00:21.11    *** Error: An error occurred restoring the database access mode.(Microsoft.SqlServer.Management.LogShipping) ***
2014-10-07 15:00:21.11    *** Error: ExecuteScalar requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-10-07 15:00:21.11    *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-10-07 15:00:21.11    *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-10-07 15:00:21.11    *** Error: Could not apply log backup file '\\DB-SERVER\Jdccbprod_logshipping\JDCCBPROD_20141007060012.trn' to secondary database 'JDCCBPROD'.(Microsoft.SqlServer.Management.LogShipping) ***
2014-10-07 15:00:21.11    *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-10-07 15:00:21.11    *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-10-07 15:00:21.11    *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-10-07 15:00:21.11    Skipping log backup file '\\DB-SERVER\Jdccbprod_logshipping\JDCCBPROD_20141007060012.trn' for secondary database 'JDCCBPROD' because the file could not be verified.
2014-10-07 15:00:21.11    *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-10-07 15:00:21.11    *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-10-07 15:00:21.11    *** Error: An error occurred restoring the database access mode.(Microsoft.SqlServer.Management.LogShipping) ***
2014-10-07 15:00:21.11    *** Error: ExecuteScalar requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-10-07 15:00:21.11    *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-10-07 15:00:21.11    *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***

Even I can give remote access for resolving please kindly help me.

Regards,

Satish

October 7th, 2014 9:50am

>>Suddenly something happens and DR and Near DR databases goes to restoring mode from standby/readonlymode.

Was DR server or SQL Server agent or SQL server service restarted. I Guess there was a restart of any of these 3 services which caused Logshipping secondary database to go in recovery. Please check thoroughly, check when was DR SQL server last started last started.

Free Windows Admin Tool Kit Click here and download it now
October 7th, 2014 10:00am


Dear Shanky,

This is happening every day from lost 1 month  both the DR servers go to restoring mode at a time.

Even I verified the .trn file which was not restored after lost restoration it shows valid on both the server.

Every day morning I am taking good backup and using the below query to make it standby/readonly and again it goes in to restoring mode.


restore database [JDCCBPROD] from disk='E:\DR_LOGSHIPPING\JDCCBPROD.bak' with
move 'JDCCBPROD' to 'E:\CBSDATA\JDCCBPROD.mdf',
move 'MASTER_DATA' to 'E:\CBSDATA\MASTER_DATA.ndf',
move 'MASTER_INDEX' to 'E:\CBSDATA\MASTER_INDEX.ndf',
move 'TRANS_DATA' to 'E:\CBSDATA\TRANS_DATA.ndf',
move 'TRANS_INDEX' to 'E:\CBSDATA\TRANS_INDEX.ndf',
move 'JDCCBPROD_log' to 'E:\CBSDATA\JDCCBPROD_log.ldf',
replace,standby='E:\CBSDATA\JDCCBPROD.tuf',stats=1

I checked with the below query for Last Restart of sql server

SELECT sqlserver_start_time FROM sys.dm_os_sys_info

Reult: sqlserver_start_time
2014-08-30 11:43:01.270



October 7th, 2014 10:11am

Why are you restoring the database everyday ? It is not required. Check your sql jobs whether there is some job which is doing this?
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2014 10:25am

Please read the thread once again.

If the database is in restoring mode continuously with out updating any logs what will be the use even I am not able to read the data.

So I am restoring it in standby/read only mode, after then only the log are updating on the database.

October 7th, 2014 10:37am

What I am saying is that is a dirty workaround. you are almost reconfiguring logshipping everyday .

You need to find out why it is going to restoring mode. If you restore your database everyday you are reducing the chance to find the original root cause..

Could you run this query?

select * from msdb..restorehistory where destination_database_name = 'Database_name'

Free Windows Admin Tool Kit Click here and download it now
October 7th, 2014 10:45am

Hello Ashwin,

Do you have Team Viewer can I have your contact number.

After running that query it generated a report it is very large I am not able to attach here.

I copied sum of them

restore_history_id restore_date destination_database_name user_name backup_set_id restore_type replace recovery restart stop_at device_count stop_at_mark_name stop_before
1847 53:14.2 JDCCBPROD sa 1847 D 1 1 0 NULL 1 NULL NULL
1848 02:50.9 JDCCBPROD JDCCB\Administrator 1848 L 0 1 0 NULL 1 NULL NULL
1849 45:12.8 JDCCBPROD JDCCB\Administrator 1849 L 0 1 0 NULL 1 NULL NULL
1850 45:14.3 JDCCBPROD JDCCB\Administrator 1850 L 0 1 0 NULL 1 NULL NULL
1851 15:13.1 JDCCBPROD JDCCB\Administrator 1851 L 0 1 0 NULL 1 NULL NULL
1852 15:15.9 JDCCBPROD JDCCB\Administrator 1852 L 0 1 0 NULL 1 NULL NULL
1853 30:13.1 JDCCBPROD JDCCB\Administrator 1853 L 0 1 0 NULL 1 NULL NULL

October 7th, 2014 10:55am

I am sorry I dont have team viewer and I am not in a position to take calls.

But, could you check the time you start getting errors about your database going into recovery mode and then correlate with the result of the query. You need to see if you can find which account has tried to do the restore. that should help you to further find out how it is done .

Also check sql server error log during the same time and see if you find any errors

Free Windows Admin Tool Kit Click here and download it now
October 7th, 2014 11:20am

Hello Ashwin,

Do you have Team Viewer can I have your contact number.

After running that query it generated a report it is very large I am not able to attach here.

I copied sum of them

October 7th, 2014 11:21am

I am sorry I copied the data in excel that's why format is changed

Can you call me on this number 09987836909, Can I have your e-mail id so that I can send that excel

restore_history_id restore_date destination_database_name user_name backup_set_id restore_type replace recovery restart stop_at device_count stop_at_mark_name stop_before
1847 53:14.2 JDCCBPROD sa 1847 D 1 1 0 NULL 1 NULL NULL
1848 02:50.9 JDCCBPROD JDCCB\Administrator 1848 L 0 1 0 NULL 1 NULL NULL
1849 45:12.8 JDCCBPROD JDCCB\Administrator 1849 L 0 1 0 NULL 1 NULL NULL
1850 45:14.3 JDCCBPROD JDCCB\Administrator 1850 L 0 1 0 NULL 1 NULL NULL
1851 15:13.1 JDCCBPROD JDCCB\Administrator 1851 L 0 1 0 NULL 1 NULL NULL
1852 15:15.9 JDCCBPROD JDCCB\Administrator 1852 L 0 1 0 NULL 1 NULL NULL
1853 30:13.1 JDCCBPROD JDCCB\Administrator 1853 L 0 1 0 NULL 1 NULL NULL
Free Windows Admin Tool Kit Click here and download it now
October 7th, 2014 11:35am

restore_history_id restore_date destination_database_name user_name backup_set_id restore_type replace recovery restart stop_at device_count stop_at_mark_name stop_before
5227 9/23/2014 23:15 JDCCBPROD JDCCB\Administrator 5227 L 0 1 0 NULL 1 NULL NULL
5226 9/24/2014 23:15 JDCCBPROD JDCCB\Administrator 5226 L 0 1 0 NULL 1 NULL NULL
5225 9/25/2014 23:15 JDCCBPROD JDCCB\Administrator 5225 L 0 1 0 NULL 1 NULL NULL
5224 9/26/2014 23:15 JDCCBPROD JDCCB\Administrator 5224 L 0 1 0 NULL 1 NULL NULL
5223 9/27/2014 23:15 JDCCBPROD JDCCB\Administrator 5223 L 0 1 0 NULL 1 NULL NULL
5222 9/28/2014 23:15 JDCCBPROD JDCCB\Administrator 5222 L 0 1 0 NULL 1 NULL NULL
5221 9/29/2014 23:15 JDCCBPROD JDCCB\Administrator 5221 L 0 1 0 NULL 1 NULL NULL
5220 9/30/2014 23:15 JDCCBPROD JDCCB\Administrator 5220 L 0 1 0 NULL 1 NULL NULL
5219 10/1/2014 23:15 JDCCBPROD JDCCB\Administrator 5219 L 0 1 0 NULL 1 NULL NULL
5218 10/2/2014 23:15 JDCCBPROD JDCCB\Administrator 5218 L 0 1 0 NULL 1 NULL NULL
5217 10/3/2014 23:15 JDCCBPROD JDCCB\Administrator 5217 L 0 1 0 NULL 1 NULL NULL
5216 10/4/2014 23:15 JDCCBPROD JDCCB\Administrator 5216 L 0 1 0 NULL 1 NULL NULL
5215 10/5/2014 23:15 JDCCBPROD JDCCB\Administrator 5215 L 0 1 0 NULL 1 NULL NULL
5214 10/6/2014 23:15 JDCCBPROD JDCCB\Administrator 5214 L 0 1 0 NULL 1 NULL NULL
5213 10/7/2014 23:15 JDCCBPROD JDCCB\Administrator 5213 L 0 1 0 NULL 1 NULL NULL
5212 10/8/2014 23:15 JDCCBPROD JDCCB\Administrator 5212 L 0 1 0 NULL 1 NULL NULL
5211 10/9/2014 23:15 JDCCBPROD JDCCB\Administrator 5211 L 0 1 0 NULL 1 NULL NULL
5210 10/10/2014 23:15 JDCCBPROD JDCCB\Administrator 5210 L 0 1 0 NULL 1 NULL NULL
5209 10/11/2014 23:15 JDCCBPROD JDCCB\Administrator 5209 L 0 1 0 NULL 1 NULL NULL
October 7th, 2014 11:54am

 Hi Satish .

Please let me know below ones, upon will go further analysis

1) Are you sure , is not running any other backup jobs (.trn) on source machine.

2) Are you sure is data copying  from source shared folder to DR/N.DR shared folder ( check size )

3) are you verify the last .trm backup file valid or not  ?

4)  Are  you sure all ( source/DR/N.DR)  sql agent jobs are running same account ?

5) Are you sure , .trn files are moving from source to DR through job (or)any other own script ?

 



Free Windows Admin Tool Kit Click here and download it now
October 7th, 2014 12:06pm

Hello Shanky,

I had sent you the reader error log and msdb..restore history output on your e-mail please check it.

October 8th, 2014 1:39am

Hello Kiran

I am sure there are no other backup jobs or running.

I am sure about data copying it is perfect there is no mismatch of size

I verified the .trn file it show valid

All the agents are running on the same account.

.trn files are moving with help of job only there are not other scripts even now also data is moving perfectly the  problem is only on restoring.

Free Windows Admin Tool Kit Click here and download it now
October 8th, 2014 1:43am

Hello Shanky,

I had sent you the reader error log and msdb..restore history output on your e-mail please check it.

October 8th, 2014 8:53am

I am sorry I did not understand what you are asking could you please clarify me.

Free Windows Admin Tool Kit Click here and download it now
October 8th, 2014 9:08am

I am just clarifying what Shanky asked ----

The part of world where I live, today is 8th october 2014. The output you posted from msdb.dbo.restorehistory has the below dates

















































































































































































































5212 10/8/2014 23:15 JDCCBPROD JDCCB\Administrator 5212 L 0 1 0 NULL 1 NULL NULL
5211 10/9/2014 23:15 JDCCBPROD JDCCB\Administrator 5211 L 0 1 0 NULL 1 NULL NULL
5210 10/10/2014 23:15 JDCCBPROD JDCCB\Administrator 5210 L 0 1 0 NULL 1 NULL NULL
5209 10/11/2014 23:15 JDCCBPROD JDCCB\Administrator 5209 L 0 1 0 NULL 1 NULL NULL
5212 10/8/2014 23:15 JDCCBPROD JDCCB\Administrator 5212 L 0 1 0 NULL 1 NULL NULL
5211 10/9/2014 23:15 JDCCBPROD JDCCB\Administrator 5211 L 0 1 0 NULL 1 NULL NULL
5210 10/10/2014 23:15 JDCCBPROD JDCCB\Administrator 5210 L 0 1 0 NULL 1 NULL NULL
5209 10/11/2014 23:15 JDCCBPROD JDCCB\

now in any part of the world these dates ( in Bold) are from future . That is what Shanky is asking in his last two posts why the system dates are screwed.

Considering all the discussions here, I would suggest you to drop logshipping completely and then start once again from scratch and see if the issue re-occurs, but that should be done only after fixing the dates issue.

October 8th, 2014 9:34am

I am sorry for that.

The date conversion was changed when I copied in to excel.

Now I am sending a fresh one please go through this  output once.

restore_history_id	restore_date	destination_database_name	user_name	backup_set_id	restore_type	replace	recovery	restart	stop_at	device_count	stop_at_mark_name	stop_before
1294	2014-09-17 12:52:22.310	JDCCBPROD	JDCCB\sqladmin	2978	D	1	1	0	NULL	1	NULL	NULL
1295	2014-09-17 12:58:41.183	JDCCBPROD	JDCCB\administrator	2979	L	0	1	0	NULL	1	NULL	NULL
1296	2014-09-17 13:03:48.420	JDCCBPROD	JDCCB\administrator	2980	L	0	1	0	NULL	1	NULL	NULL
1297	2014-09-17 13:03:57.660	JDCCBPROD	JDCCB\administrator	2981	L	0	1	0	NULL	1	NULL	NULL
1298	2014-09-17 13:30:19.237	JDCCBPROD	JDCCB\administrator	2982	L	0	1	0	NULL	1	NULL	NULL
1299	2014-09-17 14:00:20.007	JDCCBPROD	JDCCB\administrator	2983	L	0	1	0	NULL	1	NULL	NULL
1300	2014-09-17 14:15:17.777	JDCCBPROD	JDCCB\administrator	2984	L	0	1	0	NULL	1	NULL	NULL
1301	2014-09-17 14:15:24.123	JDCCBPROD	JDCCB\administrator	2985	L	0	1	0	NULL	1	NULL	NULL
1302	2014-09-17 14:45:18.677	JDCCBPROD	JDCCB\administrator	2986	L	0	1	0	NULL	1	NULL	NULL
1303	2014-09-17 15:00:19.670	JDCCBPROD	JDCCB\administrator	2987	L	0	1	0	NULL	1	NULL	NULL
1304	2014-09-17 15:15:18.860	JDCCBPROD	JDCCB\administrator	2988	L	0	1	0	NULL	1	NULL	NULL
1305	2014-09-17 15:30:18.363	JDCCBPROD	JDCCB\administrator	2989	L	0	1	0	NULL	1	NULL	NULL
1306	2014-09-17 15:45:19.910	JDCCBPROD	JDCCB\administrator	2990	L	0	1	0	NULL	1	NULL	NULL
1307	2014-09-17 16:00:18.570	JDCCBPROD	JDCCB\administrator	2991	L	0	1	0	NULL	1	NULL	NULL
1308	2014-09-17 16:15:18.520	JDCCBPROD	JDCCB\administrator	2992	L	0	1	0	NULL	1	NULL	NULL
1309	2014-09-17 16:30:18.173	JDCCBPROD	JDCCB\administrator	2993	L	0	1	0	NULL	1	NULL	NULL
1310	2014-09-17 16:45:20.460	JDCCBPROD	JDCCB\administrator	2994	L	0	1	0	NULL	1	NULL	NULL
1311	2014-09-17 17:00:19.767	JDCCBPROD	JDCCB\administrator	2995	L	0	1	0	NULL	1	NULL	NULL
1312	2014-09-17 17:15:19.173	JDCCBPROD	JDCCB\administrator	2996	L	0	1	0	NULL	1	NULL	NULL
1313	2014-09-17 17:30:20.380	JDCCBPROD	JDCCB\administrator	2997	L	0	1	0	NULL	1	NULL	NULL
1314	2014-09-17 17:45:19.977	JDCCBPROD	JDCCB\administrator	2998	L	0	1	0	NULL	1	NULL	NULL
1315	2014-09-17 18:00:17.757	JDCCBPROD	JDCCB\administrator	2999	L	0	1	0	NULL	1	NULL	NULL
1316	2014-09-17 18:15:17.060	JDCCBPROD	JDCCB\administrator	3000	L	0	1	0	NULL	1	NULL	NULL
1317	2014-09-18 10:21:40.773	JDCCBPROD	JDCCB\sqladmin	2978	D	1	1	0	NULL	1	NULL	NULL
1318	2014-09-18 10:25:23.960	JDCCBPROD	JDCCB\administrator	2979	L	0	1	0	NULL	1	NULL	NULL
1319	2014-09-18 10:25:29.777	JDCCBPROD	JDCCB\administrator	2980	L	0	1	0	NULL	1	NULL	NULL
1320	2014-09-18 10:25:35.743	JDCCBPROD	JDCCB\administrator	2981	L	0	1	0	NULL	1	NULL	NULL
1321	2014-09-18 10:25:43.763	JDCCBPROD	JDCCB\administrator	2982	L	0	1	0	NULL	1	NULL	NULL
1322	2014-09-18 10:25:51.523	JDCCBPROD	JDCCB\administrator	2983	L	0	1	0	NULL	1	NULL	NULL
1323	2014-09-18 10:25:58.740	JDCCBPROD	JDCCB\administrator	2984	L	0	1	0	NULL	1	NULL	NULL
1324	2014-09-18 10:26:05.137	JDCCBPROD	JDCCB\administrator	2985	L	0	1	0	NULL	1	NULL	NULL
1325	2014-09-18 10:26:13.427	JDCCBPROD	JDCCB\administrator	2986	L	0	1	0	NULL	1	NULL	NULL
1326	2014-09-18 10:26:24.307	JDCCBPROD	JDCCB\administrator	2987	L	0	1	0	NULL	1	NULL	NULL
1327	2014-09-18 10:26:43.393	JDCCBPROD	JDCCB\administrator	2988	L	0	1	0	NULL	1	NULL	NULL
1328	2014-09-18 10:27:05.020	JDCCBPROD	JDCCB\administrator	2989	L	0	1	0	NULL	1	NULL	NULL
1329	2014-09-18 10:27:27.857	JDCCBPROD	JDCCB\administrator	2990	L	0	1	0	NULL	1	NULL	NULL
1330	2014-09-18 10:27:38.467	JDCCBPROD	JDCCB\administrator	2991	L	0	1	0	NULL	1	NULL	NULL
1331	2014-09-18 10:27:47.110	JDCCBPROD	JDCCB\administrator	2992	L	0	1	0	NULL	1	NULL	NULL
1332	2014-09-18 10:28:02.840	JDCCBPROD	JDCCB\administrator	2993	L	0	1	0	NULL	1	NULL	NULL
1333	2014-09-18 10:28:24.157	JDCCBPROD	JDCCB\administrator	2994	L	0	1	0	NULL	1	NULL	NULL
1334	2014-09-18 10:28:45.527	JDCCBPROD	JDCCB\administrator	2995	L	0	1	0	NULL	1	NULL	NULL
1335	2014-09-18 10:29:09.640	JDCCBPROD	JDCCB\administrator	2996	L	0	1	0	NULL	1	NULL	NULL
1336	2014-09-18 10:29:28.797	JDCCBPROD	JDCCB\administrator	2997	L	0	1	0	NULL	1	NULL	NULL
1337	2014-09-18 10:30:04.223	JDCCBPROD	JDCCB\administrator	2998	L	0	1	0	NULL	1	NULL	NULL
1338	2014-09-18 10:30:37.297	JDCCBPROD	JDCCB\administrator	2999	L	0	1	0	NULL	1	NULL	NULL
1339	2014-09-18 10:31:06.197	JDCCBPROD	JDCCB\administrator	3000	L	0	1	0	NULL	1	NULL	NULL
1340	2014-09-18 11:26:11.260	JDCCBPROD	JDCCB\sqladmin	3001	D	1	1	0	NULL	1	NULL	NULL
1341	2014-09-18 11:33:54.730	JDCCBPROD	JDCCB\administrator	3002	L	0	1	0	NULL	1	NULL	NULL
1342	2014-09-18 11:34:08.050	JDCCBPROD	JDCCB\administrator	3003	L	0	1	0	NULL	1	NULL	NULL
1343	2014-09-18 11:34:23.360	JDCCBPROD	JDCCB\administrator	3004	L	0	1	0	NULL	1	NULL	NULL
1344	2014-09-18 12:00:18.960	JDCCBPROD	JDCCB\administrator	3005	L	0	1	0	NULL	1	NULL	NULL
1345	2014-09-18 12:15:20.570	JDCCBPROD	JDCCB\administrator	3006	L	0	1	0	NULL	1	NULL	NULL
1346	2014-09-18 12:15:38.037	JDCCBPROD	JDCCB\administrator	3007	L	0	1	0	NULL	1	NULL	NULL
1347	2014-09-18 12:30:20.433	JDCCBPROD	JDCCB\administrator	3008	L	0	1	0	NULL	1	NULL	NULL
1348	2014-09-18 13:00:18.517	JDCCBPROD	JDCCB\administrator	3009	L	0	1	0	NULL	1	NULL	NULL
1349	2014-09-18 13:00:36.593	JDCCBPROD	JDCCB\administrator	3010	L	0	1	0	NULL	1	NULL	NULL
1350	2014-09-18 13:30:17.700	JDCCBPROD	JDCCB\administrator	3011	L	0	1	0	NULL	1	NULL	NULL
1351	2014-09-18 13:45:20.513	JDCCBPROD	JDCCB\administrator	3012	L	0	1	0	NULL	1	NULL	NULL
1352	2014-09-18 13:45:35.657	JDCCBPROD	JDCCB\administrator	3013	L	0	1	0	NULL	1	NULL	NULL
1353	2014-09-18 14:30:12.397	JDCCBPROD	JDCCB\administrator	3014	L	0	1	0	NULL	1	NULL	NULL
1354	2014-09-18 14:30:30.210	JDCCBPROD	JDCCB\administrator	3015	L	0	1	0	NULL	1	NULL	NULL
1355	2014-09-18 14:30:46.703	JDCCBPROD	JDCCB\administrator	3016	L	0	1	0	NULL	1	NULL	NULL
1356	2014-09-18 15:00:17.770	JDCCBPROD	JDCCB\administrator	3017	L	0	1	0	NULL	1	NULL	NULL
1357	2014-09-18 15:15:21.510	JDCCBPROD	JDCCB\administrator	3018	L	0	1	0	NULL	1	NULL	NULL
1358	2014-09-18 15:15:37.760	JDCCBPROD	JDCCB\administrator	3019	L	0	1	0	NULL	1	NULL	NULL
1359	2014-09-18 15:45:17.650	JDCCBPROD	JDCCB\administrator	3020	L	0	1	0	NULL	1	NULL	NULL
1360	2014-09-18 16:00:18.317	JDCCBPROD	JDCCB\administrator	3021	L	0	1	0	NULL	1	NULL	NULL
1361	2014-09-18 16:15:17.323	JDCCBPROD	JDCCB\administrator	3022	L	0	1	0	NULL	1	NULL	NULL
1362	2014-09-18 16:30:20.610	JDCCBPROD	JDCCB\administrator	3023	L	0	1	0	NULL	1	NULL	NULL
1363	2014-09-18 16:45:19.817	JDCCBPROD	JDCCB\administrator	3024	L	0	1	0	NULL	1	NULL	NULL
1364	2014-09-18 17:00:20.167	JDCCBPROD	JDCCB\administrator	3025	L	0	1	0	NULL	1	NULL	NULL
1365	2014-09-18 17:15:20.250	JDCCBPROD	JDCCB\administrator	3026	L	0	1	0	NULL	1	NULL	NULL
1366	2014-09-18 17:30:21.970	JDCCBPROD	JDCCB\administrator	3027	L	0	1	0	NULL	1	NULL	NULL
1367	2014-09-18 17:30:35.973	JDCCBPROD	JDCCB\administrator	3028	L	0	1	0	NULL	1	NULL	NULL
1368	2014-09-18 18:00:21.467	JDCCBPROD	JDCCB\administrator	3029	L	0	1	0	NULL	1	NULL	NULL
1369	2014-09-18 18:00:34.397	JDCCBPROD	JDCCB\administrator	3030	L	0	1	0	NULL	1	NULL	NULL
1370	2014-09-18 18:30:19.090	JDCCBPROD	JDCCB\administrator	3031	L	0	1	0	NULL	1	NULL	NULL
1371	2014-09-18 18:45:18.380	JDCCBPROD	JDCCB\administrator	3032	L	0	1	0	NULL	1	NULL	NULL
1372	2014-09-18 19:00:18.973	JDCCBPROD	JDCCB\administrator	3033	L	0	1	0	NULL	1	NULL	NULL
1373	2014-09-18 19:15:21.413	JDCCBPROD	JDCCB\administrator	3034	L	0	1	0	NULL	1	NULL	NULL
1374	2014-09-18 19:15:28.207	JDCCBPROD	JDCCB\administrator	3035	L	0	1	0	NULL	1	NULL	NULL
1375	2014-09-18 19:45:20.437	JDCCBPROD	JDCCB\administrator	3036	L	0	1	0	NULL	1	NULL	NULL
1376	2014-09-18 20:00:17.090	JDCCBPROD	JDCCB\administrator	3037	L	0	1	0	NULL	1	NULL	NULL
1377	2014-09-18 20:15:19.300	JDCCBPROD	JDCCB\administrator	3038	L	0	1	0	NULL	1	NULL	NULL
1378	2014-09-18 20:30:17.770	JDCCBPROD	JDCCB\administrator	3039	L	0	1	0	NULL	1	NULL	NULL
1379	2014-09-18 20:45:21.740	JDCCBPROD	JDCCB\administrator	3040	L	0	1	0	NULL	1	NULL	NULL
1380	2014-09-18 20:45:28.230	JDCCBPROD	JDCCB\administrator	3041	L	0	1	0	NULL	1	NULL	NULL
1381	2014-09-18 21:15:18.850	JDCCBPROD	JDCCB\administrator	3042	L	0	1	0	NULL	1	NULL	NULL
1382	2014-09-18 21:30:20.557	JDCCBPROD	JDCCB\administrator	3043	L	0	1	0	NULL	1	NULL	NULL
1383	2014-09-18 21:45:20.907	JDCCBPROD	JDCCB\administrator	3044	L	0	1	0	NULL	1	NULL	NULL
1384	2014-09-18 21:45:28.593	JDCCBPROD	JDCCB\administrator	3045	L	0	1	0	NULL	1	NULL	NULL
1385	2014-09-18 22:15:17.377	JDCCBPROD	JDCCB\administrator	3046	L	0	1	0	NULL	1	NULL	NULL
1386	2014-09-18 22:30:19.153	JDCCBPROD	JDCCB\administrator	3047	L	0	1	0	NULL	1	NULL	NULL
1387	2014-09-19 09:55:29.700	JDCCBPROD	JDCCB\sqladmin	3048	D	1	1	0	NULL	1	NULL	NULL
1389	2014-09-19 10:43:25.977	JDCCBPROD	JDCCB\administrator	3050	L	0	1	0	NULL	1	NULL	NULL
1390	2014-09-19 10:43:49.310	JDCCBPROD	JDCCB\administrator	3051	L	0	1	0	NULL	1	NULL	NULL
1391	2014-09-19 14:17:28.223	JDCCBPROD	JDCCB\administrator	3052	L	0	1	0	NULL	1	NULL	NULL
1392	2014-09-19 14:17:54.657	JDCCBPROD	JDCCB\administrator	3053	L	0	1	0	NULL	1	NULL	NULL
1393	2014-09-19 14:18:34.767	JDCCBPROD	JDCCB\administrator	3054	L	0	1	0	NULL	1	NULL	NULL
1394	2014-09-19 14:19:18.547	JDCCBPROD	JDCCB\administrator	3055	L	0	1	0	NULL	1	NULL	NULL
1395	2014-09-19 14:19:54.977	JDCCBPROD	JDCCB\administrator	3056	L	0	1	0	NULL	1	NULL	NULL
1396	2014-09-19 14:20:38.250	JDCCBPROD	JDCCB\administrator	3057	L	0	1	0	NULL	1	NULL	NULL
1397	2014-09-19 14:21:15.063	JDCCBPROD	JDCCB\administrator	3058	L	0	1	0	NULL	1	NULL	NULL
1398	2014-09-19 14:22:03.263	JDCCBPROD	JDCCB\administrator	3059	L	0	1	0	NULL	1	NULL	NULL
1399	2014-09-19 14:22:34.277	JDCCBPROD	JDCCB\administrator	3060	L	0	1	0	NULL	1	NULL	NULL
1400	2014-09-19 14:23:21.157	JDCCBPROD	JDCCB\administrator	3061	L	0	1	0	NULL	1	NULL	NULL
1401	2014-09-19 14:23:55.987	JDCCBPROD	JDCCB\administrator	3062	L	0	1	0	NULL	1	NULL	NULL
1402	2014-09-19 14:24:38.680	JDCCBPROD	JDCCB\administrator	3063	L	0	1	0	NULL	1	NULL	NULL
1403	2014-09-19 14:25:13.510	JDCCBPROD	JDCCB\administrator	3064	L	0	1	0	NULL	1	NULL	NULL
1404	2014-09-19 14:25:55.000	JDCCBPROD	JDCCB\administrator	3065	L	0	1	0	NULL	1	NULL	NULL
1405	2014-09-19 14:26:38.087	JDCCBPROD	JDCCB\administrator	3066	L	0	1	0	NULL	1	NULL	NULL
1406	2014-09-20 10:26:55.757	JDCCBPROD	JDCCB\administrator	3068	L	0	1	0	NULL	1	NULL	NULL
1407	2014-09-20 10:27:12.650	JDCCBPROD	JDCCB\administrator	3069	L	0	1	0	NULL	1	NULL	NULL
1408	2014-09-20 10:27:30.303	JDCCBPROD	JDCCB\administrator	3070	L	0	1	0	NULL	1	NULL	NULL
1409	2014-09-20 10:27:45.553	JDCCBPROD	JDCCB\administrator	3071	L	0	1	0	NULL	1	NULL	NULL
1410	2014-09-20 10:28:01.807	JDCCBPROD	JDCCB\administrator	3072	L	0	1	0	NULL	1	NULL	NULL
1411	2014-09-20 10:28:18.657	JDCCBPROD	JDCCB\administrator	3073	L	0	1	0	NULL	1	NULL	NULL
1412	2014-09-20 10:28:33.663	JDCCBPROD	JDCCB\administrator	3074	L	0	1	0	NULL	1	NULL	NULL
1413	2014-09-20 10:28:53.543	JDCCBPROD	JDCCB\administrator	3075	L	0	1	0	NULL	1	NULL	NULL
1414	2014-09-20 10:29:10.163	JDCCBPROD	JDCCB\administrator	3076	L	0	1	0	NULL	1	NULL	NULL
1415	2014-09-20 10:29:27.573	JDCCBPROD	JDCCB\administrator	3077	L	0	1	0	NULL	1	NULL	NULL
1416	2014-09-20 10:29:45.200	JDCCBPROD	JDCCB\administrator	3078	L	0	1	0	NULL	1	NULL	NULL
1417	2014-09-20 10:30:02.650	JDCCBPROD	JDCCB\administrator	3079	L	0	1	0	NULL	1	NULL	NULL
1418	2014-09-20 10:30:19.643	JDCCBPROD	JDCCB\administrator	3080	L	0	1	0	NULL	1	NULL	NULL
1419	2014-09-20 10:30:35.140	JDCCBPROD	JDCCB\administrator	3081	L	0	1	0	NULL	1	NULL	NULL
1420	2014-09-20 10:30:50.900	JDCCBPROD	JDCCB\administrator	3082	L	0	1	0	NULL	1	NULL	NULL
1421	2014-09-20 10:31:08.770	JDCCBPROD	JDCCB\administrator	3083	L	0	1	0	NULL	1	NULL	NULL
1422	2014-09-20 10:31:21.523	JDCCBPROD	JDCCB\administrator	3084	L	0	1	0	NULL	1	NULL	NULL
1423	2014-09-20 10:31:33.583	JDCCBPROD	JDCCB\administrator	3085	L	0	1	0	NULL	1	NULL	NULL
1424	2014-09-20 10:31:45.873	JDCCBPROD	JDCCB\administrator	3086	L	0	1	0	NULL	1	NULL	NULL
1425	2014-09-20 10:31:58.893	JDCCBPROD	JDCCB\administrator	3087	L	0	1	0	NULL	1	NULL	NULL
1426	2014-09-20 10:32:09.817	JDCCBPROD	JDCCB\administrator	3088	L	0	1	0	NULL	1	NULL	NULL
1427	2014-09-20 10:32:20.443	JDCCBPROD	JDCCB\administrator	3089	L	0	1	0	NULL	1	NULL	NULL
1428	2014-09-20 10:32:30.960	JDCCBPROD	JDCCB\administrator	3090	L	0	1	0	NULL	1	NULL	NULL
1429	2014-09-20 10:32:40.297	JDCCBPROD	JDCCB\administrator	3091	L	0	1	0	NULL	1	NULL	NULL
1430	2014-09-20 10:32:50.440	JDCCBPROD	JDCCB\administrator	3092	L	0	1	0	NULL	1	NULL	NULL
1431	2014-09-20 10:33:01.407	JDCCBPROD	JDCCB\administrator	3093	L	0	1	0	NULL	1	NULL	NULL
1432	2014-09-20 10:34:49.990	JDCCBPROD	JDCCB\sqladmin	3094	D	1	1	0	NULL	1	NULL	NULL
1433	2014-09-20 11:00:15.800	JDCCBPROD	JDCCB\administrator	3095	L	0	1	0	NULL	1	NULL	NULL
1434	2014-09-20 11:15:21.440	JDCCBPROD	JDCCB\administrator	3096	L	0	1	0	NULL	1	NULL	NULL
1435	2014-09-20 11:15:40.707	JDCCBPROD	JDCCB\administrator	3097	L	0	1	0	NULL	1	NULL	NULL
1436	2014-09-20 11:45:20.270	JDCCBPROD	JDCCB\administrator	3098	L	0	1	0	NULL	1	NULL	NULL
1437	2014-09-20 12:00:17.783	JDCCBPROD	JDCCB\administrator	3099	L	0	1	0	NULL	1	NULL	NULL
1438	2014-09-20 12:15:19.757	JDCCBPROD	JDCCB\administrator	3100	L	0	1	0	NULL	1	NULL	NULL
1439	2014-09-20 12:15:34.820	JDCCBPROD	JDCCB\administrator	3101	L	0	1	0	NULL	1	NULL	NULL
1440	2014-09-20 12:45:19.557	JDCCBPROD	JDCCB\administrator	3102	L	0	1	0	NULL	1	NULL	NULL
1441	2014-09-20 13:00:19.443	JDCCBPROD	JDCCB\administrator	3103	L	0	1	0	NULL	1	NULL	NULL
1442	2014-09-20 13:15:19.487	JDCCBPROD	JDCCB\administrator	3104	L	0	1	0	NULL	1	NULL	NULL
1443	2014-09-20 13:15:38.730	JDCCBPROD	JDCCB\administrator	3105	L	0	1	0	NULL	1	NULL	NULL
1444	2014-09-20 13:45:20.497	JDCCBPROD	JDCCB\administrator	3106	L	0	1	0	NULL	1	NULL	NULL
1445	2014-09-20 14:00:18.640	JDCCBPROD	JDCCB\administrator	3107	L	0	1	0	NULL	1	NULL	NULL
1446	2014-09-20 14:00:35.890	JDCCBPROD	JDCCB\administrator	3108	L	0	1	0	NULL	1	NULL	NULL
1447	2014-09-20 14:30:19.457	JDCCBPROD	JDCCB\administrator	3109	L	0	1	0	NULL	1	NULL	NULL
1448	2014-09-20 14:45:26.600	JDCCBPROD	JDCCB\administrator	3110	L	0	1	0	NULL	1	NULL	NULL
1449	2014-09-20 15:00:18.360	JDCCBPROD	JDCCB\administrator	3111	L	0	1	0	NULL	1	NULL	NULL
1450	2014-09-20 15:00:35.400	JDCCBPROD	JDCCB\administrator	3112	L	0	1	0	NULL	1	NULL	NULL
1451	2014-09-20 15:30:17.703	JDCCBPROD	JDCCB\administrator	3113	L	0	1	0	NULL	1	NULL	NULL
1452	2014-09-20 15:30:34.937	JDCCBPROD	JDCCB\administrator	3114	L	0	1	0	NULL	1	NULL	NULL
1453	2014-09-20 16:00:20.413	JDCCBPROD	JDCCB\administrator	3115	L	0	1	0	NULL	1	NULL	NULL
1454	2014-09-20 16:00:32.107	JDCCBPROD	JDCCB\administrator	3116	L	0	1	0	NULL	1	NULL	NULL
1455	2014-09-20 16:30:20.077	JDCCBPROD	JDCCB\administrator	3117	L	0	1	0	NULL	1	NULL	NULL
1456	2014-09-20 16:30:33.903	JDCCBPROD	JDCCB\administrator	3118	L	0	1	0	NULL	1	NULL	NULL
1457	2014-09-22 07:58:05.413	JDCCBPROD	JDCCB\sqladmin	3119	D	1	1	0	NULL	1	NULL	NULL
1458	2014-09-22 08:01:24.640	JDCCBPROD	JDCCB\administrator	3120	L	0	1	0	NULL	1	NULL	NULL
1459	2014-09-22 08:45:19.607	JDCCBPROD	JDCCB\administrator	3121	L	0	1	0	NULL	1	NULL	NULL
1461	2014-09-23 11:33:19.437	JDCCBPROD	JDCCB\sqladmin	3123	D	1	1	0	NULL	1	NULL	NULL
1462	2014-09-23 11:37:42.480	JDCCBPROD	JDCCB\administrator	3124	L	0	1	0	NULL	1	NULL	NULL
1463	2014-09-23 12:30:12.730	JDCCBPROD	JDCCB\administrator	3125	L	0	1	0	NULL	1	NULL	NULL
1464	2014-09-23 12:30:39.323	JDCCBPROD	JDCCB\administrator	3126	L	0	1	0	NULL	1	NULL	NULL
1465	2014-09-23 12:31:09.797	JDCCBPROD	JDCCB\administrator	3127	L	0	1	0	NULL	1	NULL	NULL
1466	2014-09-23 13:00:26.740	JDCCBPROD	JDCCB\administrator	3128	L	0	1	0	NULL	1	NULL	NULL
1467	2014-09-23 13:15:23.533	JDCCBPROD	JDCCB\administrator	3129	L	0	1	0	NULL	1	NULL	NULL
1468	2014-09-23 13:15:49.490	JDCCBPROD	JDCCB\administrator	3130	L	0	1	0	NULL	1	NULL	NULL
1469	2014-09-23 13:45:23.360	JDCCBPROD	JDCCB\administrator	3131	L	0	1	0	NULL	1	NULL	NULL
1470	2014-09-23 14:00:22.740	JDCCBPROD	JDCCB\administrator	3132	L	0	1	0	NULL	1	NULL	NULL
1471	2014-09-23 14:15:23.837	JDCCBPROD	JDCCB\administrator	3133	L	0	1	0	NULL	1	NULL	NULL
1472	2014-09-23 14:30:23.390	JDCCBPROD	JDCCB\administrator	3134	L	0	1	0	NULL	1	NULL	NULL
1473	2014-09-23 14:30:49.360	JDCCBPROD	JDCCB\administrator	3135	L	0	1	0	NULL	1	NULL	NULL
1474	2014-09-23 14:45:25.247	JDCCBPROD	JDCCB\administrator	3136	L	0	1	0	NULL	1	NULL	NULL
1475	2014-09-23 15:00:23.140	JDCCBPROD	JDCCB\administrator	3137	L	0	1	0	NULL	1	NULL	NULL
1476	2014-09-23 15:30:24.280	JDCCBPROD	JDCCB\administrator	3138	L	0	1	0	NULL	1	NULL	NULL
1477	2014-09-23 15:45:22.870	JDCCBPROD	JDCCB\administrator	3139	L	0	1	0	NULL	1	NULL	NULL
1478	2014-09-23 16:00:23.700	JDCCBPROD	JDCCB\administrator	3140	L	0	1	0	NULL	1	NULL	NULL
1479	2014-09-23 16:00:45.337	JDCCBPROD	JDCCB\administrator	3141	L	0	1	0	NULL	1	NULL	NULL
1480	2014-09-23 16:30:19.473	JDCCBPROD	JDCCB\administrator	3142	L	0	1	0	NULL	1	NULL	NULL
1481	2014-09-23 16:45:19.627	JDCCBPROD	JDCCB\administrator	3143	L	0	1	0	NULL	1	NULL	NULL
1482	2014-09-23 17:00:19.193	JDCCBPROD	JDCCB\administrator	3144	L	0	1	0	NULL	1	NULL	NULL
1483	2014-09-23 17:00:36.720	JDCCBPROD	JDCCB\administrator	3145	L	0	1	0	NULL	1	NULL	NULL
1484	2014-09-23 17:30:18.857	JDCCBPROD	JDCCB\administrator	3146	L	0	1	0	NULL	1	NULL	NULL
1485	2014-09-23 17:45:19.340	JDCCBPROD	JDCCB\administrator	3147	L	0	1	0	NULL	1	NULL	NULL
1486	2014-09-23 18:00:19.870	JDCCBPROD	JDCCB\administrator	3148	L	0	1	0	NULL	1	NULL	NULL
1487	2014-09-23 18:00:29.203	JDCCBPROD	JDCCB\administrator	3149	L	0	1	0	NULL	1	NULL	NULL
1488	2014-09-23 18:15:20.140	JDCCBPROD	JDCCB\administrator	3150	L	0	1	0	NULL	1	NULL	NULL
1489	2014-09-23 18:45:19.523	JDCCBPROD	JDCCB\administrator	3151	L	0	1	0	NULL	1	NULL	NULL
1490	2014-09-23 19:00:18.680	JDCCBPROD	JDCCB\administrator	3152	L	0	1	0	NULL	1	NULL	NULL
1491	2014-09-23 19:15:19.327	JDCCBPROD	JDCCB\administrator	3153	L	0	1	0	NULL	1	NULL	NULL
1492	2014-09-23 19:30:20.047	JDCCBPROD	JDCCB\administrator	3154	L	0	1	0	NULL	1	NULL	NULL
1493	2014-09-23 19:45:19.083	JDCCBPROD	JDCCB\administrator	3155	L	0	1	0	NULL	1	NULL	NULL
1494	2014-09-23 20:00:18.927	JDCCBPROD	JDCCB\administrator	3156	L	0	1	0	NULL	1	NULL	NULL
1495	2014-09-23 20:15:19.133	JDCCBPROD	JDCCB\administrator	3157	L	0	1	0	NULL	1	NULL	NULL
1496	2014-09-23 20:30:19.340	JDCCBPROD	JDCCB\administrator	3158	L	0	1	0	NULL	1	NULL	NULL
1497	2014-09-23 20:45:19.620	JDCCBPROD	JDCCB\administrator	3159	L	0	1	0	NULL	1	NULL	NULL
1498	2014-09-23 21:00:19.457	JDCCBPROD	JDCCB\administrator	3160	L	0	1	0	NULL	1	NULL	NULL
1499	2014-09-23 21:15:19.457	JDCCBPROD	JDCCB\administrator	3161	L	0	1	0	NULL	1	NULL	NULL
1500	2014-09-23 21:30:19.553	JDCCBPROD	JDCCB\administrator	3162	L	0	1	0	NULL	1	NULL	NULL
1501	2014-09-23 21:45:18.563	JDCCBPROD	JDCCB\administrator	3163	L	0	1	0	NULL	1	NULL	NULL
1502	2014-09-23 22:00:19.990	JDCCBPROD	JDCCB\administrator	3164	L	0	1	0	NULL	1	NULL	NULL
1503	2014-09-23 22:00:29.043	JDCCBPROD	JDCCB\administrator	3165	L	0	1	0	NULL	1	NULL	NULL
1504	2014-09-23 22:30:18.450	JDCCBPROD	JDCCB\administrator	3166	L	0	1	0	NULL	1	NULL	NULL
1505	2014-09-24 14:29:00.960	JDCCBPROD	JDCCB\sqladmin	3167	D	1	1	0	NULL	1	NULL	NULL
1506	2014-09-24 14:34:10.297	JDCCBPROD	JDCCB\administrator	3168	L	0	1	0	NULL	1	NULL	NULL
1507	2014-09-24 14:34:32.087	JDCCBPROD	JDCCB\administrator	3169	L	0	1	0	NULL	1	NULL	NULL
1508	2014-09-24 14:34:54.447	JDCCBPROD	JDCCB\administrator	3170	L	0	1	0	NULL	1	NULL	NULL
1509	2014-09-24 14:35:17.407	JDCCBPROD	JDCCB\administrator	3171	L	0	1	0	NULL	1	NULL	NULL
1510	2014-09-24 14:35:41.943	JDCCBPROD	JDCCB\administrator	3172	L	0	1	0	NULL	1	NULL	NULL
1511	2014-09-24 14:36:06.007	JDCCBPROD	JDCCB\administrator	3173	L	0	1	0	NULL	1	NULL	NULL
1512	2014-09-24 14:36:28.533	JDCCBPROD	JDCCB\administrator	3174	L	0	1	0	NULL	1	NULL	NULL
1513	2014-09-24 14:36:52.747	JDCCBPROD	JDCCB\administrator	3175	L	0	1	0	NULL	1	NULL	NULL
1514	2014-09-24 15:15:18.980	JDCCBPROD	JDCCB\administrator	3176	L	0	1	0	NULL	1	NULL	NULL
1515	2014-09-24 15:30:18.973	JDCCBPROD	JDCCB\administrator	3177	L	0	1	0	NULL	1	NULL	NULL
1516	2014-09-24 15:45:18.730	JDCCBPROD	JDCCB\administrator	3178	L	0	1	0	NULL	1	NULL	NULL
1517	2014-09-24 16:00:19.293	JDCCBPROD	JDCCB\administrator	3179	L	0	1	0	NULL	1	NULL	NULL
1518	2014-09-24 16:15:19.477	JDCCBPROD	JDCCB\administrator	3180	L	0	1	0	NULL	1	NULL	NULL
1519	2014-09-24 16:30:19.670	JDCCBPROD	JDCCB\administrator	3181	L	0	1	0	NULL	1	NULL	NULL
1520	2014-09-24 16:45:20.633	JDCCBPROD	JDCCB\administrator	3182	L	0	1	0	NULL	1	NULL	NULL
1521	2014-09-24 17:00:19.490	JDCCBPROD	JDCCB\administrator	3183	L	0	1	0	NULL	1	NULL	NULL
1522	2014-09-24 17:15:19.300	JDCCBPROD	JDCCB\administrator	3184	L	0	1	0	NULL	1	NULL	NULL
1523	2014-09-24 17:30:19.550	JDCCBPROD	JDCCB\administrator	3185	L	0	1	0	NULL	1	NULL	NULL
1524	2014-09-24 17:45:20.290	JDCCBPROD	JDCCB\administrator	3186	L	0	1	0	NULL	1	NULL	NULL
1525	2014-09-24 18:00:19.203	JDCCBPROD	JDCCB\administrator	3187	L	0	1	0	NULL	1	NULL	NULL
1526	2014-09-24 18:15:18.770	JDCCBPROD	JDCCB\administrator	3188	L	0	1	0	NULL	1	NULL	NULL
1527	2014-09-24 18:30:19.130	JDCCBPROD	JDCCB\administrator	3189	L	0	1	0	NULL	1	NULL	NULL
1528	2014-09-24 18:45:18.423	JDCCBPROD	JDCCB\administrator	3190	L	0	1	0	NULL	1	NULL	NULL
1529	2014-09-24 19:00:19.443	JDCCBPROD	JDCCB\administrator	3191	L	0	1	0	NULL	1	NULL	NULL
1530	2014-09-24 19:15:20.117	JDCCBPROD	JDCCB\administrator	3192	L	0	1	0	NULL	1	NULL	NULL
1531	2014-09-24 19:30:20.003	JDCCBPROD	JDCCB\administrator	3193	L	0	1	0	NULL	1	NULL	NULL
1532	2014-09-24 19:45:18.520	JDCCBPROD	JDCCB\administrator	3194	L	0	1	0	NULL	1	NULL	NULL
1533	2014-09-24 20:00:18.560	JDCCBPROD	JDCCB\administrator	3195	L	0	1	0	NULL	1	NULL	NULL
1534	2014-09-24 20:15:19.483	JDCCBPROD	JDCCB\administrator	3196	L	0	1	0	NULL	1	NULL	NULL
1535	2014-09-24 20:30:17.963	JDCCBPROD	JDCCB\administrator	3197	L	0	1	0	NULL	1	NULL	NULL
1536	2014-09-25 10:56:01.183	JDCCBPROD	JDCCB\sqladmin	3198	D	1	1	0	NULL	1	NULL	NULL
1537	2014-09-25 11:30:21.980	JDCCBPROD	JDCCB\administrator	3199	L	0	1	0	NULL	1	NULL	NULL
1538	2014-09-25 11:30:40.017	JDCCBPROD	JDCCB\administrator	3200	L	0	1	0	NULL	1	NULL	NULL
1539	2014-09-25 11:30:59.220	JDCCBPROD	JDCCB\administrator	3201	L	0	1	0	NULL	1	NULL	NULL
1540	2014-09-25 11:45:20.580	JDCCBPROD	JDCCB\administrator	3202	L	0	1	0	NULL	1	NULL	NULL
1541	2014-09-25 12:00:19.787	JDCCBPROD	JDCCB\administrator	3203	L	0	1	0	NULL	1	NULL	NULL
1542	2014-09-25 12:15:18.427	JDCCBPROD	JDCCB\administrator	3204	L	0	1	0	NULL	1	NULL	NULL
1543	2014-09-25 12:30:19.223	JDCCBPROD	JDCCB\administrator	3205	L	0	1	0	NULL	1	NULL	NULL
1544	2014-09-25 12:45:19.050	JDCCBPROD	JDCCB\administrator	3206	L	0	1	0	NULL	1	NULL	NULL
1545	2014-09-25 13:00:19.070	JDCCBPROD	JDCCB\administrator	3207	L	0	1	0	NULL	1	NULL	NULL
1546	2014-09-25 13:15:18.753	JDCCBPROD	JDCCB\administrator	3208	L	0	1	0	NULL	1	NULL	NULL
1547	2014-09-25 13:30:18.593	JDCCBPROD	JDCCB\administrator	3209	L	0	1	0	NULL	1	NULL	NULL
1548	2014-09-25 13:45:18.927	JDCCBPROD	JDCCB\administrator	3210	L	0	1	0	NULL	1	NULL	NULL
1549	2014-09-25 14:00:19.693	JDCCBPROD	JDCCB\administrator	3211	L	0	1	0	NULL	1	NULL	NULL
1550	2014-09-25 14:15:18.867	JDCCBPROD	JDCCB\administrator	3212	L	0	1	0	NULL	1	NULL	NULL
1551	2014-09-25 14:30:19.647	JDCCBPROD	JDCCB\administrator	3213	L	0	1	0	NULL	1	NULL	NULL
1552	2014-09-25 14:45:19.207	JDCCBPROD	JDCCB\administrator	3214	L	0	1	0	NULL	1	NULL	NULL
1553	2014-09-25 14:45:37.210	JDCCBPROD	JDCCB\administrator	3215	L	0	1	0	NULL	1	NULL	NULL
1554	2014-09-25 15:15:19.363	JDCCBPROD	JDCCB\administrator	3216	L	0	1	0	NULL	1	NULL	NULL
1555	2014-09-25 15:15:36.880	JDCCBPROD	JDCCB\administrator	3217	L	0	1	0	NULL	1	NULL	NULL
1556	2014-09-25 15:45:18.163	JDCCBPROD	JDCCB\administrator	3218	L	0	1	0	NULL	1	NULL	NULL
1557	2014-09-25 16:00:18.880	JDCCBPROD	JDCCB\administrator	3219	L	0	1	0	NULL	1	NULL	NULL
1558	2014-09-25 16:45:12.510	JDCCBPROD	JDCCB\administrator	3220	L	0	1	0	NULL	1	NULL	NULL
1559	2014-09-25 16:45:29.713	JDCCBPROD	JDCCB\administrator	3221	L	0	1	0	NULL	1	NULL	NULL
1560	2014-09-25 16:45:47.310	JDCCBPROD	JDCCB\administrator	3222	L	0	1	0	NULL	1	NULL	NULL
1561	2014-09-25 17:00:19.090	JDCCBPROD	JDCCB\administrator	3223	L	0	1	0	NULL	1	NULL	NULL
1562	2014-09-25 17:15:19.263	JDCCBPROD	JDCCB\administrator	3224	L	0	1	0	NULL	1	NULL	NULL
1563	2014-09-25 17:30:19.090	JDCCBPROD	JDCCB\administrator	3225	L	0	1	0	NULL	1	NULL	NULL
1564	2014-09-25 17:45:19.910	JDCCBPROD	JDCCB\administrator	3226	L	0	1	0	NULL	1	NULL	NULL
1565	2014-09-25 17:45:38.637	JDCCBPROD	JDCCB\administrator	3227	L	0	1	0	NULL	1	NULL	NULL
1566	2014-09-25 18:15:19.380	JDCCBPROD	JDCCB\administrator	3228	L	0	1	0	NULL	1	NULL	NULL
1567	2014-09-25 18:30:19.177	JDCCBPROD	JDCCB\administrator	3229	L	0	1	0	NULL	1	NULL	NULL
1568	2014-09-25 18:45:19.120	JDCCBPROD	JDCCB\administrator	3230	L	0	1	0	NULL	1	NULL	NULL
1569	2014-09-25 19:00:19.240	JDCCBPROD	JDCCB\administrator	3231	L	0	1	0	NULL	1	NULL	NULL
1570	2014-09-25 19:15:18.900	JDCCBPROD	JDCCB\administrator	3232	L	0	1	0	NULL	1	NULL	NULL
1571	2014-09-25 19:30:19.063	JDCCBPROD	JDCCB\administrator	3233	L	0	1	0	NULL	1	NULL	NULL
1572	2014-09-25 19:45:18.520	JDCCBPROD	JDCCB\administrator	3234	L	0	1	0	NULL	1	NULL	NULL
1573	2014-09-25 20:00:18.467	JDCCBPROD	JDCCB\administrator	3235	L	0	1	0	NULL	1	NULL	NULL
1574	2014-09-25 20:15:19.450	JDCCBPROD	JDCCB\administrator	3236	L	0	1	0	NULL	1	NULL	NULL
1575	2014-09-26 14:53:04.643	JDCCBPROD	JDCCB\sqladmin	3237	D	1	1	0	NULL	1	NULL	NULL
1576	2014-09-26 15:09:42.523	JDCCBPROD	JDCCB\administrator	3238	L	0	1	0	NULL	1	NULL	NULL
1577	2014-09-26 15:30:20.957	JDCCBPROD	JDCCB\administrator	3239	L	0	1	0	NULL	1	NULL	NULL
1578	2014-09-26 15:45:20.587	JDCCBPROD	JDCCB\administrator	3240	L	0	1	0	NULL	1	NULL	NULL
1579	2014-09-26 16:00:18.553	JDCCBPROD	JDCCB\administrator	3241	L	0	1	0	NULL	1	NULL	NULL
1580	2014-09-26 16:15:19.210	JDCCBPROD	JDCCB\administrator	3242	L	0	1	0	NULL	1	NULL	NULL
1581	2014-09-26 16:30:18.390	JDCCBPROD	JDCCB\administrator	3243	L	0	1	0	NULL	1	NULL	NULL
1582	2014-09-26 16:45:18.903	JDCCBPROD	JDCCB\administrator	3244	L	0	1	0	NULL	1	NULL	NULL
1583	2014-09-26 17:00:17.663	JDCCBPROD	JDCCB\administrator	3245	L	0	1	0	NULL	1	NULL	NULL
1584	2014-09-26 17:15:19.010	JDCCBPROD	JDCCB\administrator	3246	L	0	1	0	NULL	1	NULL	NULL
1585	2014-09-26 17:30:18.530	JDCCBPROD	JDCCB\administrator	3247	L	0	1	0	NULL	1	NULL	NULL
1586	2014-09-26 17:45:18.830	JDCCBPROD	JDCCB\administrator	3248	L	0	1	0	NULL	1	NULL	NULL
1587	2014-09-26 18:00:19.073	JDCCBPROD	JDCCB\administrator	3249	L	0	1	0	NULL	1	NULL	NULL
1588	2014-09-26 18:15:18.863	JDCCBPROD	JDCCB\administrator	3250	L	0	1	0	NULL	1	NULL	NULL
1589	2014-09-26 18:30:20.570	JDCCBPROD	JDCCB\administrator	3251	L	0	1	0	NULL	1	NULL	NULL
1590	2014-09-26 18:45:19.427	JDCCBPROD	JDCCB\administrator	3252	L	0	1	0	NULL	1	NULL	NULL
1591	2014-09-26 19:00:19.893	JDCCBPROD	JDCCB\administrator	3253	L	0	1	0	NULL	1	NULL	NULL
1592	2014-09-26 19:15:18.703	JDCCBPROD	JDCCB\administrator	3254	L	0	1	0	NULL	1	NULL	NULL
1593	2014-09-26 19:30:19.310	JDCCBPROD	JDCCB\administrator	3255	L	0	1	0	NULL	1	NULL	NULL
1594	2014-09-26 19:45:18.980	JDCCBPROD	JDCCB\administrator	3256	L	0	1	0	NULL	1	NULL	NULL
1595	2014-09-26 20:00:19.110	JDCCBPROD	JDCCB\administrator	3257	L	0	1	0	NULL	1	NULL	NULL
1596	2014-09-26 20:15:19.400	JDCCBPROD	JDCCB\administrator	3258	L	0	1	0	NULL	1	NULL	NULL
1597	2014-09-26 20:30:19.337	JDCCBPROD	JDCCB\administrator	3259	L	0	1	0	NULL	1	NULL	NULL
1598	2014-09-26 20:45:18.640	JDCCBPROD	JDCCB\administrator	3260	L	0	1	0	NULL	1	NULL	NULL
1599	2014-09-26 21:00:18.820	JDCCBPROD	JDCCB\administrator	3261	L	0	1	0	NULL	1	NULL	NULL
1600	2014-09-26 21:15:20.240	JDCCBPROD	JDCCB\administrator	3262	L	0	1	0	NULL	1	NULL	NULL
1601	2014-09-26 21:30:19.907	JDCCBPROD	JDCCB\administrator	3263	L	0	1	0	NULL	1	NULL	NULL
1602	2014-09-26 21:45:19.703	JDCCBPROD	JDCCB\administrator	3264	L	0	1	0	NULL	1	NULL	NULL
1603	2014-09-26 22:00:24.200	JDCCBPROD	JDCCB\administrator	3265	L	0	1	0	NULL	1	NULL	NULL
1604	2014-09-26 22:15:18.337	JDCCBPROD	JDCCB\administrator	3266	L	0	1	0	NULL	1	NULL	NULL
1605	2014-09-26 22:30:18.963	JDCCBPROD	JDCCB\administrator	3267	L	0	1	0	NULL	1	NULL	NULL
1606	2014-09-29 09:41:18.507	JDCCBPROD	JDCCB\sqladmin	3268	D	1	1	0	NULL	1	NULL	NULL
1607	2014-09-29 10:15:23.217	JDCCBPROD	JDCCB\administrator	3269	L	0	1	0	NULL	1	NULL	NULL
1608	2014-09-29 10:30:19.630	JDCCBPROD	JDCCB\administrator	3270	L	0	1	0	NULL	1	NULL	NULL
1609	2014-09-29 10:45:19.520	JDCCBPROD	JDCCB\administrator	3271	L	0	1	0	NULL	1	NULL	NULL
1610	2014-09-29 11:00:18.590	JDCCBPROD	JDCCB\administrator	3272	L	0	1	0	NULL	1	NULL	NULL
1611	2014-09-29 11:15:19.260	JDCCBPROD	JDCCB\administrator	3273	L	0	1	0	NULL	1	NULL	NULL
1612	2014-09-29 11:15:37.120	JDCCBPROD	JDCCB\administrator	3274	L	0	1	0	NULL	1	NULL	NULL
1613	2014-09-29 11:45:19.090	JDCCBPROD	JDCCB\administrator	3275	L	0	1	0	NULL	1	NULL	NULL
1614	2014-09-29 12:00:18.863	JDCCBPROD	JDCCB\administrator	3276	L	0	1	0	NULL	1	NULL	NULL
1615	2014-09-29 12:15:18.887	JDCCBPROD	JDCCB\administrator	3277	L	0	1	0	NULL	1	NULL	NULL
1616	2014-09-29 12:30:20.250	JDCCBPROD	JDCCB\administrator	3278	L	0	1	0	NULL	1	NULL	NULL
1617	2014-09-29 12:45:20.523	JDCCBPROD	JDCCB\administrator	3279	L	0	1	0	NULL	1	NULL	NULL
1618	2014-09-29 13:00:19.487	JDCCBPROD	JDCCB\administrator	3280	L	0	1	0	NULL	1	NULL	NULL
1619	2014-09-29 13:00:38.050	JDCCBPROD	JDCCB\administrator	3281	L	0	1	0	NULL	1	NULL	NULL
1620	2014-09-29 13:30:20.137	JDCCBPROD	JDCCB\administrator	3282	L	0	1	0	NULL	1	NULL	NULL
1621	2014-09-29 13:30:39.517	JDCCBPROD	JDCCB\administrator	3283	L	0	1	0	NULL	1	NULL	NULL
1622	2014-09-29 14:00:19.180	JDCCBPROD	JDCCB\administrator	3284	L	0	1	0	NULL	1	NULL	NULL
1623	2014-09-29 14:15:19.550	JDCCBPROD	JDCCB\administrator	3285	L	0	1	0	NULL	1	NULL	NULL
1624	2014-09-29 14:30:19.043	JDCCBPROD	JDCCB\administrator	3286	L	0	1	0	NULL	1	NULL	NULL
1625	2014-09-29 14:45:19.367	JDCCBPROD	JDCCB\administrator	3287	L	0	1	0	NULL	1	NULL	NULL
1626	2014-09-29 15:00:18.850	JDCCBPROD	JDCCB\administrator	3288	L	0	1	0	NULL	1	NULL	NULL
1627	2014-09-29 15:15:20.120	JDCCBPROD	JDCCB\administrator	3289	L	0	1	0	NULL	1	NULL	NULL
1628	2014-09-29 15:30:20.053	JDCCBPROD	JDCCB\administrator	3290	L	0	1	0	NULL	1	NULL	NULL
1629	2014-09-29 15:45:19.700	JDCCBPROD	JDCCB\administrator	3291	L	0	1	0	NULL	1	NULL	NULL
1630	2014-09-29 16:00:19.277	JDCCBPROD	JDCCB\administrator	3292	L	0	1	0	NULL	1	NULL	NULL
1631	2014-09-29 16:15:19.733	JDCCBPROD	JDCCB\administrator	3293	L	0	1	0	NULL	1	NULL	NULL
1632	2014-09-29 16:30:18.997	JDCCBPROD	JDCCB\administrator	3294	L	0	1	0	NULL	1	NULL	NULL
1633	2014-09-29 16:45:18.580	JDCCBPROD	JDCCB\administrator	3295	L	0	1	0	NULL	1	NULL	NULL
1634	2014-09-29 17:00:20.260	JDCCBPROD	JDCCB\administrator	3296	L	0	1	0	NULL	1	NULL	NULL
1635	2014-09-29 17:00:34.890	JDCCBPROD	JDCCB\administrator	3297	L	0	1	0	NULL	1	NULL	NULL
1636	2014-09-29 17:30:17.817	JDCCBPROD	JDCCB\administrator	3298	L	0	1	0	NULL	1	NULL	NULL
1637	2014-09-29 17:45:19.550	JDCCBPROD	JDCCB\administrator	3299	L	0	1	0	NULL	1	NULL	NULL
1638	2014-09-29 18:00:17.933	JDCCBPROD	JDCCB\administrator	3300	L	0	1	0	NULL	1	NULL	NULL
1639	2014-09-29 18:15:18.800	JDCCBPROD	JDCCB\administrator	3301	L	0	1	0	NULL	1	NULL	NULL
1640	2014-09-29 18:30:18.310	JDCCBPROD	JDCCB\administrator	3302	L	0	1	0	NULL	1	NULL	NULL
1641	2014-09-29 18:45:19.537	JDCCBPROD	JDCCB\administrator	3303	L	0	1	0	NULL	1	NULL	NULL
1642	2014-09-29 19:00:20.100	JDCCBPROD	JDCCB\administrator	3304	L	0	1	0	NULL	1	NULL	NULL
1643	2014-09-29 19:15:21.113	JDCCBPROD	JDCCB\administrator	3305	L	0	1	0	NULL	1	NULL	NULL
1644	2014-09-29 19:30:19.170	JDCCBPROD	JDCCB\administrator	3306	L	0	1	0	NULL	1	NULL	NULL
1645	2014-09-29 19:45:18.390	JDCCBPROD	JDCCB\administrator	3307	L	0	1	0	NULL	1	NULL	NULL
1646	2014-09-29 20:00:19.583	JDCCBPROD	JDCCB\administrator	3308	L	0	1	0	NULL	1	NULL	NULL
1647	2014-09-29 20:15:18.277	JDCCBPROD	JDCCB\administrator	3309	L	0	1	0	NULL	1	NULL	NULL
1648	2014-09-29 20:15:30.273	JDCCBPROD	JDCCB\administrator	3310	L	0	1	0	NULL	1	NULL	NULL
1649	2014-09-30 09:49:13.730	JDCCBPROD	JDCCB\sqladmin	3311	D	1	1	0	NULL	1	NULL	NULL
1650	2014-09-30 10:30:15.050	JDCCBPROD	JDCCB\administrator	3312	L	0	1	0	NULL	1	NULL	NULL
1651	2014-09-30 10:45:19.663	JDCCBPROD	JDCCB\administrator	3313	L	0	1	0	NULL	1	NULL	NULL
1652	2014-09-30 11:00:19.650	JDCCBPROD	JDCCB\administrator	3314	L	0	1	0	NULL	1	NULL	NULL
1653	2014-09-30 11:15:19.723	JDCCBPROD	JDCCB\administrator	3315	L	0	1	0	NULL	1	NULL	NULL
1654	2014-09-30 11:30:20.023	JDCCBPROD	JDCCB\administrator	3316	L	0	1	0	NULL	1	NULL	NULL
1655	2014-09-30 11:45:18.573	JDCCBPROD	JDCCB\administrator	3317	L	0	1	0	NULL	1	NULL	NULL
1656	2014-09-30 12:00:19.273	JDCCBPROD	JDCCB\administrator	3318	L	0	1	0	NULL	1	NULL	NULL
1657	2014-09-30 12:15:20.070	JDCCBPROD	JDCCB\administrator	3319	L	0	1	0	NULL	1	NULL	NULL
1658	2014-09-30 12:15:55.000	JDCCBPROD	JDCCB\administrator	3320	L	0	1	0	NULL	1	NULL	NULL
1659	2014-09-30 12:30:20.947	JDCCBPROD	JDCCB\administrator	3321	L	0	1	0	NULL	1	NULL	NULL
1660	2014-09-30 13:00:19.867	JDCCBPROD	JDCCB\administrator	3322	L	0	1	0	NULL	1	NULL	NULL
1661	2014-09-30 13:15:17.823	JDCCBPROD	JDCCB\administrator	3323	L	0	1	0	NULL	1	NULL	NULL
1662	2014-09-30 13:30:19.943	JDCCBPROD	JDCCB\administrator	3324	L	0	1	0	NULL	1	NULL	NULL
1663	2014-09-30 13:45:20.157	JDCCBPROD	JDCCB\administrator	3325	L	0	1	0	NULL	1	NULL	NULL
1664	2014-09-30 14:00:19.597	JDCCBPROD	JDCCB\administrator	3326	L	0	1	0	NULL	1	NULL	NULL
1665	2014-09-30 14:15:19.890	JDCCBPROD	JDCCB\administrator	3327	L	0	1	0	NULL	1	NULL	NULL
1666	2014-09-30 14:30:19.530	JDCCBPROD	JDCCB\administrator	3328	L	0	1	0	NULL	1	NULL	NULL
1667	2014-09-30 14:45:19.287	JDCCBPROD	JDCCB\administrator	3329	L	0	1	0	NULL	1	NULL	NULL
1668	2014-09-30 15:00:20.017	JDCCBPROD	JDCCB\administrator	3330	L	0	1	0	NULL	1	NULL	NULL
1669	2014-09-30 15:15:21.013	JDCCBPROD	JDCCB\administrator	3331	L	0	1	0	NULL	1	NULL	NULL
1670	2014-09-30 15:30:12.753	JDCCBPROD	JDCCB\administrator	3332	L	0	1	0	NULL	1	NULL	NULL
1671	2014-09-30 15:30:41.710	JDCCBPROD	JDCCB\administrator	3333	L	0	1	0	NULL	1	NULL	NULL
1672	2014-09-30 16:00:19.520	JDCCBPROD	JDCCB\administrator	3334	L	0	1	0	NULL	1	NULL	NULL
1673	2014-09-30 16:15:20.647	JDCCBPROD	JDCCB\administrator	3335	L	0	1	0	NULL	1	NULL	NULL
1674	2014-09-30 16:30:19.577	JDCCBPROD	JDCCB\administrator	3336	L	0	1	0	NULL	1	NULL	NULL
1675	2014-09-30 16:45:18.923	JDCCBPROD	JDCCB\administrator	3337	L	0	1	0	NULL	1	NULL	NULL
1676	2014-09-30 17:00:19.943	JDCCBPROD	JDCCB\administrator	3338	L	0	1	0	NULL	1	NULL	NULL
1677	2014-09-30 17:15:19.280	JDCCBPROD	JDCCB\administrator	3339	L	0	1	0	NULL	1	NULL	NULL
1678	2014-09-30 17:15:32.143	JDCCBPROD	JDCCB\administrator	3340	L	0	1	0	NULL	1	NULL	NULL
1679	2014-09-30 17:45:19.413	JDCCBPROD	JDCCB\administrator	3341	L	0	1	0	NULL	1	NULL	NULL
1680	2014-09-30 18:00:18.820	JDCCBPROD	JDCCB\administrator	3342	L	0	1	0	NULL	1	NULL	NULL
1681	2014-09-30 18:15:18.637	JDCCBPROD	JDCCB\administrator	3343	L	0	1	0	NULL	1	NULL	NULL
1682	2014-09-30 18:30:19.320	JDCCBPROD	JDCCB\administrator	3344	L	0	1	0	NULL	1	NULL	NULL
1683	2014-09-30 18:45:19.443	JDCCBPROD	JDCCB\administrator	3345	L	0	1	0	NULL	1	NULL	NULL
1684	2014-09-30 19:00:19.657	JDCCBPROD	JDCCB\administrator	3346	L	0	1	0	NULL	1	NULL	NULL
1685	2014-09-30 19:15:18.533	JDCCBPROD	JDCCB\administrator	3347	L	0	1	0	NULL	1	NULL	NULL
1686	2014-09-30 19:30:19.047	JDCCBPROD	JDCCB\administrator	3348	L	0	1	0	NULL	1	NULL	NULL
1687	2014-09-30 19:45:19.400	JDCCBPROD	JDCCB\administrator	3349	L	0	1	0	NULL	1	NULL	NULL
1688	2014-09-30 20:00:19.033	JDCCBPROD	JDCCB\administrator	3350	L	0	1	0	NULL	1	NULL	NULL
1689	2014-09-30 20:15:20.817	JDCCBPROD	JDCCB\administrator	3351	L	0	1	0	NULL	1	NULL	NULL
1690	2014-09-30 20:30:19.740	JDCCBPROD	JDCCB\administrator	3352	L	0	1	0	NULL	1	NULL	NULL
1691	2014-09-30 20:45:20.250	JDCCBPROD	JDCCB\administrator	3353	L	0	1	0	NULL	1	NULL	NULL
1692	2014-09-30 20:45:31.257	JDCCBPROD	JDCCB\administrator	3354	L	0	1	0	NULL	1	NULL	NULL
1693	2014-09-30 21:15:20.337	JDCCBPROD	JDCCB\administrator	3355	L	0	1	0	NULL	1	NULL	NULL
1694	2014-09-30 21:30:19.370	JDCCBPROD	JDCCB\administrator	3356	L	0	1	0	NULL	1	NULL	NULL
1695	2014-09-30 21:45:19.360	JDCCBPROD	JDCCB\administrator	3357	L	0	1	0	NULL	1	NULL	NULL
1696	2014-09-30 22:00:19.057	JDCCBPROD	JDCCB\administrator	3358	L	0	1	0	NULL	1	NULL	NULL
1697	2014-09-30 22:15:19.730	JDCCBPROD	JDCCB\administrator	3359	L	0	1	0	NULL	1	NULL	NULL
1698	2014-09-30 22:30:18.810	JDCCBPROD	JDCCB\administrator	3360	L	0	1	0	NULL	1	NULL	NULL
1699	2014-09-30 22:45:18.697	JDCCBPROD	JDCCB\administrator	3361	L	0	1	0	NULL	1	NULL	NULL
1700	2014-09-30 23:00:18.383	JDCCBPROD	JDCCB\administrator	3362	L	0	1	0	NULL	1	NULL	NULL
1701	2014-10-01 10:00:14.827	JDCCBPROD	JDCCB\sqladmin	3363	D	1	1	0	NULL	1	NULL	NULL
1702	2014-10-01 10:30:15.013	JDCCBPROD	JDCCB\administrator	3364	L	0	1	0	NULL	1	NULL	NULL
1703	2014-10-01 10:45:17.867	JDCCBPROD	JDCCB\administrator	3365	L	0	1	0	NULL	1	NULL	NULL
1704	2014-10-01 10:45:31.477	JDCCBPROD	JDCCB\administrator	3366	L	0	1	0	NULL	1	NULL	NULL
1705	2014-10-01 11:15:18.997	JDCCBPROD	JDCCB\administrator	3367	L	0	1	0	NULL	1	NULL	NULL
1706	2014-10-01 11:30:19.323	JDCCBPROD	JDCCB\administrator	3368	L	0	1	0	NULL	1	NULL	NULL
1707	2014-10-01 11:45:18.850	JDCCBPROD	JDCCB\administrator	3369	L	0	1	0	NULL	1	NULL	NULL
1708	2014-10-01 12:00:19.807	JDCCBPROD	JDCCB\administrator	3370	L	0	1	0	NULL	1	NULL	NULL
1709	2014-10-01 12:15:19.423	JDCCBPROD	JDCCB\administrator	3371	L	0	1	0	NULL	1	NULL	NULL
1710	2014-10-01 12:30:19.247	JDCCBPROD	JDCCB\administrator	3372	L	0	1	0	NULL	1	NULL	NULL
1711	2014-10-01 12:45:18.800	JDCCBPROD	JDCCB\administrator	3373	L	0	1	0	NULL	1	NULL	NULL
1712	2014-10-01 13:00:18.323	JDCCBPROD	JDCCB\administrator	3374	L	0	1	0	NULL	1	NULL	NULL
1713	2014-10-01 13:15:18.097	JDCCBPROD	JDCCB\administrator	3375	L	0	1	0	NULL	1	NULL	NULL
1714	2014-10-01 13:15:34.600	JDCCBPROD	JDCCB\administrator	3376	L	0	1	0	NULL	1	NULL	NULL
1715	2014-10-01 13:45:17.837	JDCCBPROD	JDCCB\administrator	3377	L	0	1	0	NULL	1	NULL	NULL
1716	2014-10-01 14:00:18.757	JDCCBPROD	JDCCB\administrator	3378	L	0	1	0	NULL	1	NULL	NULL
1717	2014-10-01 14:00:36.680	JDCCBPROD	JDCCB\administrator	3379	L	0	1	0	NULL	1	NULL	NULL
1718	2014-10-01 14:30:17.877	JDCCBPROD	JDCCB\administrator	3380	L	0	1	0	NULL	1	NULL	NULL
1719	2014-10-01 14:45:19.020	JDCCBPROD	JDCCB\administrator	3381	L	0	1	0	NULL	1	NULL	NULL
1720	2014-10-01 15:00:19.893	JDCCBPROD	JDCCB\administrator	3382	L	0	1	0	NULL	1	NULL	NULL
1721	2014-10-01 15:15:20.263	JDCCBPROD	JDCCB\administrator	3383	L	0	1	0	NULL	1	NULL	NULL
1722	2014-10-01 15:30:19.360	JDCCBPROD	JDCCB\administrator	3384	L	0	1	0	NULL	1	NULL	NULL
1723	2014-10-01 15:45:18.720	JDCCBPROD	JDCCB\administrator	3385	L	0	1	0	NULL	1	NULL	NULL
1724	2014-10-01 16:00:19.290	JDCCBPROD	JDCCB\administrator	3386	L	0	1	0	NULL	1	NULL	NULL
1725	2014-10-01 16:00:36.527	JDCCBPROD	JDCCB\administrator	3387	L	0	1	0	NULL	1	NULL	NULL
1726	2014-10-01 16:30:18.243	JDCCBPROD	JDCCB\administrator	3388	L	0	1	0	NULL	1	NULL	NULL
1727	2014-10-01 16:45:18.163	JDCCBPROD	JDCCB\administrator	3389	L	0	1	0	NULL	1	NULL	NULL
1728	2014-10-01 17:00:19.193	JDCCBPROD	JDCCB\administrator	3390	L	0	1	0	NULL	1	NULL	NULL
1729	2014-10-01 17:15:19.107	JDCCBPROD	JDCCB\administrator	3391	L	0	1	0	NULL	1	NULL	NULL
1730	2014-10-01 17:30:18.713	JDCCBPROD	JDCCB\administrator	3392	L	0	1	0	NULL	1	NULL	NULL
1731	2014-10-01 17:45:19.007	JDCCBPROD	JDCCB\administrator	3393	L	0	1	0	NULL	1	NULL	NULL
1732	2014-10-01 18:00:20.293	JDCCBPROD	JDCCB\administrator	3394	L	0	1	0	NULL	1	NULL	NULL
1733	2014-10-01 18:15:20.210	JDCCBPROD	JDCCB\administrator	3395	L	0	1	0	NULL	1	NULL	NULL
1734	2014-10-01 18:15:34.863	JDCCBPROD	JDCCB\administrator	3396	L	0	1	0	NULL	1	NULL	NULL
1735	2014-10-01 18:45:19.360	JDCCBPROD	JDCCB\administrator	3397	L	0	1	0	NULL	1	NULL	NULL
1736	2014-10-01 19:00:18.040	JDCCBPROD	JDCCB\administrator	3398	L	0	1	0	NULL	1	NULL	NULL
1737	2014-10-01 19:15:18.487	JDCCBPROD	JDCCB\administrator	3399	L	0	1	0	NULL	1	NULL	NULL
1738	2014-10-01 19:30:19.253	JDCCBPROD	JDCCB\administrator	3400	L	0	1	0	NULL	1	NULL	NULL
1739	2014-10-01 19:30:29.720	JDCCBPROD	JDCCB\administrator	3401	L	0	1	0	NULL	1	NULL	NULL
1740	2014-10-06 11:18:21.880	JDCCBPROD	JDCCB\sqladmin	3402	D	1	1	0	NULL	1	NULL	NULL
1741	2014-10-06 11:25:47.013	JDCCBPROD	JDCCB\administrator	3403	L	0	1	0	NULL	1	NULL	NULL
1742	2014-10-06 11:25:57.237	JDCCBPROD	JDCCB\administrator	3404	L	0	1	0	NULL	1	NULL	NULL
1743	2014-10-06 12:22:14.720	JDCCBPROD	JDCCB\sqladmin	3405	D	1	1	0	NULL	1	NULL	NULL
1744	2014-10-06 12:25:39.740	JDCCBPROD	JDCCB\administrator	3406	L	0	1	0	NULL	1	NULL	NULL
1745	2014-10-06 12:30:19.777	JDCCBPROD	JDCCB\administrator	3407	L	0	1	0	NULL	1	NULL	NULL
1746	2014-10-06 13:00:18.450	JDCCBPROD	JDCCB\administrator	3408	L	0	1	0	NULL	1	NULL	NULL
1747	2014-10-06 13:15:19.723	JDCCBPROD	JDCCB\administrator	3409	L	0	1	0	NULL	1	NULL	NULL
1748	2014-10-06 13:15:29.357	JDCCBPROD	JDCCB\administrator	3410	L	0	1	0	NULL	1	NULL	NULL
1749	2014-10-06 13:45:18.630	JDCCBPROD	JDCCB\administrator	3411	L	0	1	0	NULL	1	NULL	NULL
1750	2014-10-06 14:00:18.700	JDCCBPROD	JDCCB\administrator	3412	L	0	1	0	NULL	1	NULL	NULL
1751	2014-10-06 14:15:20.143	JDCCBPROD	JDCCB\administrator	3413	L	0	1	0	NULL	1	NULL	NULL
1752	2014-10-06 14:30:20.600	JDCCBPROD	JDCCB\administrator	3414	L	0	1	0	NULL	1	NULL	NULL
1753	2014-10-06 14:30:30.400	JDCCBPROD	JDCCB\administrator	3415	L	0	1	0	NULL	1	NULL	NULL
1754	2014-10-06 15:00:19.700	JDCCBPROD	JDCCB\administrator	3416	L	0	1	0	NULL	1	NULL	NULL
1755	2014-10-06 15:15:19.660	JDCCBPROD	JDCCB\administrator	3417	L	0	1	0	NULL	1	NULL	NULL
1756	2014-10-06 15:30:19.337	JDCCBPROD	JDCCB\administrator	3418	L	0	1	0	NULL	1	NULL	NULL
1757	2014-10-06 15:45:18.403	JDCCBPROD	JDCCB\administrator	3419	L	0	1	0	NULL	1	NULL	NULL
1758	2014-10-06 16:00:19.450	JDCCBPROD	JDCCB\administrator	3420	L	0	1	0	NULL	1	NULL	NULL
1759	2014-10-06 16:00:30.590	JDCCBPROD	JDCCB\administrator	3421	L	0	1	0	NULL	1	NULL	NULL
1760	2014-10-06 16:30:19.097	JDCCBPROD	JDCCB\administrator	3422	L	0	1	0	NULL	1	NULL	NULL
1761	2014-10-06 16:45:18.970	JDCCBPROD	JDCCB\administrator	3423	L	0	1	0	NULL	1	NULL	NULL
1762	2014-10-06 17:00:17.943	JDCCBPROD	JDCCB\administrator	3424	L	0	1	0	NULL	1	NULL	NULL
1763	2014-10-06 17:15:19.027	JDCCBPROD	JDCCB\administrator	3425	L	0	1	0	NULL	1	NULL	NULL
1764	2014-10-06 17:30:19.657	JDCCBPROD	JDCCB\administrator	3426	L	0	1	0	NULL	1	NULL	NULL
1765	2014-10-06 17:45:19.933	JDCCBPROD	JDCCB\administrator	3427	L	0	1	0	NULL	1	NULL	NULL
1766	2014-10-07 12:37:40.907	JDCCBPROD	JDCCB\sqladmin	3428	D	1	1	0	NULL	1	NULL	NULL
1767	2014-10-07 12:45:22.353	JDCCBPROD	JDCCB\administrator	3429	L	0	1	0	NULL	1	NULL	NULL
1768	2014-10-07 12:45:43.117	JDCCBPROD	JDCCB\administrator	3430	L	0	1	0	NULL	1	NULL	NULL
1769	2014-10-07 13:00:20.147	JDCCBPROD	JDCCB\administrator	3431	L	0	1	0	NULL	1	NULL	NULL
1770	2014-10-07 13:15:19.820	JDCCBPROD	JDCCB\administrator	3432	L	0	1	0	NULL	1	NULL	NULL
1771	2014-10-07 13:30:19.487	JDCCBPROD	JDCCB\administrator	3433	L	0	1	0	NULL	1	NULL	NULL
1772	2014-10-07 13:45:20.540	JDCCBPROD	JDCCB\administrator	3434	L	0	1	0	NULL	1	NULL	NULL
1773	2014-10-07 14:00:20.637	JDCCBPROD	JDCCB\administrator	3435	L	0	1	0	NULL	1	NULL	NULL
1774	2014-10-07 14:15:19.080	JDCCBPROD	JDCCB\administrator	3436	L	0	1	0	NULL	1	NULL	NULL
1775	2014-10-07 14:30:19.467	JDCCBPROD	JDCCB\administrator	3437	L	0	1	0	NULL	1	NULL	NULL
1776	2014-10-07 14:45:19.303	JDCCBPROD	JDCCB\administrator	3438	L	0	1	0	NULL	1	NULL	NULL
1777	2014-10-07 15:00:18.980	JDCCBPROD	JDCCB\administrator	3439	L	0	1	0	NULL	1	NULL	NULL
1778	2014-10-07 15:15:18.793	JDCCBPROD	JDCCB\administrator	3440	L	0	1	0	NULL	1	NULL	NULL
1779	2014-10-07 15:30:18.783	JDCCBPROD	JDCCB\administrator	3441	L	0	1	0	NULL	1	NULL	NULL
1780	2014-10-07 15:45:19.420	JDCCBPROD	JDCCB\administrator	3442	L	0	1	0	NULL	1	NULL	NULL
1781	2014-10-07 16:00:19.850	JDCCBPROD	JDCCB\administrator	3443	L	0	1	0	NULL	1	NULL	NULL
1782	2014-10-07 16:15:19.793	JDCCBPROD	JDCCB\administrator	3444	L	0	1	0	NULL	1	NULL	NULL
1783	2014-10-07 16:30:19.543	JDCCBPROD	JDCCB\administrator	3445	L	0	1	0	NULL	1	NULL	NULL
1784	2014-10-07 16:45:18.593	JDCCBPROD	JDCCB\administrator	3446	L	0	1	0	NULL	1	NULL	NULL
1785	2014-10-07 17:00:18.660	JDCCBPROD	JDCCB\administrator	3447	L	0	1	0	NULL	1	NULL	NULL
1786	2014-10-07 17:15:19.303	JDCCBPROD	JDCCB\administrator	3448	L	0	1	0	NULL	1	NULL	NULL
1787	2014-10-07 17:30:19.887	JDCCBPROD	JDCCB\administrator	3449	L	0	1	0	NULL	1	NULL	NULL
1788	2014-10-07 17:45:19.133	JDCCBPROD	JDCCB\administrator	3450	L	0	1	0	NULL	1	NULL	NULL
1789	2014-10-07 18:00:18.877	JDCCBPROD	JDCCB\administrator	3451	L	0	1	0	NULL	1	NULL	NULL
1790	2014-10-07 18:15:17.847	JDCCBPROD	JDCCB\administrator	3452	L	0	1	0	NULL	1	NULL	NULL
1791	2014-10-07 18:30:19.080	JDCCBPROD	JDCCB\administrator	3453	L	0	1	0	NULL	1	NULL	NULL
1792	2014-10-07 18:45:19.080	JDCCBPROD	JDCCB\administrator	3454	L	0	1	0	NULL	1	NULL	NULL
1793	2014-10-07 19:00:19.000	JDCCBPROD	JDCCB\administrator	3455	L	0	1	0	NULL	1	NULL	NULL
1794	2014-10-07 19:15:19.843	JDCCBPROD	JDCCB\administrator	3456	L	0	1	0	NULL	1	NULL	NULL
1795	2014-10-07 19:30:21.290	JDCCBPROD	JDCCB\administrator	3457	L	0	1	0	NULL	1	NULL	NULL
1796	2014-10-07 19:45:19.360	JDCCBPROD	JDCCB\administrator	3458	L	0	1	0	NULL	1	NULL	NULL
1797	2014-10-07 20:00:19.447	JDCCBPROD	JDCCB\administrator	3459	L	0	1	0	NULL	1	NULL	NULL
1798	2014-10-07 20:15:18.183	JDCCBPROD	JDCCB\administrator	3460	L	0	1	0	NULL	1	NULL	NULL
1799	2014-10-07 20:30:18.433	JDCCBPROD	JDCCB\administrator	3461	L	0	1	0	NULL	1	NULL	NULL
1800	2014-10-07 20:45:19.147	JDCCBPROD	JDCCB\administrator	3462	L	0	1	0	NULL	1	NULL	NULL
1801	2014-10-07 21:00:19.300	JDCCBPROD	JDCCB\administrator	3463	L	0	1	0	NULL	1	NULL	NULL
1802	2014-10-07 21:15:17.803	JDCCBPROD	JDCCB\administrator	3464	L	0	1	0	NULL	1	NULL	NULL

Free Windows Admin Tool Kit Click here and download it now
October 8th, 2014 9:57am

HI Satish ,

 Thank you for prompt reply , please let us know below setting is  on DR/ N DR  restore backup settings,  is  below one selected or not while restoring .trn backup on DR/N DR server. If not please select this option and monitor next 24 hrs  an dlet us know status.  I am unable to copy paste the picture .Follow the below steps.

 Tab [Restore transaction log]

 --> option ( StandBy mode )

----> select  Disconnect  users in the database when restoring backups .

*** If already tested this option please ignore it .




October 8th, 2014 11:15am

Hello Kiran,

Even I tried with this setting also but I am facing the same issue.

I hope if sum one can see the server remotely they can understand issue.

Even I reconfigured several times but the problem is not resolved.

Free Windows Admin Tool Kit Click here and download it now
October 8th, 2014 11:33am

 Hi Satish ,

Thank you for update , are you finding any .tuf  file before the last .trn file, because why I am asking this question , as per above you mentioned  last .trn file was not  restoring by manully/through query.

And let know any log shipping job failure message details



October 8th, 2014 12:49pm

Hi Satish,

Thanks for sharing logs. Important point

1. Your SQL server 2012 is not patched to SP2. Please patch it to SP2 Immediately.

2. Whole SQL Server errorlog is filled with Below mssage.

2014-10-08 06:45:15.720 spid61 Error: 9004, Severity: 16, State: 6. 2014-10-08 06:45:15.720 spid61 An error occurred while processing the log for database 'JDCCBPROD'.

If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log. 2014-10-08 06:45:15.720 spid61 Error: 3414, Severity: 21, State: 1. 2014-10-08 06:45:15.720 spid61 An error occurred during recovery, preventing the database 'JDCCBPROD'

(7:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

As per errorlog message LS Restore job  is not able to restore transaction log files because it finds the files corrupt. Error 9004 in SQL Server means corrupt Log file.

Now as you said you tried creating Logshipping many time and this error occurs every time . This leads me to believe that this is bug in SQL Server. And Yes it is please read below support article

https://support2.microsoft.com/kb/2685132?wa=wsignin1.0

Bug is fixed in CU 2 for SQL server 2012. But since SQL Server 2012 SP2 has come up and is stable please apply SP2. After applying SP2 on both PR and DR recreate logshipping hopefully this error will be gone

Free Windows Admin Tool Kit Click here and download it now
October 8th, 2014 10:38pm

Hello Shanky,

Sorry for the delay reply.

After updating the sp2 also I am facing the same issue.

Please find the below error when I verified the trn file with below query.

verifyonly from disk = '\\jdccb-mis\LOGSHIPPING\JDCCBPROD_20141015124512.trn'

Attempting to restore this backup may encounter storage space problems. Subsequent messages will provide details.
The path specified by "E:\JDCCBDATA\JDCCBPROD.mdf" is not in a valid directory.
Directory lookup for the file "E:\JDCCBDATA\MASTER_DATA.ndf" failed with the operating system error 2(The system cannot find the file specified.).
Directory lookup for the file "E:\JDCCBDATA\MASTER_INDEX.ndf" failed with the operating system error 2(The system cannot find the file specified.).
Directory lookup for the file "E:\JDCCBDATA\TRANS_DATA.ndf" failed with the operating system error 2(The system cannot find the file specified.).
Directory lookup for the file "E:\JDCCBDATA\TRANS_INDEX.ndf" failed with the operating system error 2(The system cannot find the file specified.).
Directory lookup for the file "E:\JDCCBDATA\JDCCBPROD_log.ldf" failed with the operating system error 2(The system cannot find the file specified.).
The backup set on file 1 is valid.

October 15th, 2014 2:42pm

You are giving verifyonly for '\\jdccb-mis\LOGSHIPPING\JDCCBPROD_20141015124512.trn, shared trn files you would have to give it like actually you are restoring it. You would have to give location for mdf files where it would be created then it would take it.

It tries to imitate the restore scenario. As per message it seems like backup set is valid in that case I would recommend you to log a case with Microsoft why actually its failing to restore log files it should not if backup set is valid

Free Windows Admin Tool Kit Click here and download it now
October 15th, 2014 6:22pm

Hello Shanky,

Any update on this issue....

Regards,

Satish

November 5th, 2014 6:12am

Hello Shanky,

Any update on this issue....


I was waiting update from your side. You did not ran Verifyonly correctly did you ? Is the issue still there.
Free Windows Admin Tool Kit Click here and download it now
November 5th, 2014 9:42am

Dear Shanky,

I can see in the forum there are many users logging the same issue.

As per your lost reply you recommend to log a case with Microsoft.

But I did not done that still I am facing the same issue...

Kindly let me know if you have any update on this iss

November 5th, 2014 9:50am

Dear Shanky,

I can see in the forum there are many users logging the same issue.

As per your lost reply you recommend to log a case with Microsoft.

But I did not done that till I am facing the same issue...

Kindly let me know if you have any update on this issue....


Satish problem is I can not see your system from here and can just point to some basic steps its very difficult to find out where problem lies. Yes you are correct many users are facing issue and I somehow feel that this is bug in SQL Server so either you open a case with MS or create a Connect item. I would try promoting your connect item personally. You can create connect item using below link

https://connect.microsoft.com/SQLServer/Feedback

Raising connect item is easy but solution does takes time because there are thousands of connect items raised and it would take time for MS person to come to your feedback. If you are looking for immediate solution raising case with MS is best idea. This all is being said that because you are sure your disk and memory board is fine and is free of corruption

Free Windows Admin Tool Kit Click here and download it now
November 5th, 2014 9:59am

Thanks for informing MS though connect, I have voted up for t
November 5th, 2014 2:06pm

Hello Shanky,

Can you help me there is no proper response from Shilpi Gautam Microsoft Connect.

Free Windows Admin Tool Kit Click here and download it now
January 6th, 2015 6:30am

Hello Shanky,

Can you help me there is no proper response from Shilpi Gautam Microsoft Connect.

I already said from this far I cannot access your system so it would be not possible for me to help you. Yes MS takes a lot of time to respond on connect item this is how it goes. I suggest you to raise case with MS it seems like bug , you might get refund if this is still a bug.

Solving this error would require complete errorlog ,windows event logs and some more information.

January 6th, 2015 9:53am

HI satish,

1)Please check 

 restore verifyonly from disk== c:\msql.bak

Restore filelistonly from disk =c:\msqlc.bak

restore headeronly from disk=c:\msqlc.bak

2)Check backup kept directory same account right

3) try place backup on different location

4) share event log and sql logs.

Free Windows Admin Tool Kit Click here and download it now
April 5th, 2015 1:07am

Dinesh,

Can you stop this behavior of posting on old threads. As per forum practice you should not post on Old threads. Forum owners will see this activity and will ban you eventually because most of your post is being reported abusive. I am telling this for your own benefit.

You are free to post your answers on new threads and recent threads

April 5th, 2015 1:15am

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

Other recent topics Other recent topics