Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backing Up a Database with SMO Expand / Collapse
Author
Message
Posted Tuesday, March 06, 2007 9:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:55 AM
Points: 7,053, Visits: 6,214
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/btarvin/2900.asp

Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #349411
Posted Tuesday, March 13, 2007 7:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 7:24 AM
Points: 182, Visits: 996
I enjoyed the article.  Can this application be built with Visual Basic Express Edition?

David Bird

My PC Quick Reference Guide
Post #351101
Posted Tuesday, March 13, 2007 10:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:55 AM
Points: 7,053, Visits: 6,214

Honestly, I haven't actually worked Visual Basic Express, just Studio 2005.  Google has lots of information about SQL Server Express and the SMO object, but I can't seem to find anything about using SMO with Visual Basic Express. 

Since SMO is supposed to be included with SQL Server Express, though, and since SQL Express is supposed to be usable with VB Express, I would say "yes" with a caveat.  As long as you can create the appropriate references, import the SMO objects and are using Visual Basic Express 2005, that you should be able to do this project using that tool.

Now you've got me wondering, though.  I'm going to have to download the Express version and give it a whirl.  @=)



Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #351197
Posted Friday, April 20, 2007 9:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 11, 2008 2:47 AM
Points: 81, Visits: 35
Useful article. A few typos in the code though maybe?

Module CreateInitialConnection Public ProdServer As New Server()
Public ProdConn As ServerConnection
[...]

should read (note line break)

Module CreateInitialConnection
Public ProdServer As New Server()
Public ProdConn As ServerConnection
[...]


and
ImportsMicrosoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common

should read
Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common


Also, as a vb.net newbie I don't know if this is required in all cases but I got a failure every time I tried to run the code until I went into Project Properties -> Security and enabled "Enable ClickOnce Security Settings" and checked "This is a full trust application"
Post #360028
Posted Friday, April 20, 2007 10:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:55 AM
Points: 7,053, Visits: 6,214

Good catch on the typos!  Thanks for pointing them out.

I apologize for not mentioning the Security Settings.  I re-create this project 3 times to make sure my code worked consistantly and don't remember setting those two properties.  But when I went back and checked, sure enough, they were there and they were checked.  And it isn't a default setting on my Visual Studio, either.  So, that is definitely my bad.  Sorry for the confusion.

I take it you finally got this working?



Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #360040
Posted Monday, October 13, 2008 5:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 15, 2013 4:00 AM
Points: 11, Visits: 49
Nice and useful article.

Is it possible to take backup in any other drives or specific location other the default sql backup folder.

how to configure the specific location?

Please help me to do this.
Post #584799
Posted Monday, October 13, 2008 5:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:55 AM
Points: 7,053, Visits: 6,214
I'm not quite sure I understand the question.

Are you saying you want to save SQL Database backups to a different location? Or that you want to pull non-SQL Database backups somewhere?



Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #584812
Posted Monday, November 24, 2008 4:11 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:43 AM
Points: 1,042, Visits: 2,708
Good article, Brandie. I appreciated the steps to create the MSI file - I've written a lot of SMO but have never taken the time to create the MSI. Thanks for the how-to.



Tim Mitchell, SQL Server MVP
Independent Business Intelligence Consultant
www.TimMitchell.net
@Tim_Mitchell

Post #607938
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse