none
要如何強迫中止restore工作 RRS feed

  • 一般討論

  • Dear expert,

      現在我的transcation-log 己經佔用partitation百分之99%,而且目前我要如何中斷restore工作,現在附上在log的錯誤訊息,如下:

    其2:請問要如何截斷原本log size,並且讓檔案縮到最小,Tks!

    05/29/2008 08:00:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 08:00:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 07:40:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 07:40:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 07:20:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 07:20:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 07:00:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 07:00:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 06:40:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 06:40:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 06:20:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 06:20:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 06:00:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 06:00:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 05:40:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 05:40:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 05:20:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 05:20:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 05:00:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 05:00:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 04:40:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 04:40:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 04:20:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 04:20:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 04:00:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 04:00:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 04:00:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 04:00:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 03:40:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 03:40:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 03:20:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 03:20:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 03:00:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
    05/29/2008 03:00:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
    05/29/2008 02:40:00,Logon,Unknown,Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]

    • 已變更類型 璉璉 2010年6月19日 上午 09:11
    • 已移動 璉璉 2010年6月19日 上午 09:11 (從:Visual Studio一般討論區(General))
    2008年5月29日 上午 02:28