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?
- 1 Answers
- 1253 Views
- I also Faced
- E-Mail Answers
Answer Posted / Md Hasan Ahmad
A SQL Server database can contain multiple files, including primary data files (.mdf), secondary data files (.ndf), and log files (.ldf). A single database can have one primary data file but an unlimited number of secondary data files. It must have at least one primary data file and one log file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is temporary table in sql server? Why we use temp table?
What are the kinds of subquery?
Where can you add custom error messages to sql server?
How raid can influence database performance?
what is the difference between openrowset and openquery?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Can we do dml on views?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are different types of constraints?
How to convert character strings into numeric values?
How do I find the sql server version?
Why should you use or avoid select * statements?
Disadvantages of the indexes?
Can you index views?
How to rebuild the master database?
