Backup and Restore with SMO

Backup and Restore with SMO

You probably know that you can back up SQL Server 2005 Express databases by using SQL Server Management Studio Express (SSMSE). You might also know that you can back up databases by using the T-SQL BACKUP and RESTORE statements. However, you might not realize that you can also back up databases from your .NET applications by taking advantage of SQL Server Express’ SQL Management Objects (SMO) API. To find out more about using SMO to back up your databases and get a couple of useful code snippets, you should check out


Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.