Avatar of elmbrook
elmbrook
 asked on

Accessing SQL Server Management Objects (SMO)

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.
C#Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Alpesh Patel

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Haver Ramirez

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Alpesh Patel

this is COM DLL and you find it in "C:\Program Files\Microsoft SQL Server\[SQL version]\SDK\Assemblies"
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck