N/APosted on - 01/07/2017
My SQL server is not working properly. Whenever I open the terminal, all I can see is a message that your database is full. I need to know how can I curtail the transaction log in SQL server to save my data?
Backing up of transaction log in SQL Server
See if your database is full or bulk-logged you need to regularly perform backups if you want to protect your data from getting lost. This procedure will curtail your log and prevents your database from getting full.
Here what you can do to solve the problem:
Firstly you need to connect you database server engine to object explorer where you can select the server name.
Now click on Databases and select system database to expand it in hierarchical form. Then just by right clicking go to Tasks and then Backup.
In the dialog box, you need to first check the name of your database and the recovery Model of your database whether it is full or bulk_logged.
After that, you just need to choose Transaction log as Backup type. And then choose disk as the destination and click add. Then click ok, this will add backup file in the disk.