What are the reasons for the database to be in suspect state? 1) Data and Log files missing 2) Corruption of pages in the Data files. 3) Issues that are caused during Recovery/Restoring process 4) Disk level failures 5) SNA drives are missing
SQL Database in Suspect Mode What are the reasons for the database to be in suspect state? 1) Data and Log files missing 2) Corruption of pages in the Data files. 3) Issues that are caused during Recovery/Restoring process 4) Disk level failures 5) SNA...
SQL Memory issue Memory Issues It can be external or internal. Physical – External - Physical RAM may be low and SQL Server detects and reduce the commit charge of the buffer pool. Internal –Responding to external memory pressure Changed memory settings...
SQL ACID ACID properties When a transaction processing system creates a transaction, it will ensure that the transaction will have certain characteristics. The developers of the components that comprise the transaction are assured that these characteristics...
What are the Operating Modes and explain them? a. High Availability:- High-availability mode, runs synchronously. Requires a Witness Server instance. The Principal server sends the log buffer to the mirror server, and then waits for a response from the...
What is Hardening? As quickly as possible, the log buffer is written to the transaction log on disk, a process called hardening.
Prerequisites 1. Windows Server Failover Cluster (WSFC). 2. Quorum configuration using file sharing (Optional). 3. SQL Server 2012 Enterprise Edition. 4. Collation settings have to same on both the Nodes. 5. Two to Five servers acting as a Replica.
Question: I need an example of using the sqlldr (SQL*Loader) utility to load some data into my Oracle tables. Answer: The sqlldr utility has easy syntax, and here is a simple example in using SQL*Loader. Also see this sqlldr (SQL*Loader) example. Sqlldr...
1. How do you see how many instances are running? 2. How do you automate starting and shutting down of databases in Unix? 3. You have written a script to take backups. How do you make it run automatically every week? 4. What is OERR utility? 5. How do...
