Consistency Checks SQL Required?
Hi,
I am trying to find out whether or not indexes are required for SQL backups. I am having problems with verify's failing on any job with a database in backup exec 2010 R2. It doesn't always happen but is at least a couple of times a week.
I have tried a variety of things and the next thing i am looking at is the consistency checks.
What i need to know is, is it required to do a full check including indexes. I understand that its slower but my database guy says that you don't actually need the indexes when restoring the database as you can just rebuild them.
Can anyone qualify whether this is true and also whether Backup Exec actually makes any special use of indexes when restoring data. If not i will exclude indexes and see if this provides any better results.
Actually backup exec doesn't do the indexes it is done by the sql itesel on the background by the sql writer as you don normally. The backup agent just call the sql writer to perform the backup and do the indexes if checked.
While restoring the backup exec restores what is backed up and doesn't look for indexes.
The consistency check if fails with backup then recommeded to run it from sql server by the command to see if there are issues with the database itself.
Be won't do much in that casehttp://www.symantec.com/docs/HOWTO24066
