What is equivalent of Oracle Archiver/Read only tablespaces in SQL server
Posted on 2011-09-15
What does SQL server offer for oracle Read only tablespaces & transportable tablespaces?
I am also getting lost reading more on SQL server trasnaction logs.
Most posts recommend keeping just one transaction log file for each database. Duplexing logs can have issues they say which is not true in Oracle & highly recommended.
If the database is under FULL recovery mode I need to backup transaction log after defined interval. I want to know if there is something like Oracle Archiver process which can do this without dba intervention in background?