alter system switch logfile Regards Abhinav Phadnis

How would you force a log switch?

Question Posted / guest

Answer Posted / guest

alter system switch logfile

Regards
Abhinav Phadnis

Is This Answer Correct ?

19 Yes

2 No

Please Help Members By Posting Answers For Below Questions

how can you schedule a job in database?

597

internal architecture

1755

What is transparent data encryption? : sql server DBA

564

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

548

how can you initialize log miner?

577

What are the commands used in dcl? : sql server DBA

579

What is the default port no on which sql server listens? : sql server DBA

558

what is the role of dip user in our database?

2051

how can you enable flashback feature?

536

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

560

when does an alert gets signaled?

580

Can you redefine a table online?

669

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

564

What is dbcc? : sql server DBA

777

How can you control the amount of free space in your index pages? : sql server DBA

735