Where the sql logs gets stored?



Where the sql logs gets stored?..

Answer / Aarti Katyal

The SQL Server log files are typically stored in the data folder of the database instance. The exact location depends on the installation settings, but by default, it is under <drive>:Program FilesMicrosoft SQL ServerMSSQL13.SQL2016MSSQLDataLog.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

how to do partition in sqlserver

1 Answers   TCS,


Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,


What is checkpoint process in the sql server?

1 Answers  


what is the difference between table and view

1 Answers  


Define self join?

1 Answers  


How to create a simple table to test triggers in ms sql server?

1 Answers  


explain different types of backups avaialabe in sql server? : Sql server database administration

1 Answers  


What Are Three Rules to UseĀ UNION IN SQL SERVER

1 Answers  


What is create statement?

1 Answers  


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1 Answers   HCL,


What is ems sql management studio? : sql server management studio

1 Answers  


How you would rewrite the sql query to return the customerid sorted numerically?

1 Answers  


Categories