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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Backup and scheduling using vb.net

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.
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2010-12-07 : 06:31:32
Using sql agent
Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page

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 delete
all old backup file. i hope its easy in ,net
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2010-12-07 : 07:06:44
i dnt knw that
Go to Top of Page
   

- Advertisement -