SQL Error

Y

yusuf

Guppy
I am getting the following Error,

The log file for database "XYZ" is Full. Back up the transaction log for the database to free up some log space.

Do i have any solution for this.... Can i get a script to shrink the transaction log....
 
You can make a ticket to ask for your transaction file to be set to automatically grow or ask it to be shrinked. If you have sql enterprise manager you can change settings there too.
 
what would happen if i limit the size of the transaction log, to 1gb, when it gets filled up, would the server crash or the data will be deleted....
 
1GB? you have that room? Could set it to grow. The trans log is supposed to shrink itself after a full back up. Which happens every night I think. Just need to find your happy medium, not to big and not to small.
 
Yes i have that room? but i just wanted to confirm whether the server will crash or the data will get deleted....
 
You must log in or register to reply here.
Back
Top