Chinaunix

标题: 日志清空不了(已解决) [打印本页]

作者: donniejeck 时间: 2008-07-28 09:58
标题: 日志清空不了(已解决)
OS:WINDOWS 2003
1> select @@version
2> go

-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
----------------
Adaptive Server Enterprise/12.5.3/EBF 13331 ESD#7/P/NT (IX86)/OS 4.0/ase1253/19

51/32-bit/OPT/Fri Mar 24 02:17:56 2006

(1 row affected)

[ 本帖最后由 donniejeck 于 2008-8-7 11:46 编辑 ]

作者: donniejeck 时间: 2008-07-28 10:02
name                   db_size    owner                   dbid       created       status
----                   -------    -----                   ----------- -------       ------
WDZX                      52548.0 MB sa                               4 Oct 27, 2007 select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full, mixed log and data

device_fragments             size       usage             created          free kbytes
----------------             ----       -----             -------          -----------
WDZX                            1000.0 MB data only          Oct 27 2007  2:59AM             28
WDZX                               500.0 MB data only          Oct 27 2007  2:59AM          470174
WDZX                            8400.0 MB data only          Oct 27 2007  2:59AM             210
WDZX                            1000.0 MB data only          Oct 27 2007  2:59AM       1019954
WDZX                            21868.0 MB data only          Oct 27 2007  2:59AM          2478
WDZX_log                         2153.0 MB log only          Oct 27 2007  2:59AM not applicable
WDZX_log                            42.0 MB log only          Oct 27 2007  2:59AM not applicable
WDZX_log                            10.0 MB log only          Dec 24 2007  9:29AM not applicable
WDZX_log                            10.0 MB log only          Dec 24 2007 10:46AM not applicable
WDZX_log                            10.0 MB log only          Dec 24 2007 11:55AM not applicable
WDZX_log                            10.0 MB log only          Dec 24 2007  2:29PM not applicable
WDZX_log                            10.0 MB log only          Dec 24 2007  3:11PM not applicable
WDZX_log                            10.0 MB log only          Dec 24 2007  3:59PM not applicable
WDZX_log                            10.0 MB log only          Dec 24 2007  4:47PM not applicable
WDZX_log                            10.0 MB log only          Dec 24 2007  9:57PM not applicable
WDZX_log                            10.0 MB log only          Dec 25 2007  9:22AM not applicable
WDZX_log                            10.0 MB log only          Dec 25 2007  9:29AM not applicable
WDZX_log                            10.0 MB log only          Dec 25 2007  9:38AM not applicable
WDZX_log                            10.0 MB log only          Dec 25 2007 10:24AM not applicable
WDZX_log                            10.0 MB log only          Dec 25 2007 11:41AM not applicable
WDZX_log                            10.0 MB log only          Dec 25 2007  2:27PM not applicable
WDZX_log                            10.0 MB log only          Dec 25 2007  3:45PM not applicable
WDZX_log                            10.0 MB log only          Dec 25 2007  4:37PM not applicable
WDZX_log                            10.0 MB log only          Dec 25 2007  5:26PM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007  8:57AM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007  9:00AM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007  9:03AM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007  9:59AM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007 10:20AM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007 11:11AM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007 11:27AM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007 11:39AM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007  1:33PM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007  2:56PM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007  3:08PM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007  3:37PM not applicable
WDZX_log                            10.0 MB log only          Dec 26 2007  4:32PM not applicable
WDZX_log                            10.0 MB log only          Dec 27 2007  7:18AM not applicable
WDZX_log                            10.0 MB log only          Dec 27 2007  9:06AM not applicable
WDZX_log                            10.0 MB log only          Dec 27 2007  9:28AM not applicable
WDZX_log                            10.0 MB log only          Dec 27 2007 10:09AM not applicable
WDZX_log                            10.0 MB log only          Dec 27 2007 11:15AM not applicable
WDZX_log                            10.0 MB log only          Dec 27 2007 11:35AM not applicable
WDZX_log                            10.0 MB log only          Dec 27 2007  1:25PM not applicable
WDZX_log                            10.0 MB log only          Dec 27 2007  2:46PM not applicable
WDZX_log                            10.0 MB log only          Dec 27 2007  4:34PM not applicable
WDZX_log                            10.0 MB log only          Dec 27 2007  8:53PM not applicable
WDZX_log                            10.0 MB log only          Dec 28 2007  8:37AM not applicable
WDZX_log                            10.0 MB log only          Dec 28 2007 10:20AM not applicable
WDZX_log                            10.0 MB log only          Dec 28 2007 11:09AM not applicable
WDZX_log                            10.0 MB log only          Dec 28 2007 11:38AM not applicable
WDZX_log                            10.0 MB log only          Dec 28 2007  1:33PM not applicable
WDZX_log                            10.0 MB log only          Dec 28 2007  3:11PM not applicable
WDZX_log                            10.0 MB log only          Dec 28 2007  4:50PM not applicable
WDZX_log                            10.0 MB log only          Dec 29 2007  8:56AM not applicable
WDZX_log                            10.0 MB log only          Dec 29 2007  9:05AM not applicable
WDZX_log                            10.0 MB log only          Dec 29 2007  9:56AM not applicable
WDZX_log                            10.0 MB log only          Dec 29 2007 10:49AM not applicable
WDZX_log                            10.0 MB log only          Dec 29 2007 11:25AM not applicable
WDZX_log                            10.0 MB log only          Dec 29 2007 11:48AM not applicable
WDZX_log                            10.0 MB log only          Dec 29 2007  2:33PM not applicable
WDZX_log                            10.0 MB log only          Dec 29 2007  4:56PM not applicable
WDZX_log                            10.0 MB log only          Dec 29 2007  7:07PM not applicable
WDZX_log                            10.0 MB log only          Dec 29 2007  9:21PM not applicable
WDZX_log                            10.0 MB log only          Dec 30 2007  2:43PM not applicable
WDZX_log                            10.0 MB log only          Jan  2 2008  8:28AM not applicable
WDZX_log                            10.0 MB log only          Jan  2 2008  9:26AM not applicable
WDZX_log                            10.0 MB log only          Jan  2 2008  9:28AM not applicable
WDZX_log                            10.0 MB log only          Jan  2 2008 10:50AM not applicable
WDZX_log                            10.0 MB log only          Jan  2 2008  1:36PM not applicable
WDZX_log                            10.0 MB log only          Jan  2 2008  3:40PM not applicable
WDZX_log                            10.0 MB log only          Jan  2 2008  4:45PM not applicable
WDZX_log                            10.0 MB log only          Jan  3 2008  9:46AM not applicable
WDZX_log                            10.0 MB log only          Jan  3 2008 10:45AM not applicable
WDZX_log                            10.0 MB log only          Jan  3 2008 11:27AM not applicable
WDZX_log                            10.0 MB log only          Jan  3 2008 11:57AM not applicable
WDZX_log                            10.0 MB log only          Jan  3 2008  1:17PM not applicable
WDZX_log                            10.0 MB log only          Jan  3 2008  2:59PM not applicable
WDZX_log                            10.0 MB log only          Jan  3 2008  4:44PM not applicable
WDZX_log                            10.0 MB log only          Jan  4 2008  8:29AM not applicable
WDZX_log                            10.0 MB log only          Jan  4 2008  9:25AM not applicable
WDZX_log                            10.0 MB log only          Jan  4 2008 10:35AM not applicable
WDZX_log                            10.0 MB log only          Jan  4 2008 11:58AM not applicable
WDZX_log                            10.0 MB log only          Jan  4 2008  2:43PM not applicable
WDZX_log                            10.0 MB log only          Jan  4 2008  3:48PM not applicable
WDZX_log                            10.0 MB log only          Jan  5 2008  9:05AM not applicable
WDZX_log                            10.0 MB log only          Jan  6 2008  5:33PM not applicable
WDZX_log                            10.0 MB log only          Jan  7 2008  9:21AM not applicable
WDZX_log                            10.0 MB log only          Jan  7 2008 10:11AM not applicable
WDZX_log                            10.0 MB log only          Jan  7 2008 11:21AM not applicable
WDZX_log                            10.0 MB log only          Jan  7 2008 12:40PM not applicable
WDZX_log                            10.0 MB log only          Jan  7 2008  3:09PM not applicable
WDZX_log                            10.0 MB log only          Jan  7 2008  4:39PM not applicable
WDZX_log                            10.0 MB log only          Jan  8 2008  8:59AM not applicable
WDZX_log                            10.0 MB log only          Jan  8 2008  9:46AM not applicable
WDZX_log                            10.0 MB log only          Jan  8 2008 10:24AM not applicable
WDZX_log                            10.0 MB log only          Jan  8 2008 10:44AM not applicable
WDZX_log                            10.0 MB log only          Jan  8 2008 11:46AM not applicable
WDZX_log                            10.0 MB log only          Jan  8 2008  2:00PM not applicable

