What are mdf,ndf,ldf files and how to see the data in those
files?
Answer Posted / visala
.mdf is extention of primary file,
.ndf is extention of secondary file,
.ldf is extention of log file,
sp_helpfile
Is This Answer Correct ? | 116 Yes | 10 No |
Post New Answer View All Answers
Which trace flags are enabled in sql server?
how can you check the level of fragmentation on a table? : Sql server administration
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
Can we take the full database backup in log shipping?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What are the kinds of subquery?
How to get the query of a table in sql server?
How do I completely remove sql server instance?
What is the concept of optimization?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
How to update values in a table with update statements in ms sql server?
What happens if null values are involved in string operations?
Can we perform backup restore operation on tempdb? : sql server database administration
How to create function without parameter in sql server?
Where are sql server usernames and passwords stored in the sql server?