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 |
|
aclarke
Posting Yak Master
133 Posts |
 Posted - 2001-08-02 : 15:39:17
|
| I have a database in SQL Server 7 sp2 that's around 1.5 gig. I frequently need to move it down to test and development environments - I may need to do it 3 times in 1 day or not for weeks. It's an e-commerce site that's always being hit so I can't really detach it or anything as it needs to stay up. Moving it using Enterprise Manager works but obviously takes a long time. I can back it up and zip it and move it but I haven't figured out how to restore to a different server yet (I'm reading up in other posts here right now how to do that).Anyways, there are lots of options on how to move the data, but is there a consensus on what the BEST (fastest, safest) way is?Thanks,- Andrew. |
|
|
|
|
|
Best way to move a database