作者: donniejeck 时间: 2008-07-28 10:03
WDZX_log                            10.0 MB log only          Jan  8 2008  3:14PM not applicable
WDZX_log                            10.0 MB log only          Jan  8 2008  4:00PM not applicable
WDZX_log                            10.0 MB log only          Jan  8 2008  5:31PM not applicable
WDZX_log                            10.0 MB log only          Jan  9 2008  9:14AM not applicable
WDZX_log                            10.0 MB log only          Jan  9 2008 10:26AM not applicable
WDZX_log                            10.0 MB log only          Jan  9 2008 12:11PM not applicable
WDZX_log                            10.0 MB log only          Jan  9 2008  3:33PM not applicable
WDZX_log                            10.0 MB log only          Jan  9 2008  3:33PM not applicable
WDZX_log                            10.0 MB log only          Jan  9 2008  4:15PM not applicable
WDZX_log                            10.0 MB log only          Jan  9 2008  5:17PM not applicable
WDZX_log                            10.0 MB log only          Jan  9 2008  5:23PM not applicable
WDZX_log                            10.0 MB log only          Jan  9 2008  5:38PM not applicable
WDZX_log                            10.0 MB log only          Jan 10 2008  9:39AM not applicable
WDZX_log                            10.0 MB log only          Jan 10 2008  9:48AM not applicable
WDZX_log                            10.0 MB log only          Jan 10 2008 10:25AM not applicable
WDZX_log                            10.0 MB log only          Jan 10 2008 11:33AM not applicable
WDZX_log                            10.0 MB log only          Jan 10 2008  2:41PM not applicable
WDZX_log                            10.0 MB log only          Jan 10 2008  4:16PM not applicable
WDZX_log                            10.0 MB log only          Jan 10 2008  7:36PM not applicable
WDZX_log                            10.0 MB log only          Jan 11 2008  9:35AM not applicable
WDZX_log                            10.0 MB log only          Jan 11 2008 10:20AM not applicable
WDZX_log                            10.0 MB log only          Jan 11 2008 10:20AM not applicable
WDZX_log                            10.0 MB log only          Jan 11 2008 11:13AM not applicable
WDZX_log                            10.0 MB log only          Jan 11 2008  2:20PM not applicable
WDZX_log                            10.0 MB log only          Jan 11 2008  3:19PM not applicable
WDZX_log                            10.0 MB log only          Jan 11 2008  4:51PM not applicable
WDZX_log                            10.0 MB log only          Jan 12 2008 10:49AM not applicable
WDZX_log                            10.0 MB log only          Jan 12 2008  7:42PM not applicable
WDZX_log                            10.0 MB log only          Jan 14 2008  8:42AM not applicable
WDZX_log                            10.0 MB log only          Jan 14 2008  9:56AM not applicable
WDZX_log                            10.0 MB log only          Jan 14 2008 11:18AM not applicable
WDZX_log                            10.0 MB log only          Jan 14 2008 12:10PM not applicable
WDZX_log                            10.0 MB log only          Jan 14 2008  1:57PM not applicable
WDZX_log                            10.0 MB log only          Jan 14 2008  3:12PM not applicable
WDZX_log                            10.0 MB log only          Jan 14 2008  4:14PM not applicable
WDZX_log                            10.0 MB log only          Jan 14 2008  4:38PM not applicable
WDZX_log                            10.0 MB log only          Jan 15 2008  9:27AM not applicable
WDZX_log                            10.0 MB log only          Jan 15 2008  9:50AM not applicable
WDZX_log                            10.0 MB log only          Jan 15 2008 10:25AM not applicable
WDZX_log                            10.0 MB log only          Jan 15 2008 10:52AM not applicable
WDZX_log                            10.0 MB log only          Jan 15 2008 11:14AM not applicable
WDZX_log                            10.0 MB log only          Jan 15 2008  1:25PM not applicable
WDZX_log                            10.0 MB log only          Jan 15 2008  1:32PM not applicable
WDZX_log                            10.0 MB log only          Jan 15 2008  7:51PM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008  8:58AM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008 10:00AM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008 10:49AM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008 10:49AM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008 12:04PM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008  1:51PM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008  2:31PM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008  3:27PM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008  3:33PM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008  3:39PM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008  3:47PM not applicable
WDZX_log                            10.0 MB log only          Jan 16 2008  4:23PM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008  8:55AM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008 10:10AM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008  1:14PM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008  2:28PM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008  2:33PM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008  3:23PM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008  3:39PM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008  3:45PM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008  3:53PM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008  3:54PM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008  3:54PM not applicable
WDZX_log                            10.0 MB log only          Jan 17 2008  3:54PM not applicable
WDZX_log                            10.0 MB log only          Jan 18 2008  9:40AM not applicable
WDZX_log                            10.0 MB log only          Jan 18 2008  9:43AM not applicable
WDZX_log                            10.0 MB log only          Jan 18 2008 10:12AM not applicable
WDZX_log                            10.0 MB log only          Jan 18 2008 12:25PM not applicable
WDZX_log                            10.0 MB log only          Jan 18 2008  3:50PM not applicable
WDZX_log                            10.0 MB log only          Jan 20 2008 11:04AM not applicable
WDZX_log                            10.0 MB log only          Jan 21 2008  9:09AM not applicable
WDZX_log                            10.0 MB log only          Jan 21 2008  9:19AM not applicable
WDZX_log                            10.0 MB log only          Jan 21 2008  9:55AM not applicable
WDZX_log                            10.0 MB log only          Jan 21 2008 11:13AM not applicable
WDZX_log                            10.0 MB log only          Jan 21 2008  2:34PM not applicable
WDZX_log                            10.0 MB log only          Jan 21 2008  2:57PM not applicable
WDZX_log                            10.0 MB log only          Jan 21 2008  3:16PM not applicable
WDZX_log                            10.0 MB log only          Jan 21 2008  4:37PM not applicable
WDZX_log                            10.0 MB log only          Jan 21 2008  5:05PM not applicable
WDZX_log                            10.0 MB log only          Jan 21 2008  5:32PM not applicable
WDZX_log                            10.0 MB log only          Jan 21 2008  5:36PM not applicable
WDZX_log                            10.0 MB log only          Jan 22 2008  9:30AM not applicable
WDZX_log                            10.0 MB log only          Jan 22 2008  9:52AM not applicable
WDZX_log                            10.0 MB log only          Jan 22 2008 11:01AM not applicable
WDZX_log                            10.0 MB log only          Jan 22 2008  2:19PM not applicable
WDZX_log                            10.0 MB log only          Jan 22 2008  3:20PM not applicable
WDZX_log                            10.0 MB log only          Jan 22 2008  4:30PM not applicable
WDZX_log                            10.0 MB log only          Jan 22 2008  5:14PM not applicable
WDZX_log                            10.0 MB log only          Jan 23 2008  9:24AM not applicable
WDZX_log                            10.0 MB log only          Jan 23 2008 10:29AM not applicable
WDZX_log                            10.0 MB log only          Jan 23 2008 11:05AM not applicable
WDZX_log                            10.0 MB log only          Jan 23 2008 12:04PM not applicable
WDZX_log                            10.0 MB log only          Jan 23 2008  2:38PM not applicable
WDZX_log                            10.0 MB log only          Jan 23 2008  3:55PM not applicable
WDZX_log                            10.0 MB log only          Jan 23 2008  4:43PM not applicable
WDZX_log                            10.0 MB log only          Jan 23 2008  5:18PM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008  8:47AM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008  9:44AM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008 10:54AM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008 11:37AM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008 11:37AM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008 11:59AM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008  1:22PM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008  1:24PM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008  1:24PM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008  3:20PM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008  3:48PM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008  4:44PM not applicable
WDZX_log                            10.0 MB log only          Jan 24 2008  5:27PM not applicable
WDZX_log                            10.0 MB log only          Jan 25 2008  8:58AM not applicable
WDZX_log                            10.0 MB log only          Jan 25 2008  9:59AM not applicable
WDZX_log                            10.0 MB log only          Jan 25 2008 10:24AM not applicable
WDZX_log                            10.0 MB log only          Jan 25 2008 11:14AM not applicable
WDZX_log                            10.0 MB log only          Jan 25 2008  2:17PM not applicable
WDZX_log                            10.0 MB log only          Jan 25 2008  2:18PM not applicable
WDZX_log                            10.0 MB log only          Jan 25 2008  3:48PM not applicable
WDZX_log                            10.0 MB log only          Jan 26 2008 10:28AM not applicable
WDZX_log                            10.0 MB log only          Jan 27 2008  2:45PM not applicable
WDZX_log                            10.0 MB log only          Jan 27 2008  5:34PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  9:26AM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  9:52AM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  9:57AM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008 10:08AM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008 10:08AM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008 10:08AM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008 10:24AM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008 11:00AM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008 12:01PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008 12:01PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008 12:01PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008 12:02PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  1:25PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  1:49PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  2:40PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  3:21PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  4:17PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  5:18PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  6:05PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  6:12PM not applicable
WDZX_log                            10.0 MB log only          Jan 28 2008  6:16PM not applicable
WDZX_log                            10.0 MB log only          Jan 29 2008  8:28AM not applicable

