Run sql server 2005 backup from VB.net 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi All

How do you run a backup / restore on sql server 2005 from within a VB.net
2005 application

In VB6 I used an execmd routine to run OSQL in cmd shell

In VB.net 2005 is there a better way to do it??


Regards
Steve


.

Relevant Pages

  • Re: Backing Up WSS
    ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Disaster Recovery question
    ... Can you post the SQL Server error log of the dysfunctional server? ... > You can restore master to another box. ... > 1) Drop the suspect DB's and simply restore from backup. ...
    (microsoft.public.sqlserver.server)
  • Re: Create Storedprocedure with VB6? Is this possible?
    ... VB6 and ADO no .NET ... can SQL Server Management Studio." ... Can VB6 create a stored procedure on the fly. ... something similar) exactly what you're sending to the db engine (via ADO), ...
    (microsoft.public.vb.database.ado)
  • Re: Is it necessary to exclude the data folder when using NetBackup?
    ... When you do a RESTORE in SQL Server, the database is created, if it doesn't ... >>just back up the native SQL backup files to ...
    (microsoft.public.sqlserver.server)
  • Re: stsadm.exe
    ... Yes, Stsadm will create the site for you on restore, and it will maintain all permissions. ... Stsadm only backups up data that is stored in the database, so any changes you make to the IIS server's file system you'll have to back up via some other method. ... only backup. ... For example, your production environment is IIS/WSS on one server, SQL Server on another. ...
    (microsoft.public.sharepoint.windowsservices)