|
| | | Forum Guru
 
Group: Forum Members
Last Login: 11/6/2008 11:08:25 AM
Posts: 67, Visits: 143 |
| | How large should be PDS transaction log be? My PDS database is 473MB. My trans log is 13.3 GB. |
| |
| | | Forum Guru
Group: Forum Members
Last Login: 11/6/2008 11:08:25 AM
Posts: 67, Visits: 143 |
| | |
| | | 
Sepal
Group: Moderators
Last Login: Today @ 6:00:14 AM
Posts: 1,178, Visits: 9,170 |
| It will depend on how far back you want the log to stretch. My recommendation is to pick a week or a month time period measure the delta of file change and set that plus some padding to your size limit.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.  |
| |
| | | 
Grand Poo-Bah
Group: Administrators
Last Login: 11/4/2008 8:29:36 AM
Posts: 255, Visits: 13,331 |
| You can also truncate your SQL log - first make a backup of your data then truncate it. Here's an article from Microsoft with info on SQL transaction logs in SQL Server 2005:
http://support.microsoft.com/kb/873235
Good times!
Disclaimer: this post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.
|
| |
| | | Forum Guru
Group: Forum Members
Last Login: 11/6/2008 11:08:25 AM
Posts: 67, Visits: 143 |
| | Thanks. The trans log is now a respectable 100MB. |
| |
|
|