Brandie Tarvin

  • Interests: Technology (of course), writing, and outdoor activities

SQLServerCentral Article

Backing Up a Database with SMO

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)

You rated this post out of 5. Change rating

2008-03-05 (first published: )

6,626 reads

Blogs

Why the masters and what lies ahead

By

I recently graduated with a Master’s in Strategic Communication from the University of Delaware....

Copilot Reminded Me How To Find a File Handle

By

Recently I was trying to delete a folder and kept getting the “something is...

Planview Portfolios REST API with ADF – Retrieving Actual Data

By

In the introduction of this blog post series, I explained the use case: extracting...

Read the latest Blogs

Forums

DB stuck in restoring state

By LearningDBA

A developer tried restoring a test DB 3 times and each time it was...

singleton is interferring with getting multiple nodes in xml

By stan

Hi we have an xml doc shaped essentially as shown in image 2 below. ...

The backup to one location fails but is successful on another

By Arsh

Dear Friends, Would be glad if any of you can help in a backup...

Visit the forum

Question of the Day

Implementing Change Data Capture

I have a complex environment that uses quite a few SQL Server 2022 servers. We have a powerful SQL Server running Enterprise that hosts most of our transaction data. However, there are remote locations that run Standard, Web, Express, and Express with Advanced Services editions for local collection of data before the data is transferred to our central Enterprise Edition server. We are considering using Change Data Capture (CDC) to lower the amount of data we transfer from clients. Which editions can we implement this feature on?

See possible answers