• tanks a lot

    i'm so confused

    1:in simple recovery when i shrink log file to zero i cant see the logs in fn_dblog(null, null) but still apex can show the logs,what do you mean by 'What Apex is seeing is the live database log'?

    2:in full recovery,i have a full backup from 09:00 am yesterday,and a log backup from 11:00 pm yesterday,can i restore the data from 8:00 pm yesterday?

    how can i obtain the right LSN?or how to restore to 8:00 pm?

    i read these pages but understanding nothing:ermm:

    http://msdn.microsoft.com/en-us/library/ms191459.aspx

    http://www.sqlservercentral.com/Forum/Topic1104430-391-1.aspx#bm1104439