16 个解决方案
#1
查看详细的错误信息,贴一下..
#2
你贴的是作业的报错信息，具体为什么重建索引会报错，有报错信息不，你可以看看errorlog里有没有
一般来说重新索引不怎么会报错
#3
日期,源,严重性,消息
06/30/2016 16:35:07,spid65,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:35:07,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:35:07,spid65,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:35:07,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:34:15,spid65,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:34:15,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:34:14,spid65,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:34:14,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:32:47,spid65,未知,The transaction log for database 'EIS' is full. To find out why space in the log cannot be reused<c/> see the log_reuse_wait_desc column in sys.databases
06/30/2016 16:32:47,spid65,未知,错误: 9002，严重性: 17，状态: 4。
06/30/2016 16:32:47,spid65,未知,The transaction log for database 'EIS' is full. To find out why space in the log cannot be reused<c/> see the log_reuse_wait_desc column in sys.databases
06/30/2016 16:32:47,spid65,未知,错误: 9002，严重性: 17，状态: 4。
06/30/2016 00:01:07,spid60,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 00:01:07,spid60,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 00:01:07,spid60,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 00:01:07,spid60,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 00:00:21,spid24s,未知,This instance of SQL Server has been using a process ID of 134716 since 2016-6-28 16:49:59 (local) 2016-6-28 8:49:59 (UTC). This is an informational message only; no user action is required.
06/29/2016 19:30:17,备份,未知,Database backed up. Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> pages dumped: 10250<c/> first LSN: 137391:442:62<c/> last LSN: 137391:467:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_29_193002_2812500.bak'}). This is an informational message only. No user action is required.
06/29/2016 19:30:14,备份,未知,Database backed up. Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> pages dumped: 34954<c/> first LSN: 253309:114:39<c/> last LSN: 253309:130:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_29_193002_2656250.bak'}). This is an informational message only. No user action is required.
06/29/2016 13:15:26,spid68,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 13:15:26,spid68,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 13:15:26,spid68,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 13:15:26,spid68,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:20:21,spid70,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:20:21,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:20:21,spid70,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:20:21,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:19:43,spid70,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:19:43,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:19:43,spid70,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:19:43,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:01:31,spid59,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 00:01:31,spid59,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:01:31,spid59,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 00:01:31,spid59,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:00:59,spid22s,未知,This instance of SQL Server has been using a process ID of 134716 since 2016-6-28 16:49:59 (local) 2016-6-28 8:49:59 (UTC). This is an informational message only; no user action is required.
06/28/2016 19:30:18,备份,未知,Database backed up. Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> pages dumped: 10250<c/> first LSN: 137391:247:68<c/> last LSN: 137391:275:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_28_193001_1250000.bak'}). This is an informational message only. No user action is required.
06/28/2016 19:30:14,备份,未知,Database backed up. Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> pages dumped: 34954<c/> first LSN: 253308:392:46<c/> last LSN: 253308:411:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_28_193001_1250000.bak'}). This is an informational message only. No user action is required.
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE ZoneKingNet. Check the backup application log for detailed messages.
06/28/2016 17:20:03,备份,未知,错误: 3041，严重性: 16，状态: 1。
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\ZoneKingNet\ZoneKingNet_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/30/2016 16:35:07,spid65,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:35:07,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:35:07,spid65,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:35:07,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:34:15,spid65,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:34:15,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:34:14,spid65,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:34:14,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:32:47,spid65,未知,The transaction log for database 'EIS' is full. To find out why space in the log cannot be reused<c/> see the log_reuse_wait_desc column in sys.databases
06/30/2016 16:32:47,spid65,未知,错误: 9002，严重性: 17，状态: 4。
06/30/2016 16:32:47,spid65,未知,The transaction log for database 'EIS' is full. To find out why space in the log cannot be reused<c/> see the log_reuse_wait_desc column in sys.databases
06/30/2016 16:32:47,spid65,未知,错误: 9002，严重性: 17，状态: 4。
06/30/2016 00:01:07,spid60,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 00:01:07,spid60,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 00:01:07,spid60,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 00:01:07,spid60,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 00:00:21,spid24s,未知,This instance of SQL Server has been using a process ID of 134716 since 2016-6-28 16:49:59 (local) 2016-6-28 8:49:59 (UTC). This is an informational message only; no user action is required.
06/29/2016 19:30:17,备份,未知,Database backed up. Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> pages dumped: 10250<c/> first LSN: 137391:442:62<c/> last LSN: 137391:467:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_29_193002_2812500.bak'}). This is an informational message only. No user action is required.
06/29/2016 19:30:14,备份,未知,Database backed up. Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> pages dumped: 34954<c/> first LSN: 253309:114:39<c/> last LSN: 253309:130:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_29_193002_2656250.bak'}). This is an informational message only. No user action is required.
06/29/2016 13:15:26,spid68,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 13:15:26,spid68,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 13:15:26,spid68,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 13:15:26,spid68,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:20:21,spid70,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:20:21,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:20:21,spid70,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:20:21,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:19:43,spid70,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:19:43,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:19:43,spid70,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:19:43,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:01:31,spid59,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 00:01:31,spid59,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:01:31,spid59,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 00:01:31,spid59,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:00:59,spid22s,未知,This instance of SQL Server has been using a process ID of 134716 since 2016-6-28 16:49:59 (local) 2016-6-28 8:49:59 (UTC). This is an informational message only; no user action is required.
06/28/2016 19:30:18,备份,未知,Database backed up. Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> pages dumped: 10250<c/> first LSN: 137391:247:68<c/> last LSN: 137391:275:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_28_193001_1250000.bak'}). This is an informational message only. No user action is required.
06/28/2016 19:30:14,备份,未知,Database backed up. Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> pages dumped: 34954<c/> first LSN: 253308:392:46<c/> last LSN: 253308:411:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_28_193001_1250000.bak'}). This is an informational message only. No user action is required.
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE ZoneKingNet. Check the backup application log for detailed messages.
06/28/2016 17:20:03,备份,未知,错误: 3041，严重性: 16，状态: 1。
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\ZoneKingNet\ZoneKingNet_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
#4
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE ZKLIS. Check the backup application log for detailed messages.
06/28/2016 17:20:03,备份,未知,错误: 3041，严重性: 16，状态: 1。
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\ZKLIS\ZKLIS_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE JZCIS. Check the backup application log for detailed messages.
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE ZKLIS. Check the backup application log for detailed messages.
06/28/2016 17:20:03,备份,未知,错误: 3041，严重性: 16，状态: 1。
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\ZKLIS\ZKLIS_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE JZCIS. Check the backup application log for detailed messages.
#5
06/28/2016 17:20:03,备份,未知,错误: 3041，严重性: 16，状态: 1。
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\JZCIS\JZCIS_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
06/28/2016 17:20:03,备份,未知,Database backed up. Database: EIS<c/> creation date(time): 2016/06/21(17:52:48)<c/> pages dumped: 7574<c/> first LSN: 17952:2112:37<c/> last LSN: 17952:2128:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'E:\backup-PM\EIS\EIS_backup_2016_06_28_172000_8125000.bak'}). This is an informational message only. No user action is required.
06/28/2016 17:01:16,备份,未知,Database was restored: Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> first LSN: 253308:341:39<c/> last LSN: 253308:357:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\ZKPACS_DATA\DB\CZCIS_backup_2016_06_21_193004_7031250.bak'}). Informational message. No user action required.
06/28/2016 17:01:16,备份,未知,Restore is complete on database 'CZCIS'. The database is now available.
06/28/2016 17:01:16,spid57,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 17:01:16,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 17:01:15,spid57,未知,The database 'CZCIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 17:01:15,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 17:00:46,备份,未知,Database was restored: Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> first LSN: 137391:206:37<c/> last LSN: 137391:222:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\ZKPACS_DATA\DB\CZLIS_backup_2016_06_21_193004_7031250.bak'}). Informational message. No user action required.
06/28/2016 17:00:46,备份,未知,Restore is complete on database 'CZLIS'. The database is now available.
06/28/2016 17:00:46,spid57,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 17:00:46,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 17:00:46,spid57,未知,The database 'CZLIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 17:00:46,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:51:01,备份,未知,Database was restored: Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> first LSN: 253309:297:39<c/> last LSN: 253309:313:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_23_193001_2031250.bak'}). Informational message. No user action required.
06/28/2016 16:51:01,备份,未知,Restore is complete on database 'CZCIS'. The database is now available.
06/28/2016 16:51:01,spid57,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:51:00,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 16:51:00,spid57,未知,The database 'CZCIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 16:51:00,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 16:50:30,备份,未知,Database was restored: Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> first LSN: 137392:124:37<c/> last LSN: 137392:140:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_23_193001_2031250.bak'}). Informational message. No user action required.
06/28/2016 16:50:30,备份,未知,Restore is complete on database 'CZLIS'. The database is now available.
06/28/2016 16:50:30,spid57,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:50:30,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:50:29,spid57,未知,The database 'CZLIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 16:50:29,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:50:00,spid53,未知,Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:50:00,spid53,未知,Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:50:00,spid53,未知,Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid7s,未知,Recovery is complete. This is an informational message only. No user action is required.
06/28/2016 16:49:59,spid23s,未知,CHECKDB for database 'ZKLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:58,spid22s,未知,CHECKDB for database 'JZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:53,spid24s,未知,CHECKDB for database 'ZoneKingNet' finished without errors on 2013-04-20 12:00:49.700 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:51,spid21s,未知,CHECKDB for database 'EIS' finished without errors on 2013-04-20 12:00:13.843 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:50,spid20s,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:49,spid25s,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:49,spid20s,未知,Starting up database 'CZLIS'.
06/28/2016 16:49:48,spid25s,未知,Starting up database 'CZCIS'.
06/28/2016 16:49:48,spid24s,未知,Starting up database 'ZoneKingNet'.
06/28/2016 16:49:48,spid23s,未知,Starting up database 'ZKLIS'.
06/28/2016 16:49:48,spid22s,未知,Starting up database 'JZCIS'.
06/28/2016 16:49:48,spid21s,未知,Starting up database 'EIS'.
06/28/2016 16:49:48,spid20s,未知,Starting up database 'ReportServerTempDB'.
06/28/2016 16:49:48,spid19s,未知,Starting up database 'ReportServer'.
06/28/2016 16:49:48,spid13s,未知,Starting up database 'msdb'.
06/28/2016 16:49:48,spid13s,未知,A new instance of the full-text filter daemon host process has been successfully started.
06/28/2016 16:49:48,spid14s,未知,Service Broker manager has started.
06/28/2016 16:49:48,spid14s,未知,The Database Mirroring protocol transport is disabled or not configured.
06/28/2016 16:49:48,spid14s,未知,The Service Broker protocol transport is disabled or not configured.
06/28/2016 16:49:48,spid10s,未知,Starting up database 'tempdb'.
06/28/2016 16:49:48,服务器,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.
06/28/2016 16:49:48,服务器,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b<c/> state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
06/28/2016 16:49:48,服务器,未知,Dedicated admin connection support was established for listening locally on port 1434.
06/28/2016 16:49:48,服务器,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].
06/28/2016 16:49:48,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
06/28/2016 16:49:48,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
06/28/2016 16:49:48,服务器,未知,Server is listening on [ 'any' <ipv4> 1433].
06/28/2016 16:49:48,服务器,未知,A self-generated certificate was successfully loaded for encryption.
06/28/2016 16:49:48,spid10s,未知,Clearing tempdb database.
06/28/2016 16:49:48,spid7s,未知,Server name is 'KANGQIAO-FWQ'. This is an informational message only. No user action is required.
06/28/2016 16:49:48,spid10s,未知,Starting up database 'model'.
06/28/2016 16:49:48,spid7s,未知,The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\JZCIS\JZCIS_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
06/28/2016 17:20:03,备份,未知,Database backed up. Database: EIS<c/> creation date(time): 2016/06/21(17:52:48)<c/> pages dumped: 7574<c/> first LSN: 17952:2112:37<c/> last LSN: 17952:2128:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'E:\backup-PM\EIS\EIS_backup_2016_06_28_172000_8125000.bak'}). This is an informational message only. No user action is required.
06/28/2016 17:01:16,备份,未知,Database was restored: Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> first LSN: 253308:341:39<c/> last LSN: 253308:357:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\ZKPACS_DATA\DB\CZCIS_backup_2016_06_21_193004_7031250.bak'}). Informational message. No user action required.
06/28/2016 17:01:16,备份,未知,Restore is complete on database 'CZCIS'. The database is now available.
06/28/2016 17:01:16,spid57,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 17:01:16,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 17:01:15,spid57,未知,The database 'CZCIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 17:01:15,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 17:00:46,备份,未知,Database was restored: Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> first LSN: 137391:206:37<c/> last LSN: 137391:222:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\ZKPACS_DATA\DB\CZLIS_backup_2016_06_21_193004_7031250.bak'}). Informational message. No user action required.
06/28/2016 17:00:46,备份,未知,Restore is complete on database 'CZLIS'. The database is now available.
06/28/2016 17:00:46,spid57,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 17:00:46,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 17:00:46,spid57,未知,The database 'CZLIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 17:00:46,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:51:01,备份,未知,Database was restored: Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> first LSN: 253309:297:39<c/> last LSN: 253309:313:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_23_193001_2031250.bak'}). Informational message. No user action required.
06/28/2016 16:51:01,备份,未知,Restore is complete on database 'CZCIS'. The database is now available.
06/28/2016 16:51:01,spid57,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:51:00,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 16:51:00,spid57,未知,The database 'CZCIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 16:51:00,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 16:50:30,备份,未知,Database was restored: Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> first LSN: 137392:124:37<c/> last LSN: 137392:140:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_23_193001_2031250.bak'}). Informational message. No user action required.
06/28/2016 16:50:30,备份,未知,Restore is complete on database 'CZLIS'. The database is now available.
06/28/2016 16:50:30,spid57,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:50:30,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:50:29,spid57,未知,The database 'CZLIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 16:50:29,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:50:00,spid53,未知,Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:50:00,spid53,未知,Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:50:00,spid53,未知,Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid7s,未知,Recovery is complete. This is an informational message only. No user action is required.
06/28/2016 16:49:59,spid23s,未知,CHECKDB for database 'ZKLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:58,spid22s,未知,CHECKDB for database 'JZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:53,spid24s,未知,CHECKDB for database 'ZoneKingNet' finished without errors on 2013-04-20 12:00:49.700 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:51,spid21s,未知,CHECKDB for database 'EIS' finished without errors on 2013-04-20 12:00:13.843 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:50,spid20s,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:49,spid25s,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:49,spid20s,未知,Starting up database 'CZLIS'.
06/28/2016 16:49:48,spid25s,未知,Starting up database 'CZCIS'.
06/28/2016 16:49:48,spid24s,未知,Starting up database 'ZoneKingNet'.
06/28/2016 16:49:48,spid23s,未知,Starting up database 'ZKLIS'.
06/28/2016 16:49:48,spid22s,未知,Starting up database 'JZCIS'.
06/28/2016 16:49:48,spid21s,未知,Starting up database 'EIS'.
06/28/2016 16:49:48,spid20s,未知,Starting up database 'ReportServerTempDB'.
06/28/2016 16:49:48,spid19s,未知,Starting up database 'ReportServer'.
06/28/2016 16:49:48,spid13s,未知,Starting up database 'msdb'.
06/28/2016 16:49:48,spid13s,未知,A new instance of the full-text filter daemon host process has been successfully started.
06/28/2016 16:49:48,spid14s,未知,Service Broker manager has started.
06/28/2016 16:49:48,spid14s,未知,The Database Mirroring protocol transport is disabled or not configured.
06/28/2016 16:49:48,spid14s,未知,The Service Broker protocol transport is disabled or not configured.
06/28/2016 16:49:48,spid10s,未知,Starting up database 'tempdb'.
06/28/2016 16:49:48,服务器,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.
06/28/2016 16:49:48,服务器,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b<c/> state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
06/28/2016 16:49:48,服务器,未知,Dedicated admin connection support was established for listening locally on port 1434.
06/28/2016 16:49:48,服务器,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].
06/28/2016 16:49:48,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
06/28/2016 16:49:48,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
06/28/2016 16:49:48,服务器,未知,Server is listening on [ 'any' <ipv4> 1433].
06/28/2016 16:49:48,服务器,未知,A self-generated certificate was successfully loaded for encryption.
06/28/2016 16:49:48,spid10s,未知,Clearing tempdb database.
06/28/2016 16:49:48,spid7s,未知,Server name is 'KANGQIAO-FWQ'. This is an informational message only. No user action is required.
06/28/2016 16:49:48,spid10s,未知,Starting up database 'model'.
06/28/2016 16:49:48,spid7s,未知,The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
#6
直接看下你执行计划失败的的详细信息！
#7
磁盘空间不足
#8
提示磁盘空间不足啊，看下服务器的硬盘是不是不够
#9
C盘存储数据库文件的磁盘空间还有60G，这个值足够使用了，可是还是会报错。
#10
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\JZCIS\JZCIS_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
E盘看看。
#11
ZKLIS,JZCIS,EIS这些数据库文件所在磁盘分区(未必都在C盘,请确认)的剩余空间不足,
建议一次只处理一个数据库,不要所有数据库一起做索引维护,对磁盘压力太大.
建议一次只处理一个数据库,不要所有数据库一起做索引维护,对磁盘压力太大.
#12
查看错误的详细信息，上面都提示磁盘空间不足了。
#13
请排查数据库文件所在磁盘的空间，看是否有足够的空间。。。。。。。。。。。。。
#14
每个盘子最少还有60G的空间
#15
当前有60G不代表维护计划运行时也有60G喔,
维护计划对磁盘空间冲击比较大,所以建议一次只处理一个数据库,不要所有数据库一起做索引维护,对磁盘压力太大.
#16
好了，谢谢各位，5G数据还是没法重新生成索引，不过删除几万条数据后没有问题了。
#1
查看详细的错误信息,贴一下..
#2
你贴的是作业的报错信息，具体为什么重建索引会报错，有报错信息不，你可以看看errorlog里有没有
一般来说重新索引不怎么会报错
#3
日期,源,严重性,消息
06/30/2016 16:35:07,spid65,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:35:07,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:35:07,spid65,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:35:07,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:34:15,spid65,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:34:15,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:34:14,spid65,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:34:14,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:32:47,spid65,未知,The transaction log for database 'EIS' is full. To find out why space in the log cannot be reused<c/> see the log_reuse_wait_desc column in sys.databases
06/30/2016 16:32:47,spid65,未知,错误: 9002，严重性: 17，状态: 4。
06/30/2016 16:32:47,spid65,未知,The transaction log for database 'EIS' is full. To find out why space in the log cannot be reused<c/> see the log_reuse_wait_desc column in sys.databases
06/30/2016 16:32:47,spid65,未知,错误: 9002，严重性: 17，状态: 4。
06/30/2016 00:01:07,spid60,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 00:01:07,spid60,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 00:01:07,spid60,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 00:01:07,spid60,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 00:00:21,spid24s,未知,This instance of SQL Server has been using a process ID of 134716 since 2016-6-28 16:49:59 (local) 2016-6-28 8:49:59 (UTC). This is an informational message only; no user action is required.
06/29/2016 19:30:17,备份,未知,Database backed up. Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> pages dumped: 10250<c/> first LSN: 137391:442:62<c/> last LSN: 137391:467:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_29_193002_2812500.bak'}). This is an informational message only. No user action is required.
06/29/2016 19:30:14,备份,未知,Database backed up. Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> pages dumped: 34954<c/> first LSN: 253309:114:39<c/> last LSN: 253309:130:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_29_193002_2656250.bak'}). This is an informational message only. No user action is required.
06/29/2016 13:15:26,spid68,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 13:15:26,spid68,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 13:15:26,spid68,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 13:15:26,spid68,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:20:21,spid70,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:20:21,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:20:21,spid70,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:20:21,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:19:43,spid70,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:19:43,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:19:43,spid70,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:19:43,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:01:31,spid59,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 00:01:31,spid59,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:01:31,spid59,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 00:01:31,spid59,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:00:59,spid22s,未知,This instance of SQL Server has been using a process ID of 134716 since 2016-6-28 16:49:59 (local) 2016-6-28 8:49:59 (UTC). This is an informational message only; no user action is required.
06/28/2016 19:30:18,备份,未知,Database backed up. Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> pages dumped: 10250<c/> first LSN: 137391:247:68<c/> last LSN: 137391:275:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_28_193001_1250000.bak'}). This is an informational message only. No user action is required.
06/28/2016 19:30:14,备份,未知,Database backed up. Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> pages dumped: 34954<c/> first LSN: 253308:392:46<c/> last LSN: 253308:411:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_28_193001_1250000.bak'}). This is an informational message only. No user action is required.
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE ZoneKingNet. Check the backup application log for detailed messages.
06/28/2016 17:20:03,备份,未知,错误: 3041，严重性: 16，状态: 1。
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\ZoneKingNet\ZoneKingNet_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/30/2016 16:35:07,spid65,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:35:07,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:35:07,spid65,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:35:07,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:34:15,spid65,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:34:15,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:34:14,spid65,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 16:34:14,spid65,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 16:32:47,spid65,未知,The transaction log for database 'EIS' is full. To find out why space in the log cannot be reused<c/> see the log_reuse_wait_desc column in sys.databases
06/30/2016 16:32:47,spid65,未知,错误: 9002，严重性: 17，状态: 4。
06/30/2016 16:32:47,spid65,未知,The transaction log for database 'EIS' is full. To find out why space in the log cannot be reused<c/> see the log_reuse_wait_desc column in sys.databases
06/30/2016 16:32:47,spid65,未知,错误: 9002，严重性: 17，状态: 4。
06/30/2016 00:01:07,spid60,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 00:01:07,spid60,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 00:01:07,spid60,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/30/2016 00:01:07,spid60,未知,错误: 1101，严重性: 17，状态: 12。
06/30/2016 00:00:21,spid24s,未知,This instance of SQL Server has been using a process ID of 134716 since 2016-6-28 16:49:59 (local) 2016-6-28 8:49:59 (UTC). This is an informational message only; no user action is required.
06/29/2016 19:30:17,备份,未知,Database backed up. Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> pages dumped: 10250<c/> first LSN: 137391:442:62<c/> last LSN: 137391:467:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_29_193002_2812500.bak'}). This is an informational message only. No user action is required.
06/29/2016 19:30:14,备份,未知,Database backed up. Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> pages dumped: 34954<c/> first LSN: 253309:114:39<c/> last LSN: 253309:130:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_29_193002_2656250.bak'}). This is an informational message only. No user action is required.
06/29/2016 13:15:26,spid68,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 13:15:26,spid68,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 13:15:26,spid68,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 13:15:26,spid68,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:20:21,spid70,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:20:21,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:20:21,spid70,未知,Could not allocate a new page for database 'ZKLIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:20:21,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:19:43,spid70,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:19:43,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 10:19:43,spid70,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 10:19:43,spid70,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:01:31,spid59,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 00:01:31,spid59,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:01:31,spid59,未知,Could not allocate a new page for database 'JZCIS' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup<c/> adding additional files to the filegroup<c/> or setting autogrowth on for existing files in the filegroup.
06/29/2016 00:01:31,spid59,未知,错误: 1101，严重性: 17，状态: 12。
06/29/2016 00:00:59,spid22s,未知,This instance of SQL Server has been using a process ID of 134716 since 2016-6-28 16:49:59 (local) 2016-6-28 8:49:59 (UTC). This is an informational message only; no user action is required.
06/28/2016 19:30:18,备份,未知,Database backed up. Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> pages dumped: 10250<c/> first LSN: 137391:247:68<c/> last LSN: 137391:275:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_28_193001_1250000.bak'}). This is an informational message only. No user action is required.
06/28/2016 19:30:14,备份,未知,Database backed up. Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> pages dumped: 34954<c/> first LSN: 253308:392:46<c/> last LSN: 253308:411:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_28_193001_1250000.bak'}). This is an informational message only. No user action is required.
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE ZoneKingNet. Check the backup application log for detailed messages.
06/28/2016 17:20:03,备份,未知,错误: 3041，严重性: 16，状态: 1。
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\ZoneKingNet\ZoneKingNet_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
#4
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE ZKLIS. Check the backup application log for detailed messages.
06/28/2016 17:20:03,备份,未知,错误: 3041，严重性: 16，状态: 1。
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\ZKLIS\ZKLIS_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE JZCIS. Check the backup application log for detailed messages.
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE ZKLIS. Check the backup application log for detailed messages.
06/28/2016 17:20:03,备份,未知,错误: 3041，严重性: 16，状态: 1。
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\ZKLIS\ZKLIS_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
06/28/2016 17:20:03,备份,未知,BACKUP failed to complete the command BACKUP DATABASE JZCIS. Check the backup application log for detailed messages.
#5
06/28/2016 17:20:03,备份,未知,错误: 3041，严重性: 16，状态: 1。
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\JZCIS\JZCIS_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
06/28/2016 17:20:03,备份,未知,Database backed up. Database: EIS<c/> creation date(time): 2016/06/21(17:52:48)<c/> pages dumped: 7574<c/> first LSN: 17952:2112:37<c/> last LSN: 17952:2128:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'E:\backup-PM\EIS\EIS_backup_2016_06_28_172000_8125000.bak'}). This is an informational message only. No user action is required.
06/28/2016 17:01:16,备份,未知,Database was restored: Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> first LSN: 253308:341:39<c/> last LSN: 253308:357:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\ZKPACS_DATA\DB\CZCIS_backup_2016_06_21_193004_7031250.bak'}). Informational message. No user action required.
06/28/2016 17:01:16,备份,未知,Restore is complete on database 'CZCIS'. The database is now available.
06/28/2016 17:01:16,spid57,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 17:01:16,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 17:01:15,spid57,未知,The database 'CZCIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 17:01:15,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 17:00:46,备份,未知,Database was restored: Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> first LSN: 137391:206:37<c/> last LSN: 137391:222:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\ZKPACS_DATA\DB\CZLIS_backup_2016_06_21_193004_7031250.bak'}). Informational message. No user action required.
06/28/2016 17:00:46,备份,未知,Restore is complete on database 'CZLIS'. The database is now available.
06/28/2016 17:00:46,spid57,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 17:00:46,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 17:00:46,spid57,未知,The database 'CZLIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 17:00:46,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:51:01,备份,未知,Database was restored: Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> first LSN: 253309:297:39<c/> last LSN: 253309:313:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_23_193001_2031250.bak'}). Informational message. No user action required.
06/28/2016 16:51:01,备份,未知,Restore is complete on database 'CZCIS'. The database is now available.
06/28/2016 16:51:01,spid57,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:51:00,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 16:51:00,spid57,未知,The database 'CZCIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 16:51:00,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 16:50:30,备份,未知,Database was restored: Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> first LSN: 137392:124:37<c/> last LSN: 137392:140:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_23_193001_2031250.bak'}). Informational message. No user action required.
06/28/2016 16:50:30,备份,未知,Restore is complete on database 'CZLIS'. The database is now available.
06/28/2016 16:50:30,spid57,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:50:30,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:50:29,spid57,未知,The database 'CZLIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 16:50:29,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:50:00,spid53,未知,Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:50:00,spid53,未知,Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:50:00,spid53,未知,Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid7s,未知,Recovery is complete. This is an informational message only. No user action is required.
06/28/2016 16:49:59,spid23s,未知,CHECKDB for database 'ZKLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:58,spid22s,未知,CHECKDB for database 'JZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:53,spid24s,未知,CHECKDB for database 'ZoneKingNet' finished without errors on 2013-04-20 12:00:49.700 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:51,spid21s,未知,CHECKDB for database 'EIS' finished without errors on 2013-04-20 12:00:13.843 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:50,spid20s,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:49,spid25s,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:49,spid20s,未知,Starting up database 'CZLIS'.
06/28/2016 16:49:48,spid25s,未知,Starting up database 'CZCIS'.
06/28/2016 16:49:48,spid24s,未知,Starting up database 'ZoneKingNet'.
06/28/2016 16:49:48,spid23s,未知,Starting up database 'ZKLIS'.
06/28/2016 16:49:48,spid22s,未知,Starting up database 'JZCIS'.
06/28/2016 16:49:48,spid21s,未知,Starting up database 'EIS'.
06/28/2016 16:49:48,spid20s,未知,Starting up database 'ReportServerTempDB'.
06/28/2016 16:49:48,spid19s,未知,Starting up database 'ReportServer'.
06/28/2016 16:49:48,spid13s,未知,Starting up database 'msdb'.
06/28/2016 16:49:48,spid13s,未知,A new instance of the full-text filter daemon host process has been successfully started.
06/28/2016 16:49:48,spid14s,未知,Service Broker manager has started.
06/28/2016 16:49:48,spid14s,未知,The Database Mirroring protocol transport is disabled or not configured.
06/28/2016 16:49:48,spid14s,未知,The Service Broker protocol transport is disabled or not configured.
06/28/2016 16:49:48,spid10s,未知,Starting up database 'tempdb'.
06/28/2016 16:49:48,服务器,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.
06/28/2016 16:49:48,服务器,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b<c/> state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
06/28/2016 16:49:48,服务器,未知,Dedicated admin connection support was established for listening locally on port 1434.
06/28/2016 16:49:48,服务器,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].
06/28/2016 16:49:48,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
06/28/2016 16:49:48,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
06/28/2016 16:49:48,服务器,未知,Server is listening on [ 'any' <ipv4> 1433].
06/28/2016 16:49:48,服务器,未知,A self-generated certificate was successfully loaded for encryption.
06/28/2016 16:49:48,spid10s,未知,Clearing tempdb database.
06/28/2016 16:49:48,spid7s,未知,Server name is 'KANGQIAO-FWQ'. This is an informational message only. No user action is required.
06/28/2016 16:49:48,spid10s,未知,Starting up database 'model'.
06/28/2016 16:49:48,spid7s,未知,The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\JZCIS\JZCIS_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
06/28/2016 17:20:03,备份,未知,Database backed up. Database: EIS<c/> creation date(time): 2016/06/21(17:52:48)<c/> pages dumped: 7574<c/> first LSN: 17952:2112:37<c/> last LSN: 17952:2128:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'E:\backup-PM\EIS\EIS_backup_2016_06_28_172000_8125000.bak'}). This is an informational message only. No user action is required.
06/28/2016 17:01:16,备份,未知,Database was restored: Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> first LSN: 253308:341:39<c/> last LSN: 253308:357:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\ZKPACS_DATA\DB\CZCIS_backup_2016_06_21_193004_7031250.bak'}). Informational message. No user action required.
06/28/2016 17:01:16,备份,未知,Restore is complete on database 'CZCIS'. The database is now available.
06/28/2016 17:01:16,spid57,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 17:01:16,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 17:01:15,spid57,未知,The database 'CZCIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 17:01:15,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 17:00:46,备份,未知,Database was restored: Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> first LSN: 137391:206:37<c/> last LSN: 137391:222:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\ZKPACS_DATA\DB\CZLIS_backup_2016_06_21_193004_7031250.bak'}). Informational message. No user action required.
06/28/2016 17:00:46,备份,未知,Restore is complete on database 'CZLIS'. The database is now available.
06/28/2016 17:00:46,spid57,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 17:00:46,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 17:00:46,spid57,未知,The database 'CZLIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 17:00:46,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:51:01,备份,未知,Database was restored: Database: CZCIS<c/> creation date(time): 2016/02/26(15:20:06)<c/> first LSN: 253309:297:39<c/> last LSN: 253309:313:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZCIS\CZCIS_backup_2016_06_23_193001_2031250.bak'}). Informational message. No user action required.
06/28/2016 16:51:01,备份,未知,Restore is complete on database 'CZCIS'. The database is now available.
06/28/2016 16:51:01,spid57,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:51:00,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 16:51:00,spid57,未知,The database 'CZCIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 16:51:00,spid57,未知,Starting up database 'CZCIS'.
06/28/2016 16:50:30,备份,未知,Database was restored: Database: CZLIS<c/> creation date(time): 2016/02/26(15:20:42)<c/> first LSN: 137392:124:37<c/> last LSN: 137392:140:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\CZZK_LS\CZLIS\CZLIS_backup_2016_06_23_193001_2031250.bak'}). Informational message. No user action required.
06/28/2016 16:50:30,备份,未知,Restore is complete on database 'CZLIS'. The database is now available.
06/28/2016 16:50:30,spid57,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:50:30,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:50:29,spid57,未知,The database 'CZLIS' is marked RESTORING and is in a state that does not allow recovery to be run.
06/28/2016 16:50:29,spid57,未知,Starting up database 'CZLIS'.
06/28/2016 16:50:00,spid53,未知,Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:50:00,spid53,未知,Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:50:00,spid53,未知,Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
06/28/2016 16:50:00,spid53,未知,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid53,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/28/2016 16:49:59,spid53,未知,Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
06/28/2016 16:49:59,spid7s,未知,Recovery is complete. This is an informational message only. No user action is required.
06/28/2016 16:49:59,spid23s,未知,CHECKDB for database 'ZKLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:58,spid22s,未知,CHECKDB for database 'JZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:53,spid24s,未知,CHECKDB for database 'ZoneKingNet' finished without errors on 2013-04-20 12:00:49.700 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:51,spid21s,未知,CHECKDB for database 'EIS' finished without errors on 2013-04-20 12:00:13.843 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:50,spid20s,未知,CHECKDB for database 'CZLIS' finished without errors on 2013-04-20 12:00:43.357 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:49,spid25s,未知,CHECKDB for database 'CZCIS' finished without errors on 2013-04-20 12:00:15.247 (local time). This is an informational message only; no user action is required.
06/28/2016 16:49:49,spid20s,未知,Starting up database 'CZLIS'.
06/28/2016 16:49:48,spid25s,未知,Starting up database 'CZCIS'.
06/28/2016 16:49:48,spid24s,未知,Starting up database 'ZoneKingNet'.
06/28/2016 16:49:48,spid23s,未知,Starting up database 'ZKLIS'.
06/28/2016 16:49:48,spid22s,未知,Starting up database 'JZCIS'.
06/28/2016 16:49:48,spid21s,未知,Starting up database 'EIS'.
06/28/2016 16:49:48,spid20s,未知,Starting up database 'ReportServerTempDB'.
06/28/2016 16:49:48,spid19s,未知,Starting up database 'ReportServer'.
06/28/2016 16:49:48,spid13s,未知,Starting up database 'msdb'.
06/28/2016 16:49:48,spid13s,未知,A new instance of the full-text filter daemon host process has been successfully started.
06/28/2016 16:49:48,spid14s,未知,Service Broker manager has started.
06/28/2016 16:49:48,spid14s,未知,The Database Mirroring protocol transport is disabled or not configured.
06/28/2016 16:49:48,spid14s,未知,The Service Broker protocol transport is disabled or not configured.
06/28/2016 16:49:48,spid10s,未知,Starting up database 'tempdb'.
06/28/2016 16:49:48,服务器,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.
06/28/2016 16:49:48,服务器,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b<c/> state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
06/28/2016 16:49:48,服务器,未知,Dedicated admin connection support was established for listening locally on port 1434.
06/28/2016 16:49:48,服务器,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].
06/28/2016 16:49:48,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
06/28/2016 16:49:48,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
06/28/2016 16:49:48,服务器,未知,Server is listening on [ 'any' <ipv4> 1433].
06/28/2016 16:49:48,服务器,未知,A self-generated certificate was successfully loaded for encryption.
06/28/2016 16:49:48,spid10s,未知,Clearing tempdb database.
06/28/2016 16:49:48,spid7s,未知,Server name is 'KANGQIAO-FWQ'. This is an informational message only. No user action is required.
06/28/2016 16:49:48,spid10s,未知,Starting up database 'model'.
06/28/2016 16:49:48,spid7s,未知,The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
#6
直接看下你执行计划失败的的详细信息！
#7
磁盘空间不足
#8
提示磁盘空间不足啊，看下服务器的硬盘是不是不够
#9
C盘存储数据库文件的磁盘空间还有60G，这个值足够使用了，可是还是会报错。
#10
06/28/2016 17:20:03,spid61,未知,Extend Disk Backup: failure on backup device 'E:\backup-PM\JZCIS\JZCIS_backup_2016_06_28_172000_8125000.bak'. Operating system error 112(磁盘空间不足。).
06/28/2016 17:20:03,spid61,未知,错误: 18210，严重性: 16，状态: 1。
E盘看看。
#11
ZKLIS,JZCIS,EIS这些数据库文件所在磁盘分区(未必都在C盘,请确认)的剩余空间不足,
建议一次只处理一个数据库,不要所有数据库一起做索引维护,对磁盘压力太大.
建议一次只处理一个数据库,不要所有数据库一起做索引维护,对磁盘压力太大.
#12
查看错误的详细信息，上面都提示磁盘空间不足了。
#13
请排查数据库文件所在磁盘的空间，看是否有足够的空间。。。。。。。。。。。。。
#14
每个盘子最少还有60G的空间
#15
当前有60G不代表维护计划运行时也有60G喔,
维护计划对磁盘空间冲击比较大,所以建议一次只处理一个数据库,不要所有数据库一起做索引维护,对磁盘压力太大.
#16
好了，谢谢各位，5G数据还是没法重新生成索引，不过删除几万条数据后没有问题了。