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 |
|
tishri
Yak Posting Veteran
95 Posts |
 Posted - 2006-05-31 : 22:12:11
|
| hi guys, i need help on how to make a dataware house without a connection. i am planning to use a removable disk to be used as a storage for the updated data and transfer it to the remote server to be synchronized. please give me advise on how to do it.. i really need to do this.. because there is really no connection that i could use.thanksTCC |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-31 : 22:15:53
|
Backup the database and copy over to remote server and restore ?
KH |
 |
|
|
tishri
Yak Posting Veteran
95 Posts |
Posted - 2006-05-31 : 22:25:19
|
| the database is very huge .. i only need the data that has been changed since last backup. if i am to create back-up of the database all the time. i need 3 cd's which is very hard on the part of the user. please replyTCC |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-31 : 22:33:25
|
Use differential backup ?Compress the backup file ?
KH |
|
|
|
tishri
Yak Posting Veteran
95 Posts |
Posted - 2006-05-31 : 22:53:29
|
| but can we do it in replication?TCC |
|
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-06-01 : 03:40:02
|
| why not use log shipping?May the Almighty God bless us all! |
|
|
|
tishri
Yak Posting Veteran
95 Posts |
Posted - 2006-06-01 : 20:56:52
|
| thanks... i guess this will workTCC |
|
|
|
|
|
|
replication problem