|
| | | Forum Guru
 
Group: Forum Members
Last Login: 9/8/2008 5:20:14 PM
Posts: 51, Visits: 183 |
| I'm an SQL newbie, so I'm not sure what to do about the pdslog.ldf file which grows significantly with each full-sync we do (about 2-4gb/each sync).
I did a little research and it comes down to what Recovery Model I'm using. The PDS db appears to be in "Full" mode, is it safe to change it? Is there another procedure for recouping that disk space.
Additionally, what is the procedure for moving the DB, can I do a deattach, move the pdslog.ldf and pdsdat.mdf to another drive and then attach it again?
Any help would be greatly appreciated... |
| |
| | | Supreme Being
Group: Forum Members
Last Login: 4/30/2007 8:10:34 AM
Posts: 166, Visits: 341 |
| | Do you happen to have a Database Maintenance plan setup on SQL? Possibly it can be optimized and get ride of white space. Check the Optimizations tab on your maintenance plan. Also, you can move the DB's if you like. Stop SQL, move the ldf file to another location, goto the properties of the PDS DB and goto the Trascation Log tab, and change the path. I would test this on a test box first of course, if you could but I have moved Db's and Transcation logs all the time, all depends on the software. Hope this helps? |
| |
| | | Forum Guru
Group: Forum Members
Last Login: 9/8/2008 5:20:14 PM
Posts: 51, Visits: 183 |
| I updated the maintenance plan and it only cut down the file size by 5%...
Can I put the PDS database in Simple recovery mode? |
| |
| | | Junior Member
Group: Forum Members
Last Login: 8/9/2007 11:00:15 AM
Posts: 13, Visits: 31 |
| | iSupport, I am currently setting my TS up and I was doing it the way you had recommeded in the past on another post, however, I've been contemplating switching to PDS. I just don't know if there is really a benefit to it, what made you switch to it; you sounded like you were doing fine with the setting you had?? |
| |
| | | Forum Guru
Group: Forum Members
Last Login: 9/8/2008 5:20:14 PM
Posts: 51, Visits: 183 |
| We were looking at moving from Point to something else when we decided what we were really looking for was some sort of business intelligence. So we created our own Web App that provides this intelligence through PDS/SQL/ASP. With v5.3 of PDS, life has been great. Most of the major problems have been worked out and everything runs fairly smoothly. The one issue we have with our PDS/SQL/ASP app is that PDS only supports 100 additional fields, which we are close to hitting the limit. I'm currently prioritizing the fields to figure out which we need.
The other MAJOR enhancement that PDS provides is security/MAC (moves, adds, changes) handing. We expand and shrink as the market flows and with std Point copying users around to folders and keeping up with security was a nightmare. PDS has groups for security which changes everything. Adding users w/accurate security now takes minutes.
To answer your question: My setup for the TS servers hasn't changed at all. I don't have any users remotely connecting directly w/PDS (may soon, but not now). All of my TS settings are identical except for the fact that I added in the PDS connectivity into the Winpoint.INI file.
|
| |
| | | 
Sepal
Group: Moderators
Last Login: Today @ 9:52:28 AM
Posts: 1,183, Visits: 9,258 |
| are you running sql server 2000 or 2005? Maybe in the future we can let the additional fields grow more in 2005 it doesn't have some of the limits that the old server had.
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.  |
| |
|
|