Multiple SQL Server - Central Server Problem

Hello,
We had some problems about our project. We have 60 sql server over the
country. We want to collect all data in central server. For collecting data
we developed a project. We get data from local server and transfer them to
central server. We have to transfer huge data. While we transfer data to
central server we are unable to access to defined DB in central database so
we can not query DB. it gives time out error. How can we get over this
problem. is there any idea?
Thanks,Odyssey (saintfi@.gmail.com) writes:
> We had some problems about our project. We have 60 sql server over the
> country. We want to collect all data in central server. For collecting
> data we developed a project. We get data from local server and transfer
> them to central server. We have to transfer huge data. While we transfer
> data to central server we are unable to access to defined DB in central
> database so we can not query DB. it gives time out error. How can we get
> over this problem. is there any idea?
With this scant information, it is very difficult to say that much
intelligent. How to you get the data from the local servers to the
central servers today? Replication? DTS? Linked server? Something else?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||What I do is -
1) Create a temp db (same schema as the intended db) on the
distination, e.g. the intended database is called CUSTOMERS, you create
a temp db called CUSOMERS_IMPORT with the identical schema.
2) Do the data transfer to the temp db, in this case CUSTOMERS_IMPORT
3) After the data is fully loaded, use sp_rename to switch the temp db
to the intended db and verse versa. In this example, rename CUSTOMERS
to CUSTOMERS_IMPORT, then rename CUSTOMERS_IMPORT to CUSTOMERS.
Re-apply indexes if any.
4) Delete from CUSTOMERS_IMPORT, which was the orignal db for the next
round of data loading (if it is a repeatable thing).
This way, the CUSTOEMRS database is still available for query while the
data is loaded in the temp db CUSTOMERS_IMPORT. The rename switch
takes about a second or two.
That how I max my db availablity for long data loading.
Mel