作者: donniejeck 时间: 2008-07-28 10:04
WDZX1                               10.0 MB data only          Jul  9 2008  3:52PM             0
WDZX1                               10.0 MB data only          Jul 10 2008  9:14AM             0
WDZX1                               10.0 MB data only          Jul 10 2008 10:29AM             0
WDZX1                               10.0 MB data only          Jul 10 2008 10:40AM             0
WDZX1                               10.0 MB data only          Jul 10 2008 10:43AM             0
WDZX1                               10.0 MB data only          Jul 10 2008 11:12AM             0
WDZX1                               10.0 MB data only          Jul 10 2008  2:19PM             0
WDZX1                               10.0 MB data only          Jul 10 2008  4:14PM             0
WDZX1                               10.0 MB data only          Jul 10 2008  7:41PM             0
WDZX1                               10.0 MB data only          Jul 11 2008  9:08AM             0
WDZX1                               10.0 MB data only          Jul 11 2008  9:28AM             0
WDZX1                               10.0 MB data only          Jul 11 2008 10:51AM             0
WDZX1                               10.0 MB data only          Jul 11 2008 11:58AM             0
WDZX1                               10.0 MB data only          Jul 11 2008  1:34PM             0
WDZX1                               10.0 MB data only          Jul 11 2008  2:44PM             0
WDZX1                               10.0 MB data only          Jul 11 2008  3:05PM             0
WDZX1                               10.0 MB data only          Jul 11 2008  3:21PM             0
WDZX1                               10.0 MB data only          Jul 11 2008  5:33PM             0
WDZX1                               10.0 MB data only          Jul 11 2008  7:27PM             0
WDZX1                               10.0 MB data only          Jul 12 2008  3:41PM             0
WDZX1                               10.0 MB data only          Jul 13 2008  3:55PM             14
WDZX1                               10.0 MB data only          Jul 14 2008  9:52AM             0
WDZX1                               10.0 MB data only          Jul 14 2008  9:55AM             0
WDZX1                               10.0 MB data only          Jul 14 2008 10:33AM             0
WDZX1                               10.0 MB data only          Jul 14 2008 11:26AM             0
WDZX1                               10.0 MB data only          Jul 14 2008  1:53PM             0
WDZX1                               10.0 MB data only          Jul 14 2008  3:22PM             0
WDZX1                               10.0 MB data only          Jul 14 2008  5:19PM             0
WDZX1                               10.0 MB data only          Jul 15 2008  9:29AM             0
WDZX1                               10.0 MB data only          Jul 15 2008 11:09AM             0
WDZX1                               10.0 MB data only          Jul 15 2008  2:36PM             0
WDZX1                               10.0 MB data only          Jul 15 2008  3:02PM             0
WDZX1                               10.0 MB data only          Jul 15 2008  4:38PM             0
WDZX1                               10.0 MB data only          Jul 15 2008  5:48PM             0
WDZX1                               10.0 MB data only          Jul 16 2008  8:42AM             0
WDZX1                               10.0 MB data only          Jul 16 2008  9:22AM             14
WDZX1                               10.0 MB data only          Jul 16 2008  9:25AM             0
WDZX1                               10.0 MB data only          Jul 16 2008 10:09AM             0
WDZX1                               10.0 MB data only          Jul 16 2008 11:52AM             0
WDZX1                               10.0 MB data only          Jul 16 2008  2:43PM             0
WDZX1                               10.0 MB data only          Jul 16 2008  3:08PM             0
WDZX1                               10.0 MB data only          Jul 16 2008  4:02PM             0
WDZX1                               10.0 MB data only          Jul 16 2008  5:50PM             0
WDZX1                               10.0 MB data only          Jul 17 2008  8:43AM             0
WDZX1                               10.0 MB data only          Jul 17 2008  9:58AM             0
WDZX1                               10.0 MB data only          Jul 17 2008 11:00AM             0
WDZX1                               10.0 MB data only          Jul 17 2008 12:29PM             0
WDZX1                               10.0 MB data only          Jul 17 2008  2:12PM             0
WDZX1                               10.0 MB data only          Jul 17 2008  4:16PM             0
WDZX1                               10.0 MB data only          Jul 17 2008  5:02PM             0
WDZX1                               10.0 MB data only          Jul 17 2008  6:48PM             0
WDZX1                               10.0 MB data only          Jul 18 2008  9:15AM             0
WDZX1                               10.0 MB data only          Jul 18 2008  9:35AM             0
WDZX1                               10.0 MB data only          Jul 18 2008 10:59AM             0
WDZX1                               10.0 MB data only          Jul 18 2008 11:56AM             0
WDZX1                               10.0 MB data only          Jul 18 2008  3:16PM             0
WDZX1                               10.0 MB data only          Jul 18 2008  4:31PM             0
WDZX1                               10.0 MB data only          Jul 18 2008  4:45PM             0
WDZX1                               10.0 MB data only          Jul 18 2008  5:16PM             0
WDZX1                               10.0 MB data only          Jul 19 2008 11:24AM             0
WDZX1                               10.0 MB data only          Jul 19 2008 11:32AM             0
WDZX1                               10.0 MB data only          Jul 19 2008  1:11PM             0
WDZX1                               10.0 MB data only          Jul 20 2008  3:25PM             0
WDZX1                               10.0 MB data only          Jul 21 2008  8:56AM             0
WDZX1                               10.0 MB data only          Jul 21 2008  9:37AM             0
WDZX1                               10.0 MB data only          Jul 21 2008 10:20AM             0
WDZX1                               10.0 MB data only          Jul 21 2008 10:56AM             0
WDZX1                               10.0 MB data only          Jul 21 2008 11:36AM             0
WDZX1                               10.0 MB data only          Jul 21 2008  2:03PM             0
WDZX1                               10.0 MB data only          Jul 21 2008  3:42PM             0
WDZX1                               10.0 MB data only          Jul 22 2008  2:45PM             0
WDZX1                               10.0 MB data only          Jul 22 2008  3:07PM             0
WDZX1                               10.0 MB data only          Jul 22 2008  4:06PM             0
WDZX1                               10.0 MB data only          Jul 22 2008  4:40PM             0
WDZX1                               10.0 MB data only          Jul 22 2008  5:19PM             0
WDZX1                            4722.0 MB data only          Jul 23 2008  3:01PM       4607162
WDZX_log                            3.0 MB log only          Jul 25 2008  6:50PM not applicable


