|
B*********L
发帖数: 700 | 2 I run this command:
DBCC CHECKDB WITH NO_INFOMSGS
It cause tempdb full.
Is there a way to prevent that?
Thanks. |
|
z***y
发帖数: 7151 | 3 dbcc checkdb use hell of space on tempdb. Don't know if there's way you can
change this. |
|
j*****n
发帖数: 1781 | 4 It depends what's your major concern that you want to run this CHECKDB
command. Can you describe in more detail?
For example, if the major concern is about the consistency of disk space
allocation structures, actually you may think only use the DBCC CHECKALLOC
instead.
Again, BOL is the best resource for reference. |
|
z***y
发帖数: 7151 | 5 An company did the following in order to migration database from old server
to new server:
1. On old server, detach all users databases.
2. Then detach SAN from old server.
3. On new server, attach this SAN.
4. Then run script to attach databases.
Around 4:00AM today, they started getting memory dump every a few minutes.
Error Message:
SQL Server Assertion: File: , line = 385 Failed Assertion = '0'
Too many parallel nested transactions. This error may be timing-related. If
the error ... 阅读全帖 |
|
g***l
发帖数: 18555 | 6 attach了还要DBCC CHECKDB之类的吧，是2008 ENTRERPISE R2吗？ |
|
c*****d
发帖数: 6045 | 7 你的意思是说有这个一个database_A
use [master]
select * from sys.master_files
where database_id = DB_ID ('database_A');
GO
use [database_A]
select * from sys.database_files;
GO
然后返回的结果中log file的名字不同
是这样吗？
dbcc checkdb返回什么错误
你试过哪种方法去shrink logfile
dbcc shrinkfile (file_id）
or
dbcc shrinkfile (file_name)
提问的时候尽量把问题说清楚，全面一些
否则别人没法回答你的问题 |
|
B*********L
发帖数: 700 | 8 谢谢,就是您说的这种情况.
我run"dbcc checkdb" 没有错误
dbcc shrinkfile (file_id）works (问题解决了一半,谢谢!)
dbcc shrinkfile (name from sys.master_files) works
dbcc shrinkfile (name from sys.database_files) doesn't work
我用maintenance plans的wizard,生成了一个plan,去check database integrity.
结果Job fail: Alter failed for Server 'xxxx'. |
|
