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 |
How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?
What is policy based management (pbm)? : sql server database administration
Explain the microsoft sql server delete command?
What are the different ways you can create databases in sql server?
Do you know how to make remote connection in database?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
How to return the top 5 rows from a select query in ms sql server?
How do I completely remove sql server instance?
Can we use Truncate command on a table which is referenced by FOREIGN KEY?
What do you mean by a dependent functionality in a build?
How to truncate the log in sql server 2012? : sql server database administration
How sql server executes a statement with nested subqueries?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)