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.
| Author |
Topic |
|
Tiago
Starting Member
2 Posts |
 Posted - 2006-06-29 : 05:02:21
|
| how can i do thism, having 3 datafiles ?(i think i cannot use sp_attach_single_file_db)thank you very much. |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-06-29 : 05:45:38
|
| To clarify your question, you have a .mdf file and a .ndf file? Have you tried using the normal attach, without specifying the .ldf?Alternatively, have a look at CREATED DATABASE ... FOR ATTACH syntax..*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
detach database, attach database without log file