S
S
Satisfied IT2020-01-14 12:37:50
Backup
Satisfied IT, 2020-01-14 12:37:50

T-SQL database backup, is it possible to exclude the log?

Is it possible when creating a database backup (full recovery model) using T-SQL to backup only the database, without the transaction log? Or vice versa, from a full backup, restore only database files without a log? About the possibility of cropping the magazine, etc. I know, we use it, but there is a need for such a perverted inferior backup.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Vladimir Korotenko, 2020-01-14
@firedragon

https://docs.microsoft.com/en-us/sql/relational-da...
Also consider switching the recovery model to Simple mode

K
Konstantin Tsvetkov, 2020-01-15
@tsklab

the main thing is to be able to read the data
Then you can offer either a snapshot , or copy the file using Windows tools using, for example, a shadow copy.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question