Unsolved
This post is more than 5 years old
2 Posts
0
2003
November 3rd, 2009 11:00
SQL Best Practices- AVAMAR
What are some of the best practices for backing up SQL?
Thanks in advance.
Thanks in advance.
No Events found!
Unsolved
This post is more than 5 years old
2 Posts
0
2003
November 3rd, 2009 11:00
Top
OscarG1
2 Intern
•
137 Posts
0
November 3rd, 2009 15:00
For a SQL Server database backup, configure the maximum hash cache in the
dataset definition by setting the following:
¿ Attribute = [avtar]hashcachemax
¿ Attribute Value = 200
Amol
2 Intern
•
207 Posts
0
November 4th, 2009 06:00
If you specify hashcachemax=400 then the hascache will grow to 400 MB
dwilk1973
1 Rookie
•
63 Posts
0
March 30th, 2011 18:00
Can you explain how you change that parameter? Is this on the client or the policy? Can you give some steps? Thanks!
OKlier
21 Posts
0
April 17th, 2011 08:00
SQL is a beast of its own and varies from enviroment to enviroment. Would you say this is a high use database set to Full logging. Also depends on your RTO RPO, ow much downtime can the business tolerate. We have several SQL servers that range from can be down for 48 hours to one that needs to be back online in 4 if it goes down. If you have one that needs to be online and it generates lots of logs, we have been told by several consultants to back it up every 15mins and flush the logs, this is probably done best by the SQL agent since Avamar doesnt seem to flush logs after backup, and have Avamar back it up nightly.
Hope this helps!