-
log only free kbytes = 49976

作者: donniejeck 时间: 2008-07-28 10:04
segment    name                         status
----------- ----                         -----------
      2 logsegment                            0

device                      size
------                      ----
WDZX_log                      9188.0MB

free_pages
-----------
   24971

table_name                   index_name                   indid
----------                   ----------                   -----------
syslogs                      syslogs                               0

total_size       total_pages    free_pages    used_pages    reserved_pages
----------       -----------    ----------    ----------    --------------
9188.0MB       4704256       24971          18385          36

作者: donniejeck 时间: 2008-07-28 10:05
select s.name, size = sum(u.size)/512.0 ,
used = sum(u.size - curunreservedpgs(u.dbid, u.lstart, u.unreservedpgs))/512.0 ,
unused = sum(curunreservedpgs(u.dbid, u.lstart, u.unreservedpgs))/512.0
from dbo.syssegments s, master.dbo.sysusages u
where 1 = 1 and ((u.segmap / ((s.segment & 1) + 1)) / power(2, (s.segment & 30))) & 1 = 1
and u.dbid = db_id() and s.name like '%' group by s.name order by 1

name                         size             used             unused
----                         ------------------- ------------------- -------------------
default                            43360.000000       37403.330078       5956.669921
logsegment                            9188.000000       9139.142578          48.857421
system                               43360.000000       37403.330078       5956.669921

