Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Merging 2 mdf files

Author  Topic 

a_r_satish
Yak Posting Veteran

84 Posts

Posted - 2006-02-24 : 23:35:11

Hi,

I just wanted to know is there ant option to merge 2 mdf files. If so i need the option.

reason is : i have 2 mdf files. the Appli runs fine with one and not with the other. So to converge these two mdf files.

Thanks in advance.

Regards,
satish.r

Regards,
satish.r

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2006-02-25 : 01:43:34
No

You would have to attach them as separate databases and migrate the data into one.
Use sp_attach_db for this (BOL will help with the syntax)


Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson
Go to Top of Page

a_r_satish
Yak Posting Veteran

84 Posts

Posted - 2006-02-25 : 02:06:19
Thanks.

Regards,
satish.r
Go to Top of Page
   

- Advertisement -