Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Bread and Butter of SQL Server DBA - Part 2 Expand / Collapse
Author
Message
Posted Tuesday, September 30, 2008 12:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 23, 2013 10:22 AM
Points: 8, Visits: 76
Comments posted to this topic are about the item Bread and Butter of SQL Server DBA - Part 2


Post #578095
Posted Tuesday, September 30, 2008 2:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 26, 2013 3:12 AM
Points: 233, Visits: 246
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
Posted Tuesday, September 30, 2008 4:53 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 20, 2014 7:32 AM
Points: 5,198, Visits: 1,368
Good series in making....


Post #578182
Posted Tuesday, September 30, 2008 5:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 09, 2013 3:40 AM
Points: 58, Visits: 153
Good article, thanks
Post #578198
Posted Tuesday, September 30, 2008 11:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 1:47 PM
Points: 36, Visits: 898
I like the step by step approach for learners...




Post #578508
Posted Wednesday, October 01, 2008 1:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 26, 2013 3:12 AM
Points: 233, Visits: 246
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
Posted Wednesday, October 01, 2008 1:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 23, 2013 10:22 AM
Points: 8, Visits: 76
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
Posted Wednesday, October 01, 2008 9:45 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 7:03 AM
Points: 3,924, Visits: 1,589
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 »

Add to briefcase

Permissions Expand / Collapse