I wouldn't stop your SQL Server services. If the Acronis product /doesn't/ use the VSS writer support that SQL Server has, then simply schedule a backup to disk inside SQL Server (which will also truncate the transaction log), and then use Acronis to backup the server (excluding the active database and log files)
Cheers Ken > -----Original Message----- > From: Anthony [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 4 June 2008 5:35 AM > To: NT System Admin Issues > Subject: Acronis True Image and MS SQL 2000/2005 > > I've noticed that Acronis has a MS SQL backup product which I've not used > yet. > > I've got a number of servers using vanilla Acronis True Image for their > backups, these servers also have MS SQL instances on them. > > With Acronis being image based, do you trust it for your backups as far as a > safe SQL backup? > > I believe VSS Writers are involved when it starts a backup, so I'm thinking > transactions should be flushed to disk. Not 100% sure. > > Also considering a command file to stop the sql service(s) and then restart > on backup completion but not sure if that is really necessary. > > I know this doesn't address growing log files, just wondering what others out > their are doing if they just have the Acronis True Image as their backup > utility in regards to MS SQL databases. > > Comments? > > Thanks, > > Anthony > > > > ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ > ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
