Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between dbcc checkstorage and other
dbcc commands
- 2 Answers
- 11751 Views
- I also Faced
- E-Mail Answers
Answer Posted / jayakumar
1.dbcc checkstorage runs checks against the database on
disk. If a corruption is only in memory, dbcc checkstorage
may not detect the corruption. To ensure consistency
between two dbcc checkstorage runs, run checkpoint before
running dbcc checkstorage. However, doing so can turn a
transient memory corruption into corruption on disk.
2.dbcc checkstorage checks the entire database, including
unused pages, so execution time is relative to database
size. Therefore, when you use dbcc checkstorage, there is
not a large difference between checking a database that is
nearly empty and checking one that is nearly full, as there
is with the other dbcc commands.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
A single operation is failing to escalate?
What is ceiling()?
Differentiate between db-lib and ct-lib?
For synchronizing the logins from lower version to higher version, just take the 11.9.2 syslogins structure, go to 12.5 higher version server?
What happen when we delete the table using trigger?
How do I remove duplicate rows from a table in sybase?
How to swap a db device with another?
Explain defncopy and it's usage?
How do you check database space? What measures are there to increase the db space?
Explain data cache?
How do I tell which tables have identities in sybase?
What is the use of sp_helprotect in sybase?
How do I turn off marked suspect on my database in sybase?
You need to remove the affected rows and dashes. How would you do that?
Explain about the sybase group?
