| Author |
Topic |
|
frist44
Starting Member
12 Posts |
 Posted - 2008-08-19 : 15:39:48
|
| We're running sql 2000 and trying to copy a large database (>1 TB) and continue to have an updated copy but be able to work on the database for web development stuff. I'm familiar with log shipping, but that wouldn't allow us to make the standby machine active. We want to be able to work with it?any ideas? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-19 : 15:44:11
|
| Do you want to copy from Production to Dev? Why you wanna do Log shipping as it will impact performances issues on production server(if any).I would recommend to use third party tools like SQLlite to backup and copy to destination server for >1TB database. |
 |
|
|
frist44
Starting Member
12 Posts |
Posted - 2008-08-19 : 15:49:04
|
| Well log shipping was setup for another machine that is used in case of failure and I'm just trying to gather ideas. I'm new here so I'm looking for a better solution.Yes, we're trying to go from production to development. |
|
|
|
frist44
Starting Member
12 Posts |
Posted - 2008-08-19 : 15:52:00
|
quote:
Originally posted by sodeep
I would recommend to use third party tools like SQLlite to backup and copy to destination server for >1TB database.
Is this what you're referring to http://www.sqlite.org/ ? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-19 : 16:32:45
|
| Are these server on same storage or different location? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-19 : 23:21:45
|
| Idera, Quest and rad-gate have sql backup tool, check them out. By the way, log shipping shouldn't affect performance if you keep backup files on separate disk. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-08-20 : 01:41:11
|
| Do you require a full data set to continue developing? Is it possible to have a stripped down version of the db?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
frist44
Starting Member
12 Posts |
Posted - 2008-08-20 : 08:34:32
|
quote:
Originally posted by sodeep
Are these server on same storage or different location?
Different storage and location....We have a consistent VPN from location to location.We would like to have a pretty accurate set of data at the office location. There production database is at a data center. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-20 : 13:59:24
|
quote:
Originally posted by rmiao
Idera, Quest and rad-gate have sql backup tool, check them out. By the way, log shipping shouldn't affect performance if you keep backup files on separate disk.
Correct.We never do any stand-by/HA solution from Prod to Dev. Thats really bad idea. |
|
|
|
|
Copying large database for development