Backup SQL Server with TI9 -- Help With Scripts

I've been experimenting with moving some of our data from Access into microsoft's 'free' SQL Server Express. The computer in question is currently running XP Pro and has TI 9 Home installed (though I can upgrade to 10 or 10 workstation if that would help).

It is my understanding that the SQLServer needs to be stopped before the snapshot is created. Can anyone help me create the scripts I will need to stop the server prior to the snapshot and restart it afterwards?

Thanks for any help. I've very new to SQL and though I've been using TI since v8, I've never done anything this advanced with it either.

 

C:\WINDOWS>net stop MSSQLSERVER
The MSSQLSERVER service is stopping.
The MSSQLSERVER service was stopped successfully.


C:\WINDOWS>net start MSSQLSERVER
The MSSQLSERVER service is starting..
The MSSQLSERVER service was started successfully.


F.

 

Hi,

In my mind Acronis 9 supports VSS backups. and SQL Express 2005 SP1 is VSS capable/aware.

Take a look at the services that work with SQL 2005, maybe some extras ones will be needed.

Jaycee

 

Yeah good point. I have just checked and the one I quoted was for the MSDE/SQL Server 2000 service.

F.

 

I'm in over my head here. Do I need to run the scripts or not? Do I need to do anything to SQL to enable VSS and or anything to TI9 to make it work with it?