作者: shawnlee 时间: 2008-07-28 10:05
提示: 作者被禁止或删除内容自动屏蔽

作者: donniejeck 时间: 2008-07-28 10:06
--日志段空间
select  log_free_size=  convert (char, lct_admin("logsegment_freepages", db_id()) * 2.0 / 1024.0)

log_free_size
-------------
48.8574218

作者: shawnlee 时间: 2008-07-28 10:08
提示: 作者被禁止或删除内容自动屏蔽

作者: donniejeck 时间: 2008-07-28 10:13
没有其它事务了,我在单用户模式下也清不了.

作者: shawnlee 时间: 2008-07-28 10:14
提示: 作者被禁止或删除内容自动屏蔽

作者: hobbylu 时间: 2008-07-28 10:16
use dbname
go
dbcc gettrunc
go

作者: donniejeck 时间: 2008-07-28 10:45
1> use WDZX
2> go
1> dbcc gettrunc
2> go
ltm_truncpage ltm_trunc_state db_rep_stat gen_id    dbid
      dbname                      lti_version
------------- --------------- ----------- ----------- ------
      ------------------------------ -----------
         0             0          0          0    4
      WDZX                                  0

作者: donniejeck 时间: 2008-07-28 10:46

原帖由 shawnlee 于 2008-7-28 10:14 发表
重起也不行?

