Forum Discussion

bst740's avatar
bst740
Level 4
11 years ago

Configuring MS-SQL backup

Hello everyone!   I have 2 question on configuring MS-SQL Backup   1) I created 2 scripts in client: first for full backup of my databases, second for transaction logs backup for the sames da...
7.5
Backup and Recovery
Basics
Case Study
Configuring
NetBackup
Troubleshooting
Windows Server (2003-2008)
  • Mark_Solutions's avatar
    Mark_Solutions
    11 years ago

    You need at least two policies.

    First for the full backup - note that it actually runs using the Default Application backup schedule so this needs a full single window and to have its retention period set to what you want it to be

    Second for the transaction logs - again with the Default Application Backup schedule having the retention you need

    If you do Monthly and Annual backups you will also need additional policies for those as you can only have one default application backup schedule in a policy and the jobs retentention period is taken from that schedule

    Hope this helps

bst740's avatar
bst740
Level 4
11 years ago

My domain administrator have sysadmin rights in SQL. Additionally I gave him rights on all my databases.

 

I configured policy with your script and second for logs. I will try it this night. Tomorrow i'll notify you.

 

Additionally I forgot to mention that SQL is in MS fileover cluster services. Agent is installed on both nodes. In policy and client settings there is a FQDN of clustered service.

 

Thanks you for your help!