Answer the question
In order to leave comments, you need to log in
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
https://docs.microsoft.com/en-us/sql/relational-da...
Also consider switching the recovery model to Simple mode
the main thing is to be able to read the dataThen 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 questionAsk a Question
731 491 924 answers to any question