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 |
sujeethbala2110
Starting Member
29 Posts |
Posted - 2006-11-09 : 11:44:05
|
hi can i have a batch file which will backup the database whenever itis executed. please provide me one.regardssuji |
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-09 : 13:10:38
|
Yes, just call osql in the batch file, see osql in Books Online for details and examples.Or you can just create a job in SQL Server and schedule it to run at regular intervals. |
|
|
sujeethbala2110
Starting Member
29 Posts |
Posted - 2006-11-09 : 22:56:22
|
thankssuji |
|
|
mightypenny_ph
Yak Posting Veteran
54 Posts |
Posted - 2006-11-10 : 02:18:35
|
just a suggestion... why don't you use SQL Server Agent and create a scheduled backup there.. it's better to use that because everything are already in place... :)SlayerS_`BoxeR` + [ReD]NaDa |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-10 : 03:41:51
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=How%20Backup%20works,What%20type%20of%20backup%20should%20I%20use,Automating%20Backups,BackupKristen |
|
|
|
|
|