Solved

Accessing SQL Server Management Objects (SMO)

Posted on 2012-12-26
2
273 Views
Last Modified: 2012-12-30
I want to backup my SQL database programatically.

I have found an article using SMO that will enable me to do this.

However, when I go to add the references to my project, I cannot locate them under the .Net components. I have SQL Server 2008 R2 installed.

Can someone please advise me where I can find the references for SMO?

Thanks in advance.
0
Comment
Question by:elmbrook
2 Comments
 
LVL 8

Accepted Solution

by:
Crashman earned 500 total points
ID: 38722232
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 38722748
this is COM DLL and you find it in "C:\Program Files\Microsoft SQL Server\[SQL version]\SDK\Assemblies"
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Code works but I need to redo it and assign values to Model 7 32
Error when loading the database 16 55
xpath sql query 2008 8 42
SQL Server stored proc 2 12
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now