Bread and Butter of SQL Server DBA

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by MAK » Bread and Butter of SQL Server DBA - Part 2

Bread and Butter of SQL Server DBA - Part 2

Rate Topic

Display Mode

Topic Options

Author

Message

MAK9974

Posted Tuesday, September 30, 2008 12:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 03, 2011 7:49 AM
Points: 8, Visits: 69

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

Post #578095

Kumar-386306

Posted Tuesday, September 30, 2008 2:55 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:10 AM
Points: 232, Visits: 242

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

Post #578137

Anipaul

Posted Tuesday, September 30, 2008 4:53 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,815, Visits: 1,343

Good series in making....

Post #578182

daft

Posted Tuesday, September 30, 2008 5:31 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:29 AM
Points: 58, Visits: 151

Good article, thanks

Post #578198

kp_kumar

Posted Tuesday, September 30, 2008 11:27 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 5:23 PM
Points: 36, Visits: 848

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

Post #578508

Kumar-386306

Posted Wednesday, October 01, 2008 1:23 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:10 AM
Points: 232, Visits: 242

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

Post #578886

MAK9974

Posted Wednesday, October 01, 2008 1:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 03, 2011 7:49 AM
Points: 8, Visits: 69

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.

Post #578888

SanjayAttray

Posted Wednesday, October 01, 2008 9:45 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

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.

Post #579191

« Prev Topic | Next Topic »

Permissions