Backing Up a Database with SMO

  • Article

In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.

4.75 (4)

2008-03-05 (first published: )

6,497 reads

SMO Basics

  • Article

SQL Server guru Andy Warren has been working with all aspects of SQL Server for many years and is slowly upgrading his skills to SQL Server 2005. Here he takes a look at SMO basics, which is the replacement for DMO.


10,022 reads


Life Support 2008 – Audit Logons


Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT


This is the first in a series of posts about gatekeeping in Information Technology...

Read the latest Blogs


Are Windows Containers a Good Choice?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are Windows Containers a Good...


By Steve Jones - SSC Editor

Comments posted to this topic are about the item Intersection

SQl query to get next employee salary

By komal145

I have a table like below. Trying to achive the field "Other salary" Here...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day


See possible answers