November 18, 2008 at 11:31 pm
We are working on Analytics daily refresh automation. In this process, taking backup of Star Schema is one of the major tasks. One of the option for the backup that we have thought of is as mentioned below, wherein we will require your help to carry out a POC.
1. We will maintain a backup database which will hold Star Schema and transaction table. This backup database will be on different MSSQL instance.
2. Before modifying existing data, we will take backup (copy data) of Start schema / transaction tables on backup database which even should be retrievable in case of issues.
In oracle, copying of tables across instances is achieved using DB links. We need your help here:
a. To check whether same DB link concept is available on MSSQL or not.
b. If yes, how much time it will take to copy tables across instances.
November 19, 2008 at 1:06 am
The concept of linked servers sounds what you need - if you really need to copy all the data across. BOL will describe everything about linked servers.
As for how long - you will need to test, there ar e far too many variables - table size, ar bot instances sharing discs, how well configured are bot servers, wjhat sped discs, what speed network etc etc.
Mike John
November 19, 2008 at 1:47 am
a. To check whether same DB link concept is available on MSSQL or not.
b. If yes, how much time it will take to copy tables across instances.
a: Yes the DB link concept is called "linked server" in MSSQL. Search BOL for this item (i.e. sp_addlinkedserver)
b: the magic answer: "it depends":
- how big is the table
- your network infrastructure
- NIC configuration
- other network activity
- time of transfer
- etc,etc
Just log the proces in order to track the time needed for the transfer.
Wilfred
The best things in life are the simple things
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply