June 7, 2009 at 10:33 pm
Hello All,
Is there a way to check/verify table index in a backup?
I found a sql script but it requires to restore the backup first.
What I want is to check if there were no problems of the table
index in a backup file.
Hoping for your great help.
Many thanks...
June 8, 2009 at 3:01 am
You'll have to restore the backup. There's no tool I know of that reads inside a SQL backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 8, 2009 at 7:48 am
And run consistency checks before you backup the database so that in the future you'll know that the backup was taken from a well structured db.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 8, 2009 at 8:28 pm
Thanks guys...At least I know that what I am
wanting for is nearly impossible.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply