What do you understand by physical_only option in dbcc checkdb?



What do you understand by physical_only option in dbcc checkdb?..

Answer / Reshu Agarwal

The PHYSICAL_ONLY option in DBCC CHECKDB performs a physical-level check of the database without performing any logical checks. This option is used for comparing two databases at a physical level, such as after restoring a backup or replicating data between databases. It is not meant for regular database health checks.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,


What is policy based management (pbm)? : sql server database administration

1 Answers  


Explain the microsoft sql server delete command?

1 Answers  


What are the different ways you can create databases in sql server?

1 Answers  


Do you know how to make remote connection in database?

1 Answers  


Issues related in upgrading SQL Server 2000 to 2005 / 2008

1 Answers  


How to return the top 5 rows from a select query in ms sql server?

1 Answers  


How do I completely remove sql server instance?

1 Answers  


Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,


What do you mean by a dependent functionality in a build?

1 Answers   HCL,


How to truncate the log in sql server 2012? : sql server database administration

1 Answers  


How sql server executes a statement with nested subqueries?

1 Answers  


Categories