how many files will be there in .bak file of a database and how to find out that? is it that to use RESTORE WITH HEARDERS ONLY or something different?
When you take
backup by default option you just create one backup file even though your database might have N number of data and log files.And all data and log file information would be present in the backup. You can take backup on multiple drives as well.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.