Data Files (mdf)

Question

Data Files (mdf)

tmmutsetse

Hall of Fame

Points: 3669
More actions
February 13, 2018 at 7:41 am

#344039

Hi
Is it possible to combine two or three database mdf files to one file.
Thanks
February 19, 2018 at 5:47 am

This was removed by the editor as SPAM

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

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

Phil Parkin SSC Guru Points: 246965 More actions · Answer 1

tmmutsetse - Tuesday, February 13, 2018 7:41 AM
Hi
Is it possible to combine two or three database mdf files to one file.
Thanks

Yes. But once you've done that, nothing will be able to read the file.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 2

You can copy the data/tables from to your primary mdf file.

How? That depends on your current configuration.
If you post your databases DDL (create database statement) we may be able to point you a route.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Alexander Zhang Default port Points: 1497 More actions · Answer 3

For same DB and same filegroup, you can DBCC SHRINKFILE with EMPTYFILE option, then drop the empty data file.

GASQL.com - Focus on Database and Cloud

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 4

Alexander Zhang - Tuesday, February 13, 2018 3:31 PM
For same DB and same filegroup, you can DBCC SHRINKFILE with EMPTYFILE option, then drop the empty data file.

If you're going to recommend such a thing, then you also need to identify all the nasty stuff that happens along with that recommendation.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Phil Parkin SSC Guru Points: 246965 More actions · Answer 5

Lj Burrows - Monday, February 19, 2018 5:47 AM
Yes you can merge two or more database to one by restoring the databases which you want to merge and another way is to use third-party SQL Recovery Software, which is easy and fast solution that will help you in merging the two different SQL MDF file databases.

How does restoring databases facilitate their merge?
I do not see anywhere on the SQL Recovery Software site which talks about merging databases.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin