SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by MAK / Bread and Butter of SQL Server DBA - Part 2 / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 15:00:01 GMT20RE: Bread and Butter of SQL Server DBA - Part 2http://www.sqlservercentral.com/Forums/Topic578095-1337-1.aspx[quote][b]Kumar (10/1/2008)[/b][hr]hi Mak,I'm too curious to know, how a single .bak file is listing 3 .mdf file. Have you just made any change to the screen shot of the picture?Let me know about itRegardsKumar[/quote]Kumar, instead of waiting hours for the answer from MAK, why not create a database with 3 mdf files and 2 log files and back it up and see the result. since database is empty it should not take more than 1 minute to back it up. It just takes less than 3 minutes to get answer.Do some R & D and you will get results instantly.Wed, 01 Oct 2008 09:45:40 GMTSanjayAttrayRE: Bread and Butter of SQL Server DBA - Part 2http://www.sqlservercentral.com/Forums/Topic578095-1337-1.aspxyou can create a database with 3 data file and 2 log file very easily. ".MDF" is just a file name extension. You can create a data file with .XYZ as extension.Wed, 01 Oct 2008 01:29:21 GMTMAK9974RE: Bread and Butter of SQL Server DBA - Part 2http://www.sqlservercentral.com/Forums/Topic578095-1337-1.aspxhi Mak,I'm too curious to know, how a single .bak file is listing 3 .mdf file. Have you just made any change to the screen shot of the picture?Let me know about itRegardsKumarWed, 01 Oct 2008 01:23:39 GMTKumar-386306RE: Bread and Butter of SQL Server DBA - Part 2http://www.sqlservercentral.com/Forums/Topic578095-1337-1.aspxI like the step by step approach for learners...Tue, 30 Sep 2008 11:27:13 GMTkp_kumarRE: Bread and Butter of SQL Server DBA - Part 2http://www.sqlservercentral.com/Forums/Topic578095-1337-1.aspxGood article, thanksTue, 30 Sep 2008 05:31:20 GMTdaftRE: Bread and Butter of SQL Server DBA - Part 2http://www.sqlservercentral.com/Forums/Topic578095-1337-1.aspxGood series in making....Tue, 30 Sep 2008 04:53:07 GMTAnipaulRE: Bread and Butter of SQL Server DBA - Part 2http://www.sqlservercentral.com/Forums/Topic578095-1337-1.aspxHi,I would to know, how do you get 3 .mdf files in a bak. Whether you will be able to create more than one .mdf file for a database or whether any changes has been made to the screen shot which is shown in the picture.Please clarify it.RegardsKumarTue, 30 Sep 2008 02:55:12 GMTKumar-386306Bread and Butter of SQL Server DBA - Part 2http://www.sqlservercentral.com/Forums/Topic578095-1337-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Backup+%2f+Restore/64353/">Bread and Butter of SQL Server DBA - Part 2</A>[/B]Tue, 30 Sep 2008 00:26:04 GMTMAK9974