You can use Enterprise manager to manage MSDE, and setup setup scheduled tasks and maintainence plans, so you can change all the settings this way.
Russ > -----Original Message----- > From: Aidan Whitehall [mailto:[EMAIL PROTECTED] > Sent: 20 August 2004 11:01 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] OT: Anyone here use Lyris and MSDE? > > Sorry for the OT -- emailed a question to the Lyris help-desk > yonks ago and still no response, so wondered if any of your > SQL Server gurus knows the answer. > > We're using Lyris ListManager with MSDE and I wanted to > backup of the "ListManager" database. I used this code > http://www.devx.com/vb2themax/Tip/18621 > to create a backup job that backs up the database and log > files, but the second step (the transaction logs) fails, > presumably as the ListManager Recovery Model (by default) is > set to Simple. > > Obviously, we don't want to lose any uncommitted > transactions. Am I right in thinking we can either change the > Recovery Mode from Simple to Full (does anyone know if doing > this would cause a problem?), or can you run a stored > procedure just prior to the backup that commits any > outstanding transactions? > > > Thanks > > -- > Aidan Whitehall [EMAIL PROTECTED] > Macromedia ColdFusion Developer > Fairbanks Environmental +44 (0)1695 51775 > > ______________________________________________________________ > __________ > This e-mail has been scanned for all viruses by Star > Internet. The service is powered by MessageLabs. For more > information on a proactive anti-virus service working around > the clock, around the globe, visit: > http://www.star.net.uk > ______________________________________________________________ > __________ > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
