All geek questions in one place

SQL Server 2008: Can I set simplicity for a single table in a database for a recovery model?

I have a table that stores data from a complex query. This table is truncated and populated once per hour. Since you can assume that this is because the application is accessing this table and not the query.

Now the downside is the huge transaction log. There is no need to keep a transaction log for this table.

+4
source share
2 answers

Is it possible to set simplicity for a single table in a database for a recovery model?

No.

The recovery model is a parameter for each database . You cannot have different settings for different tables in the same database.

The recovery model can only be installed at the database level.

+4
source

As pointed out by marc, not in the same database, but you can put it in another database on the same server and link the databases so you can still include it in the queries, but it is on its own database with its own backup transaction log mode / settings.

+2
source

Source: https://habr.com/ru/post/1379808/

More articles:


All Articles