How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
- 1 Answers
- 1303 Views
- I also Faced
- E-Mail Answers
Answer Posted / Digvendra Singh
A SQL Server database can have multiple files. There are two main types of data files in SQL Server: Data Files (.mdf) and Log Files (.ldf). One database can have one primary data file (.mdf) and as many secondary data files (.ndf) as necessary.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
