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 |
|
mico00
Starting Member
1 Post |
 Posted - 2010-01-24 : 14:00:44
|
| U won't understand how urgent is it for me but i gotta somehow copy the mdf sql database i created (my project), and send it by mailto someone, which means i gotta rar it or something like that.i never did that before, im new with everything.how can i do that please tell me?btw, once i try to RAR (fails)..once i try to drag and COPY it to somewhere else it says file is open in sql (MSSQLSERVER) error. it cant b cuz i reseted few times already.help help help.. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-24 : 14:15:51
|
| "U won't understand how urgent is it for me"Nope, can't say I do ... |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-24 : 14:15:59
|
You have to detach the database (in SSMS right click on the database) before you can do anything with the mdf.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-24 : 14:29:26
|
Fred: I've known instances where the DB won't then reattach, which is a bit of a blow  .Backup would be my route. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-24 : 14:31:58
|
| ... often wondered why Attach was popular. Leaves the Logical name same as the source, creating possibility of a conflict downstream. No LDF either ... Name of the MDF might even clash with an existing DB. Hence I prefer backup. |
|
|
|
|
|
|
Urgent! (How do i copy a mdf DB??)