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 |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2007-02-09 : 13:00:58
|
| Pb: what files do i need to get a database locally on my machine (sql 2000)Hi,A gus has a database on his machine and i want him to send me by email the necessary files so I copy his database to my machine.What files will I need to put in my machine to get the exact DB on my local machine so that i can do some tests.Will I use EM or some thiong else.Because he sent me a *.backup file but i am not sure how to use it and if it s enough to replicate the DB locally.Thanks a lot? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-09 : 14:40:01
|
| Yes a backup file is all that you need. You can restore it in Enterprise Manager or via the RESTORE DATABASE command.Tara Kizer |
 |
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2007-02-09 : 15:45:47
|
| ok then i guess just i create a new db , then do restore .do u think i also can use the back up file from sql 2000 to create that same db in sql 2005, do u know the procedure pls?Thank you |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-09 : 15:52:29
|
| You don't need to create a new database first. The restore will handle that. Yes you can use the 2000 backup file in 2005. The procedure is the same, run the restore command or use the restore GUI in Management Studio.Tara Kizer |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-10 : 09:07:53
|
| "you can use the 2000 backup file in 2005"Note however that you can't go the other way easily. So if you want to give the database back to your colleague you may want to use SQL 2000.Kristen |
|
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2007-02-10 : 14:10:30
|
| thank u |
|
|
|
|
|
|
what files do i need to get a database locally