Solved

Accessing SQL Server Management Objects (SMO)

Posted on 2012-12-26
2
272 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Converting C# Objects into JSON file 7 41
How to calculate iops? 12 27
using t-sql EXISTS 8 23
T-SQL Using IN with a subquery 3 12
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

746 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

18 Experts available now in Live!

Get 1:1 Help Now