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 |
|
taylo
Yak Posting Veteran
82 Posts |
 Posted - 2004-07-16 : 11:16:10
|
| GreetingsCould someone tell me if I am on the right track here. We have a database that we need to use for the Website and for Internal processes. The Website is hosted at a hosting company close to us so there is no lag but we now want to move the Website to a different host. This will now put the Website a long way from the database. How could we do this? Would we set-up a Web database and then replicate it with the in-house database? Is anything even possible?Thanks....Rob |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-16 : 13:05:11
|
| So this will be a one-time move? If so, you would use sp_detach_db/sp_attach_db or BACKUP DATABASE/RESTORE DATABASE. Detach/attach would be the fastest, but I recommend running a backup prior to the detach just in case. Using either of these methods will only move the user database. If you have any jobs, DTS packages, or logins, then you will need to move those as well.Tara |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-17 : 03:44:47
|
| I don't like the sound of the replication between Web and Inhouse databases.Is the performance to the new host going to be too awful to use it direct?For example, our applications use 100% stored procedures for their actions, putting a [relatively] "very slow" link between the user and the database doesn't make a lot of difference.(I am presuming that your web site is used by the general public, or at least lots of "outsiders"; any form of replication would need to deal with any outage of connection such that the web users are not effected - they are going to be a very intollerant lot!; that almost certianly means that you would not be able to work on your the local database in your office when connection to the web database was lost - which probably won't please the accountants very much!)Kristen |
|
|
|
|
|
|
Replication?