DBCC results for 'Port002'.
DBCC results for 'sysobjects'.
There are 329 rows in 6 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 243 rows in 9 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1324 rows in 19 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 24 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 301 rows in 18 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 55 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 14 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysdepends'.
There are 245 rows in 1 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'sysallocations'.
There are 1 rows in 1 pages for object 'sysallocations'.
DBCC results for 'tmpPWOCstDir11'.
There are 276 rows in 6 pages for object 'tmpPWOCstDir11'.
DBCC results for 'tmpPWOCstPaper11'.
There are 276 rows in 5 pages for object 'tmpPWOCstPaper11'.
DBCC results for 'PDAllPub'.
There are 0 rows in 1 pages for object 'PDAllPub'.
DBCC results for 'PDOChange'.
There are 0 rows in 1 pages for object 'PDOChange'.
DBCC results for 'PDOCstCom'.
There are 0 rows in 1 pages for object 'PDOCstCom'.
DBCC results for 'PDOCstComChg'.
There are 0 rows in 1 pages for object 'PDOCstComChg'.
DBCC results for 'PDOCstDir'.
There are 5029 rows in 154 pages for object 'PDOCstDir'.
DBCC results for 'PDOCstDirChg'.
There are 69944 rows in 1918 pages for object 'PDOCstDirChg'.
DBCC results for 'PDOCstFam'.
There are 0 rows in 1 pages for object 'PDOCstFam'.
DBCC results for 'PDOCstFamChg'.
There are 0 rows in 1 pages for object 'PDOCstFamChg'.
DBCC results for '(User ID 6).pwocstdmonitor'.
There are 948 rows in 20 pages for object '(User ID 6).pwocstdmonitor'.
DBCC results for 'PDOCstPaper'.
There are 17235 rows in 317 pages for object 'PDOCstPaper'.
DBCC results for 'PDOCstPaperChg'.
There are 121290 rows in 2492 pages for object 'PDOCstPaperChg'.
DBCC results for 'ptpagetype'.
There are 0 rows in 1 pages for object 'ptpagetype'.
DBCC results for 'PDPortPub'.
There are 0 rows in 1 pages for object 'PDPortPub'.
DBCC results for 'ptpcopty'.
There are 0 rows in 1 pages for object 'ptpcopty'.
DBCC results for 'PDRAskDoc'.
There are 7542 rows in 130 pages for object 'PDRAskDoc'.
DBCC results for 'ptpcosize'.
There are 0 rows in 1 pages for object 'ptpcosize'.
DBCC results for 'PDRPlan'.
There are 2232 rows in 43 pages for object 'PDRPlan'.
DBCC results for 'ptpmailbox'.
There are 37 rows in 1 pages for object 'ptpmailbox'.
DBCC results for 'PDRRevCash'.
There are 1431 rows in 20 pages for object 'PDRRevCash'.
DBCC results for 'ptppaperpack'.
There are 49 rows in 1 pages for object 'ptppaperpack'.
DBCC results for 'PDSendSitePub'.
There are 0 rows in 1 pages for object 'PDSendSitePub'.
DBCC results for 'pTpComtype'.
There are 0 rows in 1 pages for object 'pTpComtype'.
DBCC results for 'ptpportroleperm'.
There are 1 rows in 1 pages for object 'ptpportroleperm'.
DBCC results for 'PTpDuty'.
There are 0 rows in 1 pages for object 'PTpDuty'.
DBCC results for 'PTpEducation'.
There are 0 rows in 1 pages for object 'PTpEducation'.
DBCC results for 'ptpywy'.
There are 138 rows in 3 pages for object 'ptpywy'.
DBCC results for 'PTpLinkInfo'.
There are 1 rows in 1 pages for object 'PTpLinkInfo'.
DBCC results for 'PTpLoginUsers'.
There are 3 rows in 1 pages for object 'PTpLoginUsers'.
DBCC results for 'pwocstarrear'.
There are 2989 rows in 73 pages for object 'pwocstarrear'.
DBCC results for 'sysobjects'.
There are 329 rows in 6 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 243 rows in 9 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1324 rows in 19 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 24 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 301 rows in 18 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 55 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 14 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysdepends'.
There are 245 rows in 1 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'sysallocations'.
There are 1 rows in 1 pages for object 'sysallocations'.
DBCC results for 'tmpPWOCstDir11'.
There are 276 rows in 6 pages for object 'tmpPWOCstDir11'.
DBCC results for 'tmpPWOCstPaper11'.
There are 276 rows in 5 pages for object 'tmpPWOCstPaper11'.
DBCC results for 'PDAllPub'.
There are 0 rows in 1 pages for object 'PDAllPub'.
DBCC results for 'PDOChange'.
There are 0 rows in 1 pages for object 'PDOChange'.
DBCC results for 'PDOCstCom'.
There are 0 rows in 1 pages for object 'PDOCstCom'.
DBCC results for 'PDOCstComChg'.
There are 0 rows in 1 pages for object 'PDOCstComChg'.
DBCC results for 'PDOCstDir'.
There are 5029 rows in 154 pages for object 'PDOCstDir'.
DBCC results for 'PDOCstDirChg'.
There are 69944 rows in 1918 pages for object 'PDOCstDirChg'.
DBCC results for 'PDOCstFam'.
There are 0 rows in 1 pages for object 'PDOCstFam'.
DBCC results for 'PDOCstFamChg'.
There are 0 rows in 1 pages for object 'PDOCstFamChg'.
DBCC results for '(User ID 6).pwocstdmonitor'.
There are 948 rows in 20 pages for object '(User ID 6).pwocstdmonitor'.
DBCC results for 'PDOCstPaper'.
There are 17235 rows in 317 pages for object 'PDOCstPaper'.
DBCC results for 'PDOCstPaperChg'.
There are 121290 rows in 2492 pages for object 'PDOCstPaperChg'.
DBCC results for 'ptpagetype'.
There are 0 rows in 1 pages for object 'ptpagetype'.
DBCC results for 'PDPortPub'.
There are 0 rows in 1 pages for object 'PDPortPub'.
DBCC results for 'ptpcopty'.
There are 0 rows in 1 pages for object 'ptpcopty'.
DBCC results for 'PDRAskDoc'.
There are 7542 rows in 130 pages for object 'PDRAskDoc'.
DBCC results for 'ptpcosize'.
There are 0 rows in 1 pages for object 'ptpcosize'.
DBCC results for 'PDRPlan'.
There are 2232 rows in 43 pages for object 'PDRPlan'.
DBCC results for 'ptpmailbox'.
There are 37 rows in 1 pages for object 'ptpmailbox'.
DBCC results for 'PDRRevCash'.
There are 1431 rows in 20 pages for object 'PDRRevCash'.
DBCC results for 'ptppaperpack'.
There are 49 rows in 1 pages for object 'ptppaperpack'.
DBCC results for 'PDSendSitePub'.
There are 0 rows in 1 pages for object 'PDSendSitePub'.
DBCC results for 'pTpComtype'.
There are 0 rows in 1 pages for object 'pTpComtype'.
DBCC results for 'ptpportroleperm'.
There are 1 rows in 1 pages for object 'ptpportroleperm'.
DBCC results for 'PTpDuty'.
There are 0 rows in 1 pages for object 'PTpDuty'.
DBCC results for 'PTpEducation'.
There are 0 rows in 1 pages for object 'PTpEducation'.
DBCC results for 'ptpywy'.
There are 138 rows in 3 pages for object 'ptpywy'.
DBCC results for 'PTpLinkInfo'.
There are 1 rows in 1 pages for object 'PTpLinkInfo'.
DBCC results for 'PTpLoginUsers'.
There are 3 rows in 1 pages for object 'PTpLoginUsers'.
DBCC results for 'pwocstarrear'.
There are 2989 rows in 73 pages for object 'pwocstarrear'.
DBCC results for 'sysobjects'.
There are 329 rows in 6 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 243 rows in 9 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1324 rows in 19 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 24 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 301 rows in 18 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 55 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 14 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysdepends'.
There are 245 rows in 1 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'sysallocations'.
There are 1 rows in 1 pages for object 'sysallocations'.
DBCC results for 'tmpPWOCstDir11'.
There are 276 rows in 6 pages for object 'tmpPWOCstDir11'.
DBCC results for 'tmpPWOCstPaper11'.
There are 276 rows in 5 pages for object 'tmpPWOCstPaper11'.
DBCC results for 'PDAllPub'.
There are 0 rows in 1 pages for object 'PDAllPub'.
DBCC results for 'PDOChange'.
There are 0 rows in 1 pages for object 'PDOChange'.
DBCC results for 'PDOCstCom'.
There are 0 rows in 1 pages for object 'PDOCstCom'.
DBCC results for 'PDOCstComChg'.
There are 0 rows in 1 pages for object 'PDOCstComChg'.
DBCC results for 'PDOCstDir'.
There are 5029 rows in 154 pages for object 'PDOCstDir'.
DBCC results for 'PDOCstDirChg'.
There are 69944 rows in 1918 pages for object 'PDOCstDirChg'.
DBCC results for 'PDOCstFam'.
There are 0 rows in 1 pages for object 'PDOCstFam'.
DBCC results for 'PDOCstFamChg'.
There are 0 rows in 1 pages for object 'PDOCstFamChg'.
DBCC results for '(User ID 6).pwocstdmonitor'.
There are 948 rows in 20 pages for object '(User ID 6).pwocstdmonitor'.
DBCC results for 'PDOCstPaper'.
There are 17235 rows in 317 pages for object 'PDOCstPaper'.
DBCC results for 'PDOCstPaperChg'.
There are 121290 rows in 2492 pages for object 'PDOCstPaperChg'.
DBCC results for 'ptpagetype'.
There are 0 rows in 1 pages for object 'ptpagetype'.
DBCC results for 'PDPortPub'.
There are 0 rows in 1 pages for object 'PDPortPub'.
DBCC results for 'ptpcopty'.
There are 0 rows in 1 pages for object 'ptpcopty'.
DBCC results for 'PDRAskDoc'.
There are 7542 rows in 130 pages for object 'PDRAskDoc'.
DBCC results for 'ptpcosize'.
There are 0 rows in 1 pages for object 'ptpcosize'.
DBCC results for 'PDRPlan'.
There are 2232 rows in 43 pages for object 'PDRPlan'.
DBCC results for 'ptpmailbox'.
There are 37 rows in 1 pages for object 'ptpmailbox'.
DBCC results for 'PDRRevCash'.
There are 1431 rows in 20 pages for object 'PDRRevCash'.
DBCC results for 'ptppaperpack'.
There are 49 rows in 1 pages for object 'ptppaperpack'.
DBCC results for 'PDSendSitePub'.
There are 0 rows in 1 pages for object 'PDSendSitePub'.
DBCC results for 'pTpComtype'.
There are 0 rows in 1 pages for object 'pTpComtype'.
DBCC results for 'ptpportroleperm'.
There are 1 rows in 1 pages for object 'ptpportroleperm'.
DBCC results for 'PTpDuty'.
There are 0 rows in 1 pages for object 'PTpDuty'.
DBCC results for 'PTpEducation'.
There are 0 rows in 1 pages for object 'PTpEducation'.
DBCC results for 'ptpywy'.
There are 138 rows in 3 pages for object 'ptpywy'.
DBCC results for 'PTpLinkInfo'.
There are 1 rows in 1 pages for object 'PTpLinkInfo'.
DBCC results for 'PTpLoginUsers'.
There are 3 rows in 1 pages for object 'PTpLoginUsers'.
DBCC results for 'pwocstarrear'.
There are 2989 rows in 73 pages for object 'pwocstarrear'.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'Port002'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.我真的不知道改咋整了
用 ALTER DATABASE 向数据库添加一个数据文件或日志文件。
停止并重新启动 SQL Server。
用新的数据文件或日志文件所提供的额外空间,SQL Server 应该能完成数据库的恢复。释放磁盘空间并且重新运行恢复操作。
sp_resetstatus 关闭数据库的置疑标志,但是原封不动地保持数据库的其它选项。注意 只有在您的主要支持提供者指导下或有疑难解答建议的做法时,才可以使用 sp_resetstatus。否则,可能会损坏数据库。
由于该过程修改了系统表,系统管理员必须在创建这个过程前,启用系统表更新。要启用更新,使用下面的过程:USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO过程创建后,立即禁用系统表更新:sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO只有系统管理员才能执行 sp_resetstatus。执行该过程后,立即关闭 SQL Server。语法为:sp_resetstatus database_name下面的例子将关闭 PRODUCTION 数据库的置疑标志。sp_resetstatus PRODUCTION
我没用过这条命令,给个参考好吗?我重置数据库的状态了,没效果