Backing up of transaction log in SQL Server

Asked By Jason H Henderson 30 points N/A Posted 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?

• Status: Open
• Question Views: 374
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Server Software
• Question Tags: SQL Server | transaction log

Answered By Nolan M Holford 0 points N/A #284656

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.

About Nolan M Holford

Questions
4

Answers
23

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 01/07/2017
• Question Category: Server Software