Prev: Click Once deployment - cannot continue. the application is improperly formatted
Next: what happens when a digital certificate expires
From: eliza on 17 Mar 2010 06:03
Using the SQL SMO object we can easily take backup of SQL database through code.To find the codes plz check th link below:

http://www.mindfiresolutions.com/Backup-SQL-Database-Through-Code-In-VBNET-846.php



MikeTI wrote:

Backup of Remote SQL Server using VB Net Code
26-Jan-10

Jan 26, 2010

Hi all

I am using VB Net 2008 and SQL 2008.

I am taking a backup of a local SQL Server Database using the following
code:

Dim backup As SQLDMO.Backup = New SQLDMO.BackupClass()
Dim sqlserver As SQLDMO.SQLServer = New SQLDMO.SQLServerClass()
sqlserver.LoginSecure = False
sqlserver.Connect("MIKETI-PC\sqlexpress", "sa", "sapassword")
backup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database
backup.Database = "TestDataBase"

backup.Files = "C:\SQL_BACKUP\TestDataBase.bak"
backup.BackupSetName = "Test01"
backup.BackupSetDescription = "Database backup description"
backup.Initialize = True
backup.SQLBackup(sqlserver)

How can I take a backup of a remote SQL Server Database on my local PC ??

Regards
Mike TI

Previous Posts In This Thread:

On Tuesday, January 26, 2010 6:21 AM
MikeTI wrote:

Backup of Remote SQL Server using VB Net Code
Jan 26, 2010

Hi all

I am using VB Net 2008 and SQL 2008.

I am taking a backup of a local SQL Server Database using the following
code:

Dim backup As SQLDMO.Backup = New SQLDMO.BackupClass()
Dim sqlserver As SQLDMO.SQLServer = New SQLDMO.SQLServerClass()
sqlserver.LoginSecure = False
sqlserver.Connect("MIKETI-PC\sqlexpress", "sa", "sapassword")
backup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database
backup.Database = "TestDataBase"

backup.Files = "C:\SQL_BACKUP\TestDataBase.bak"
backup.BackupSetName = "Test01"
backup.BackupSetDescription = "Database backup description"
backup.Initialize = True
backup.SQLBackup(sqlserver)

How can I take a backup of a remote SQL Server Database on my local PC ??

Regards
Mike TI

On Tuesday, January 26, 2010 12:14 PM
Joe Cool wrote:

rClass()rd")Databaseion"Use a standard SqlClient connection and execute a
rClass()
rd")
Database
ion"

Use a standard SqlClient connection and execute a backup database
transact-sql command. It is my impression that you will only be able
to make a backup copy to a local disk, but you can make a backup to
network disk if SQL instance service is running under a domain/
workgroup account instead of the server's local SYSTEM account.

http://msdn.microsoft.com/en-us/library/ms186865.aspx

On Tuesday, January 26, 2010 3:11 PM
Rich P wrote:

If you are working remotely, I think you can only run the backupoperation on
If you are working remotely, I think you can only run the backup
operation on the machine (the remote server) where the DB resides. Then
you can copy/FTP the .bak to your local computer. I think.

Rich

*** Sent via Developersdex http://www.developersdex.com ***


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Started with SQLite and Visual Studio
http://www.eggheadcafe.com/tutorials/aspnet/20f7912e-6fa7-40eb-b31b-b6f46d4f2c6a/get-started-with-sqlite-a.aspx
 | 
Pages: 1
Prev: Click Once deployment - cannot continue. the application is improperly formatted
Next: what happens when a digital certificate expires