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 |
|
rammohan
Posting Yak Master
212 Posts |
 Posted - 2006-10-05 : 05:18:48
|
| hi,here i had created a database named "books" and it contains 8tables in sql server 2005. now i want to take a copy of this "books" database in another system which also have sql server2005 as a back end to asp.net. so where i can get this "books". i.e in which folder it will be saved. is it possible to svae this databse or have to svae each queries by which i created tables?One can never consent to creep,when one feels an impulse to soarRAMMOHAN |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-05 : 05:23:44
|
| You can simply backup the database and copy this backup file to another system where you want to create database. Restore this backup on the target system. There is nothing special about specific folder, you can save it in any folder.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-10-05 : 05:26:46
|
| There are 2 ways to do that1) Take a backup of the database and restore at other server2) deattach the database, take a copy of it into cd or etc.. and again attach the database. Note: Deattach will log off all the user from the database. To know the path of the database, right click on the database view the properties, Data file.Chirag |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-05 : 05:45:39
|
| ... best to have a backup before you detach in case, for any reason, it won't reattach!Kristen |
|
|
|
|
|
|
doubt at retrieving database in sqlserver2005