| Author |
Topic |
|
carau2007
Starting Member
31 Posts |
 Posted - 2007-09-10 : 13:59:55
|
| With sql 2000? How do I copy a database? I just want to make a copy of a database (house) to (house_demo) on the same server. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-09-10 : 14:05:17
|
| Which ways you tried:1. DTS2. Scripting database schemaHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-09-10 : 14:07:27
|
| How do I dump? Is dumping the same as backup? Sorry I have no clue here. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-09-10 : 14:14:53
|
| How do I do thatUse the backup database in the Enterprise manager and then use the restore. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-09-10 : 15:19:29
|
| What does BOL mean? And who is Tara? |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-10 : 15:30:20
|
quote:
Originally posted by carau2007
What does BOL mean? And who is Tara?
Books On-Line is BOL, Tara is a SQL guru that has a great blog with lots of useful info. For copying DB's though, check this out also, it's useful:http://vyaskn.tripod.com/moving_sql_server.htm
Future guru in the making. |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
Copy database