Vezi daca te inspira aceste exemple de cod .NET cu SMO:

http://www.codeproject.com/KB/cs/SQL_Server_2005_Database.aspx?msg=2750907#xx2750907xx

http://blogs.msdn.com/sqlexpress/archive/2007/03/20/backup-and-restore-with-user-instances.aspx

Iata si un exemplu cu PowerShell - aici chiar ca e mult de invatat...

http://www.databasejournal.com/features/mssql/article.php/3681061