question

azizkarim avatar image
azizkarim asked

Filter log shipping

Hello, Is it possible to use filter in log shipping? I want to protect my sensitive data. I know I can do it in replication. Thanks! Aziz
filter
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
The site works on voting. For all answers that are helpful you should indicate this by clicking on the thumbs up next to. Any answer that solved your problem or lead to a solution should be indicated by clicking on the check box next to that answer.
0 Likes 0 ·

2 Answers

·
sqlaj 1 avatar image
sqlaj 1 answered
I don't see the ability to filter with Log Shipping. At least not through the GUI within SQL Server Management Studio. You can read more here. About Log Shipping (SQL Server): http://technet.microsoft.com/en-us/library/ms187103.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image
Blackhawk-17 answered
You can't filter. If it is written to the Transaction Log it is shipped to the secondary. If it exists in the database on the primary it was created on the secondary.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.