Answer Posted / rajesh naidu
ALTER SYSTEM SWITCH LOGFILE BY THIS WAY U CAN FORCE TO LOG
SWITCH
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how to restore files with rman?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is replication? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
how can you initialize log miner?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Can you redefine a table online?
What is a system database and what is a user database? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?