Selective Transaction Logging

Question

Selective Transaction Logging

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 1

Your best bet would be to move them to another database that you have a full recovery model on.

To help with preventing code changes you could actually use a synonym to reference the tables in the other database. Synonyms are pretty damn awesome, they've had them in Oracle for ages, to get them in SQL is huge.

http://msdn.microsoft.com/en-us/library/ms177544(SQL.90).aspx

Shamless self promotion - read my blog http://sirsql.net

parudl SSC Veteran Points: 229 More actions · Answer 2

Thanks Nic,

Totally forgot synonyms, still got my 2000 hat on. Makes logical sense.

Paul