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 |
|
reachkarun
Starting Member
1 Post |
 Posted - 2007-10-20 : 00:45:29
|
| How can I restore the Database in another system if I copy the fils with extention .mdf and .log as it is with out Backuping? (i.e with out converrting the database to .bak file) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-20 : 01:42:01
|
| You can attach them with sp_attach_db. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-20 : 02:27:51
|
| See also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Detach+Move+Db,Log+File+Reattach |
|
|
|
|
|
|
Abck up of Database