Creating backup of several databases using multithreading

Question

3.91/5 (3 votes)

See more:

I'm trying to right VB.NET code to create backups of several databases.
The backup-procedure (already written) asks for server, databasename and backup-filename, and returns a string ("Success" or "Error") after backup has been made.

Because each backup can take several minutes, and because the databases can be located on different servers, it is better to create the backups in separated threads.

I already know how to work with multiple threads, and how to wait for all threads to finish, but how can I pass the arguments of server, database en filename to the thread, and how can I read the return-string ?

Thanks already !

Posted 16-Feb-10 5:26am

lvandevyvere

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dimitri Witkowski · Answer 1 · 2010-02-16T08:58:00

Solution 1

You can use events, parametrized thread-starts and other multi-threading techniues offered by .NET

Posted 16-Feb-10 8:58am

Dimitri Witkowski

Nicholas Butler · Answer 2 · 2010-02-16T09:05:00

One way would be to write a class that wraps a thread. The class would have member properties for the input and output fields and would expose enough of the Thread object to enable synchronization and control. The thread main method would be a member of the class and so would have access to the instance properties.

Nick