[02/03] BACKUP & RESTORE SQLSERVER 2000 DATABASE

[mymessenger]

Hi All,
I'm doing a Management Project by VB.Net. It require me create a Form that is used to Backup and Restore Sql Databse. I don't know how to do this. But when I surfed web to find document. I saw a interesting tutorial, but it is written in C#.Net Language. Please help me a form resembles with that tutorial. I'm using VB.net 2003. Thanks so much

http://www.geekpedia.com/tutorial180...databases.html

[RobDog888]

Welcome to the Forums.

You really shouldnt be doing backups/restores of a sql db via a program other then Enterprize Manager as there are too many issues that can occur causing data loss which EM can handle best.

[jmcilhinney]

There are links to code converters in my signature.

[mymessenger]

Yeah. But it is a requirement in my project, so I must do it. please help me a form resemble that tutorial. I really need it to complete my project as soon as possible

[szlamany]

This link discussed a STORED PROCEDURE concept for backing up a DB...

http://www.vbforums.com/showthread.p...t=backup+funds

Search the forum for "BACKUP FUNDS" and you will get many threads dealing with BACKUP T-SQL statements...

btw - backing up a DB in a SPROC is no big deal - just keep in mind that the disk-path for the backup file is "local-to-the-server" and not to the "client-machine". You should not backup to a network drive or URL - the database engine really wants to backup to a local device.

Also - and more important - if you are going to RESTORE the DB you cannot be connected to that DB - when I do a restore from EM or QA I usually select the MASTER DB as the connection database - which has obvious security issues if done from a client program. Also when you do your restore are you expecting the DB to actually be "deleted" from the server at that moment?

BACKUP is normally done through scheduled jobs running under the agent. On-demand restore is a lot less common and seems like a questionable (or curious to say the least) requirement.