Help with Salontouch DB Maintenance - TanToday - Helping Salon Owners, One At A Time, Since 2000!

imhere · 30th July 2008, 03:34 PM

Anyone run manual db maintenance jobs? I do my backups manually (sucks!) already. Have the delete program to get rid of old records but really would like to run some regular db maintenance.

Anyone know how to do this? When I try in my SQL Job Viewer under Maintenance tab, it is not successful. I can see the server but nothing happens when I click start job button.

Ezliving_Jim · 30th July 2008, 04:10 PM

Call IDS. They will walk you through it.

imhere · 30th July 2008, 04:27 PM

Thx, but definetly not calling IDS. They suck! Was hoping someone had the magic answer so I don't have to call them, spend two hours on the phone and end up worse than I was when I started.

EliteMike · 30th July 2008, 05:27 PM

what db server are you using?

imhere · 30th July 2008, 05:40 PM

mssql assigned to my salon - it's LAN not WAN. is that what you mean? i can access the server when using the backup tab but cannot seem to access it when using the maintenance tab, even though it's listed.

EliteMike · 30th July 2008, 06:21 PM

well first of all, what is it you plan on doing in the database. I can't think of too many reasons to need to go in there

imhere · 31st July 2008, 11:34 AM

when i say i can access it, i mean i can see and select it. i just need to run maintenance on my db. isn't this standard procedure for db upkeep? maybe not necessary for sql? i don't know.

EliteMike · 31st July 2008, 01:01 PM

are you concerned about orphan records somewhere and things like that?

I work with a very large database that stores alot of the army's planning information. Only time I need to directly access the database would be to make a change to a piece of data that we keep on there that wouldn't be editable in most cases.

I don't know the layout of salon touches db. When you delete a client record, ALL items associated with that client should go with it. Does that happen, I'm not sure. Same goes with products and things like that. Essentially, there should never be a need to go in and do "maintenance". With a relational database, if you don't understand the relationships, you can delete something that is a vital link to other tabels but looks like junk.

Kathe · 18th August 2008, 05:11 PM

You don't need to do it for salontouch.

30th July 2008, 03:34 PM	#1 (permalink)
imhere Salon Owner Join Date: Jun 2008 Location: why...want to stalk me? Posts: 57	Help with Salontouch DB Maintenance Anyone run manual db maintenance jobs? I do my backups manually (sucks!) already. Have the delete program to get rid of old records but really would like to run some regular db maintenance. Anyone know how to do this? When I try in my SQL Job Viewer under Maintenance tab, it is not successful. I can see the server but nothing happens when I click start job button.

30th July 2008, 04:10 PM	#2 (permalink)
Ezliving_Jim Arbiter Elegantiarum Join Date: Nov 2004 Location: Virtual Reality Posts: 3,939	Re: Help with Salontouch DB Maintenance Call IDS. They will walk you through it. __________________ si vis pacem, para bellum "The Meek Shall Inherit Nothing." -Frank Zappa. "I inhaled frequently. That was the point." - Barack Obama. "Even if we win, we will have just eked out a victory, and we can't govern." - Barack Obama. *sui generis*

30th July 2008, 04:27 PM	#3 (permalink)
imhere Salon Owner Join Date: Jun 2008 Location: why...want to stalk me? Posts: 57	Re: Help with Salontouch DB Maintenance Thx, but definetly not calling IDS. They suck! Was hoping someone had the magic answer so I don't have to call them, spend two hours on the phone and end up worse than I was when I started.

30th July 2008, 05:27 PM	#4 (permalink)
EliteMike Hall of Famer Join Date: May 2007 Location: D.C. Posts: 4,360	Re: Help with Salontouch DB Maintenance what db server are you using?

30th July 2008, 05:40 PM	#5 (permalink)
imhere Salon Owner Join Date: Jun 2008 Location: why...want to stalk me? Posts: 57	Re: Help with Salontouch DB Maintenance mssql assigned to my salon - it's LAN not WAN. is that what you mean? i can access the server when using the backup tab but cannot seem to access it when using the maintenance tab, even though it's listed.

30th July 2008, 06:21 PM	#6 (permalink)
EliteMike Hall of Famer Join Date: May 2007 Location: D.C. Posts: 4,360	Re: Help with Salontouch DB Maintenance well first of all, what is it you plan on doing in the database. I can't think of too many reasons to need to go in there

31st July 2008, 11:34 AM	#7 (permalink)
imhere Salon Owner Join Date: Jun 2008 Location: why...want to stalk me? Posts: 57	Re: Help with Salontouch DB Maintenance when i say i can access it, i mean i can see and select it. i just need to run maintenance on my db. isn't this standard procedure for db upkeep? maybe not necessary for sql? i don't know.

31st July 2008, 01:01 PM	#8 (permalink)
EliteMike Hall of Famer Join Date: May 2007 Location: D.C. Posts: 4,360	Re: Help with Salontouch DB Maintenance are you concerned about orphan records somewhere and things like that? I work with a very large database that stores alot of the army's planning information. Only time I need to directly access the database would be to make a change to a piece of data that we keep on there that wouldn't be editable in most cases. I don't know the layout of salon touches db. When you delete a client record, ALL items associated with that client should go with it. Does that happen, I'm not sure. Same goes with products and things like that. Essentially, there should never be a need to go in and do "maintenance". With a relational database, if you don't understand the relationships, you can delete something that is a vital link to other tabels but looks like junk.

18th August 2008, 05:11 PM	#9 (permalink)
Kathe Salon Owner/Arbonne VP Join Date: Dec 2005 Location: Michigan Posts: 2,811	Re: Help with Salontouch DB Maintenance You don't need to do it for salontouch. __________________ Kathe Ray ITA member 248.890.6968 Arbonne products make a great add-on sale to any salon. Natural skin care, nutrition, weight loss, detox and much more!! Salon owner since 1994. Arbonne consultant since 1997. I can teach you how to make more money in your salon with Arbonne - call me today! For more info and great before & after pictures visit my website at http://www.infiniteabundance.us/salonowners.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode