my Log file has grown to a very large size for the last two days(from 1 GB to 9 GB).What should be the reason and how can i see the free space in my databse.
Thanks.What's your recovery model, and when was the last time you a) backed up the database or b) dumped the transaction log...
That's an awfully big log btw...
You set it to unlimited growth?
I Don't think (damn I did it again) that if you do, that it's a good idea...
Need to set alerts when the get to with a % of max...|||Large number of writes can cause it. How often do you backup your transaction log? If you haven't done it for a while, it's time. To see your free space, simply go to EM and right click the database, click view ant then click Task Pad.|||My database doesn't have any writes,But what i observed is that it's coz of sql server agent and its jobs. The log stopped to grow after i stopped sql server agent. Should it be because of backups or anything?
I am just taking a differential back of the database,Not taking any transactional backup.
Can anyone help in this issue?|||And one more question regarding the same issue,how can i bring my log size to the earlier size, which should be around 1 GB(which is now 10 GB)
Thanks|||read up on dbcc shrinkfile in SQL BOL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment