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 |
|
fqiao70
Yak Posting Veteran
52 Posts |
 Posted - 2005-09-09 : 11:55:14
|
| Hi I only one MDF file don't have log file, how can I attach the database? THank you very much! |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-09 : 12:00:02
|
| sp_attach_single_file_db====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
 |
|
|
fqiao70
Yak Posting Veteran
52 Posts |
Posted - 2005-09-09 : 12:17:46
|
| Thanks, but how can I do it through Enterprise Manager? |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-09 : 12:47:42
|
| I do not know. I try to script everything and then I save those scripts. I would only use the EM if I had a broken arm. What's is wrong with your QA?====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-09 : 12:54:15
|
"I would only use the EM if I had a broken arm" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-09 : 13:20:49
|
| You can only use Enterprise Manager if you have both the MDF and the LDF files, at least that's what I've seen.Tara |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-12 : 00:52:28
|
| right click [databases] node then [all tasks] then [attach database]pick up the mdf file, if the log doesn't exist, EM will create it for youHTH--------------------keeping it simple... |
|
|
|
|
|
|
SQL with MDF file