September 29, 2003 at 4:20 am
Our website has a large database of around 100,000 registered users.
The problem now is we are changing our web host, so how can I ensure that the
database is exactly replicated @ the new host without loosing any data.
How can the switching between the 2 hosts happen transparent to our web users with no data loss?
September 29, 2003 at 5:39 am
do a backup and restore is the best way to ensure that the database is the same. If you are going to have both host for a while you can do a restore of the tlogs up to the point you do the switch over. There is almost no way to to the switch over without some kind of down time.
Wes
September 29, 2003 at 8:35 am
Thanx, I really think thats the best way to do the job. What do u think of detach & attach and then restore the tlogs, is that similar to backup & restore.
Some sort of downtime is acceptable for the switch over.
Since I am new to log shipping, could u pls send me any guides/articles how to do the job ?
Will restoring the tlogs ensure that both database are identical, ie: Copying all the transactions from the source to destination database @ that point of time ?
Thanx again.
September 29, 2003 at 5:20 pm
If you detatch move the site and reattach and no traffic is hitting the old site you should be fine.
September 30, 2003 at 3:50 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply