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 |
|
noj17
Starting Member
18 Posts |
 Posted - 2008-12-03 : 21:58:42
|
| hello everyone!just want to ask guidance from experts...is it possible for logshipping to logship truncated tables into different servers?what this means is that we will just select tables which does not contain sensitive data, truncate it, schedule it for log shipping and then ship it to other server. I still dont know were to start..can anybody give detailed procedures or links that discuss this kind of problem?thanks and regards! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-03 : 22:07:19
|
| It should work with Log shipping because it works through Transaction log backup that ships to other server. |
 |
|
|
noj17
Starting Member
18 Posts |
Posted - 2008-12-03 : 22:51:14
|
| can i have the details pls? all i know is the basic log shipping...because this one, we will select a table or certain table to transfer, but in log shipping i think it is the tl backup files that are being transmitted?sorry, im a total beginner in sql...thanks! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-03 : 22:54:17
|
| Please have a look at Booksonline for Log shipping. |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-04 : 05:02:23
|
| Do you mean you want to transfer structure of table with-out the data? Or do you actually need to truncate the tables? |
|
|
|
noj17
Starting Member
18 Posts |
Posted - 2008-12-10 : 21:00:13
|
| is it possible to do it with the data attached? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-10 : 21:03:46
|
| Did you test it? |
|
|
|
|
|
|
truncate tables