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 |
|
jhnegrao
Yak Posting Veteran
81 Posts |
 Posted - 2008-10-08 : 15:11:43
|
| Good Afternoon,I need to migrate a Database in a SQL Server MSDE which is hosted at Argentina. I'm planning to otimize my infrastructure and bring this Database to my site in Campinas (Brazil). The traffic will be over WAN (1Mbps and another 2Mbps link) and I would like to estimate if I will have any problems with that migration.What kind of information I need to check, what kind of monitoring I have to do. Anybody knows what I have to check to be sure that I will not have problems with this migration?Have a nice dayJuliano Horta |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-08 : 15:54:36
|
| How big is the database? |
 |
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2008-10-08 : 16:30:49
|
| The Database is not so big, its around 100MB. But the main problem that I'm trying to avoid is gonna be the transaction on this database after the migration. I need to know if the application will run properly, with a satisfactory performance and without time-outs. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-08 : 17:03:44
|
| to check timeouts.run a tracert domain_name in command prompt. And see if it times out. Also see if you can ping the server.Doesnt matter where your server is hosted as long as the connection is good, which you claim to be the case. |
|
|
|
|
|
|
Migrating Database to another location