重起也没用

作者: donniejeck 时间: 2008-07-28 18:18
dbcc rebuild_log(WDZX,1,1)
也不好使

作者: Eisen 时间: 2008-07-29 14:56
dump tran dbname with truncate_only
dump tran dbname with no_log

sp_dboption dbname,'trunc',true

sp_config_rep_agent dbname,'disable'

以上方法都试过吗?

作者: donniejeck 时间: 2008-07-31 09:19
我的应用没有使用复制

作者: donniejeck 时间: 2008-07-31 11:29
标题: dbcc syslogs表结果
1> dbcc tablealloc(syslogs,full,fix)
2> go
***************************************************************
TABLE: syslogs       OBJID = 8
INDID=0  FIRST=20164088  ROOT=20164088 SORT=0
      Data level: 0.  1 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
Alloc page 20163840 (# of extent=1 used pages=8 ref pages=1)
Total (# of extent=1 used pages=8 ref pages=1) in this database
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.

DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
The default report option of OPTIMIZED is used for this run.
The default fix option of NOFIX is used for this run.
***************************************************************
TABLE: syslogs OBJID = 8
INDID=0    FIRST=17828323    ROOT=17828324    SORT=0
Data level: 0.  2 Data pages allocated and 1 Extents allocated.
TOTAL # of extents = 1
Alloc page 17828096 (# of extent=1 used pages=5 ref pages=2)
Total (# of extent=1 used pages=5 ref pages=2) in this database

Statistical information for this run follows:
Total # of pages read = 2
Total # of pages found cache = 1
Total # of physical reads = 1
Total # of saved I/O = 0
Size of I/O used = 8 pages
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.

DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
Syslogs free space count has been successfully recalculated. It has been
corrected to 25015 pages.
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.

作者: robinhm 时间: 2008-08-01 11:14
select spid from master..syslogshold

kill spid

dump tran dbname with truncate_only

如果還不行, 就
dump tran dbname with no_log

應該可以的;

作者: donniejeck 时间: 2008-08-04 09:07
没有最早的事务存在.

作者: robinhm 时间: 2008-08-04 10:04
是不是sybase 的bug; 打最新的EBF試一下;

作者: donniejeck 时间: 2008-08-04 10:25
1> sp_spaceused
2> go
database_name                database_size
------------------------------ -------------
WDZX                         52548.0 MB
reserved       data          index_size    unused
--------------- --------------- --------------- ---------------
48033524 KB    305516 KB    47597950 KB    130058 KB

作者: donniejeck 时间: 2008-08-04 10:26
1> select @@version
2> go

-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
----------------
Adaptive Server Enterprise/12.5.3/EBF 13331 ESD#7/P/NT (IX86)/OS 4.0/ase1253/19

51/32-bit/OPT/Fri Mar 24 02:17:56 2006

作者: robinhm 时间: 2008-08-04 11:05
補丁的確是目前最高的啦, 我無語了; 高手來解答吧!

作者: donniejeck 时间: 2008-08-04 11:24
1> sp_helpsegment 'logsegment'
2> go
segment name                         status
------- ------------------------------ ------
   2 logsegment                         0
device                      size
------------------------------ ----------------------
WDZX_log                      9188.0MB
free_pages
-----------
   22572
table_name                   index_name                   indid
------------------------------ ------------------------------ ------
syslogs                      syslogs                            0
total_size       total_pages    free_pages    used_pages
      reserved_pages
----------------- --------------- --------------- ---------------
      ---------------
9188.0MB       4704256       22572          18508
      90
(return status = 0)

1> dbcc usedextents (4,0,0,1)
2> go
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.

作者: donniejeck 时间: 2008-08-04 14:18
Disk piece 24485376 (2417664 pages), extents used = 13593, free = 288615
Disk piece 24485376: unreserved pages array claims free pages = 2299815, but
this function counted 2299775
Disk piece 26903040 (1536 pages), extents used = 0, free = 192
74 bad per-diskpiece page counts were found in dbtable.
Those for data or data-and-log were corrected in memory;
dedicated log segment page counts are not changed by this function.
Total used extents = 3015434
Total free extents = 347638
Total extents = 3363072
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.

作者: Eisen 时间: 2008-08-05 16:09
很危险的方法——
手工单用户命令行方式启动ASE,用-T7446标记，
然后dbcc sysgam(dbname)试试。

作者: 回族四少 时间: 2008-08-31 18:51
看着是已解决进来的，却没有搞明白楼主最后是怎么解决的。。。

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)