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)
 How to attach mdf file to existing db

Author  Topic 

shekhar_dba
Starting Member

39 Posts

Posted - 2006-10-31 : 14:42:22
Hi guru's

i have to attache new mdf file to the existing database in sqlserver 2005. please let me know the procedure to attach file to existing db.
i have tryed this by attache dbfile option but its not working.

please help me out this
thanks
shekhar

Luis Martin
Yak Posting Veteran

54 Posts

Posted - 2006-10-31 : 15:14:23
You can't attach mdf to existing database. You can attach before dettach.


All in Love is Fair
Stevie Wonder
Go to Top of Page

shekhar_dba
Starting Member

39 Posts

Posted - 2006-10-31 : 16:37:38
humm ok thanks alot ... i will try as u said ..

thanks
shekhar
Go to Top of Page
   

- Advertisement -