Accessing SQL Server Management Objects (SMO)

elmbrook
elmbrook used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)

Commented:
this is COM DLL and you find it in "C:\Program Files\Microsoft SQL Server\[SQL version]\SDK\Assemblies"

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial