SQL Database Concepts Question: Download Questions PDF
Explain the rules for designing Files and File groups in SQL Server?
Answer:
A file or file group can only be used by one database. For example, the files abc.mdf and abc.ndf contains data and objects for abc database, cannot be used by any other database.
A file can be a member of only one file group.
Data and transaction log information cannot be part of the same file or file group.
Transaction log files can't be part of a file group.
A file can be a member of only one file group.
Data and transaction log information cannot be part of the same file or file group.
Transaction log files can't be part of a file group.
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell me what is log shipping? | Tell me what is SQL Profiler? |