Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2010-12-07 : 06:23:25
|
Hi,Can any one tel me how to do backup and scheduleing database using VB.net console applicatio |
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-07 : 06:26:58
|
Any reason you can't use the sql server scheduler/broker or the windows scheduler?Sounds like the question is how to create a scheduler in vb.net - nothing to do with sql server - a sql server command would just be somethig that gets triggered.To do this you would need to know what sortof schedules you need to create. It's not simple to cater for all possibilities.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2010-12-07 : 06:31:32
|
Using sql agent |
 |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2010-12-07 : 06:37:56
|
i want write database backup to cd after every 7 days how it is possible . can u tel me |
 |
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-12-07 : 06:40:46
|
quote: Originally posted by nigelrivett Any reason you can't use the sql server scheduler/broker or the windows scheduler?
Not sure but for me it sounds like the OP is developing an VB.net application where user can select the database and perform back of database and do the scheduling.Yadhu_cse : If that is the case, you can generate the script from SSMS and use the script (doing modification wherever required ) in your vb.net code. |
 |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2010-12-07 : 07:05:34
|
ya. that i want to write to cd every seven days and have to deleteall old backup file. i hope its easy in ,net |
 |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2010-12-07 : 07:06:44
|
i dnt knw that |
 |
|
|
|
|