Question : I’m working on defining specs for a new server to run DBCC CHECKDB scans on all databases in […]
Tag: dbcc
DBCC CheckDB space requirements?
Question : Ran into the following error… K:Microsoft SQL ServerDataMyAudit3_Dat.NDF_MSSQL_DBCC50: Operating system error 112(There is not enough space on the […]
DBCC Shrinkfile after full backup restoration but before differential restoration
Question : My database full backup file size is 760 GB and differential would be around 20 GB but the […]
Definitive list of steps for SQL Server baseline testing?
Question : Before running a performance test / baseline for an app that uses SQL Server, I want to be […]
Log File Size and dbcc sqlperf (logspace)
Question : Consider the following log file setting for a database named XYZ: Initial size = 250MB, Autogrowth by 500MB, […]
DBCC CHECKDB WITH DATA_PURITY gives out of range error
Question : I have restore a SQL Server 2000 database onto SQL Server 2005 and then run DBCC CHECKDB WITH […]
Database consistency checker in postgresql
Question : Are there any DBCC(Database consistency checker) commands in PostgreSQL? I could find SQL server DBCC commands but not […]
DBCC Shrinkfile after full backup restoration but before differential restoration
Question : My database full backup file size is 760 GB and differential would be around 20 GB but the […]
What are the downsides of running DBCC FREESYSTEMCACHE (‘TokenAndPermUserStore’) hourly?
Question : I have been seeing some concerning behavior in the SQL Server memory caches on one of our production […]
To ‘DBCC SHRINKDATABASE’ or Not To ‘DBCC SHRINKDATABASE’: That’s the question
Question : We’re freeing lots of space in a SQL Server 2008 R2 database -a Loooot! enough to care about- […]