We need a routine that does
<path> is a var
select dbname from databases
{
try
backup db to <path>dbname
catch
trap error and notify via console output, then try a second time.
}
try/catch around everything for notifying on errors.
If you have questions post in PMB, we're looking to deal with someone who understands this request with very few further questions.
You don't need a c# program for this, you can do it with a batch file and a stored procedure to automatically process all your databases.
I did this for a bunch of my clients and it works like a charm, I can give you my custom backup script or if you would like I can code it in c#.
Hi there ,
I can provide you with the requirement with in a single day , i have a automatic backup tool made in .NET for backing up the MSSQL databases and it has a scheduling option to. if you intrested i can show u the demo also.
Looking forward for your mail.
Thanks anyways,
Regards
Harsha
Its really a simple application. If possible pls allow me to do this work in weekends. if you award this project on friday, i will deliver it to u by sunday morning.
Please, check my capabilities before awarding this project.
Hai,
I have been working as a core team lead since last 4 years. Expert areas include Delphi & C#.net.
I am intrested in doing this project and am confident in doing this work in ease.
Hope to hear from you soon.
Best regards
Best Regards.
I've got a stored proc which gets as a parameter the path where you want to back-up the database, if you are interested pls. let me know.
I've got a function also (written in VB6.0) which gets a path and back-ups the database in the specified path, it can be easily converted to C# and I would do it in minutes if my bid is chosen.