February 13, 2018 at 7:41 am
Hi
Is it possible to combine two or three database mdf files to one file.
Thanks
February 13, 2018 at 7:48 am
tmmutsetse - Tuesday, February 13, 2018 7:41 AMHiIs 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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
February 13, 2018 at 7:50 am
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
February 13, 2018 at 3:31 pm
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
February 13, 2018 at 9:40 pm
Alexander Zhang - Tuesday, February 13, 2018 3:31 PMFor 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
February 19, 2018 at 5:47 am
This was removed by the editor as SPAM
February 19, 2018 at 5:56 am
Lj Burrows - Monday, February 19, 2018 5:47 AMYes 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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply