setting up backup via script 
Author Message
 setting up backup via script
Is there any way of installing mssql server 6.5 with a script telling it
when and which DB to backup ?
I would like to make an install, where I don't have to setup backup manualy
after the installation.

Thank you..

(I have looked in msdn and other resources without any results...)

regards
Thomas Saaugaard



Wed, 24 Apr 2002 03:00:00 GMT
 setting up backup via script

Hi Thomas,
You could use the unattended install method, and once its finished run a
script that installs the backup procedure you want.

--



Wed, 24 Apr 2002 03:00:00 GMT
 setting up backup via script
I found something in the manuals,
to do what I want, I need to use stored procedures for the scheduler :
sp_addtask
this can be done unattended via Isql.exe (or whatever) in the (dos)-prompt.
It can be done at any time not only under installation.

Thanks (tak skal du ha')

James Wilson skrev i meddelelsen ...

Quote:
>Hi Thomas,
>You could use the unattended install method, and once its finished run a
>script that installs the backup procedure you want.

>--




Sun, 28 Apr 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Backup script doesn't delete old backup sets

2. Backups via RMAN or Shell Script

3. sporadic error when setting connection via script

4. Setting Connection Props via Script

5. Can I Set Text Color Via a Script

6. script to Set DB+Backup+LOG fille

7. Scripted back-ups?

8. Need referrals for Business Set Ups

9. Multi-Protocol Set Ups

10. backup script for deleting backups older than 1 day

11. backup script to automate backup on NT

12. Adding to existing backup set and expiring backup


 
Powered by phpBB® Forum Software