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]
