Post reply

Bread and Butter of SQL Server DBA - Part 2

  • September 30, 2008 at 12:26 am

    #213332

    Comments posted to this topic are about the item Bread and Butter of SQL Server DBA - Part 2

  • September 30, 2008 at 2:55 am

    #878717

    Hi,

    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.

    Regards

    Kumar

  • September 30, 2008 at 4:53 am

    #878751

    Good series in making....

  • September 30, 2008 at 5:31 am

    #878764

    Good article, thanks

  • September 30, 2008 at 11:27 am

    #879023

    I like the step by step approach for learners...

  • October 1, 2008 at 1:23 am

    #879335

    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 it

    Regards

    Kumar

  • October 1, 2008 at 1:29 am

    #879336

    you 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.

  • October 1, 2008 at 9:45 am

    #879587

    Kumar (10/1/2008)

    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 it

    Regards

    Kumar

    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.

    SQL DBA.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply