|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 609
|
I have trouble followiung the below steps for full, trans and differential backups for SQL Server.
Full backup: "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx"
Differential backup: "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx" -diff
Transaction log backup: "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx" -log
Copy-only log backups: "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx" -logcopy
Copy-only full backups: "C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx" -fullcopy
I cannot schedule these commands in the scheduler, i could only give the path of the like
"C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" and i don't see anywhere, where i can give the whole path
like " C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx"
so somepne please show me the detailed steps because i think i might need to buy this product but before that i need to see all the functionality.
so please show me the details steps how do i schedule in the scheduler to run Full, Trans, and Differential backups.
thanks.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 350
|
If you scheduler any job using SQLBackupAndFTP, then go to Windows Scheduler, find this task, right click, select Properties, in the Run field you will see exactly next line including quotes:
"C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\new.jobx"
From here you can modify or add any of the parameters to the run field.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 350
|
Starting v6 there's a GUI for differential and transaction log backup
|
|
|
|
|
