Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2008-12-19 : 09:47:13
|
| I have restored a backup copy to a new server, surprisingly I noticed that some indexes are missing in each table in restored database, I could not figure it out why some indexes are missing. Can any one faced with this type of issue.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-19 : 10:00:21
|
Someone have created the missing indexes AFTER last full backup?Or the indexes are located on another filegroup and you only backed up one filegroup?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2008-12-19 : 10:10:26
|
quote:
Originally posted by Peso
Someone have created the missing indexes AFTER last full backup?Or the indexes are located on another filegroup and you only backed up one filegroup?
E 12°55'05.63"N 56°04'39.26"
No all indexes were added long back.I did full backup, for some reason it did not bring over indexes on different filegroup. How to bring indexes which are on different file group along with full backup. I was thinking that I will get everything when I do full backup and restore it, I am missing indexes on one file group , basically I am seeing only indexes which are on primary file group.Please suggest what I should do to bring all indexes.Thanks in advance |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-19 : 10:17:30
|
Which command did you use to backup?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2008-12-19 : 10:28:26
|
quote:
Originally posted by Peso
Which command did you use to backup?
E 12°55'05.63"N 56°04'39.26"
I used SMS , right click on the database , all tasks--> database backup--> took complete database backup.Please suggest correct way if this is not correct. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-19 : 10:42:25
|
And the "Backup component" was left at default "database" option, and not "file and filegroups" option?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2008-12-19 : 10:57:00
|
quote:
Originally posted by Peso
And the "Backup component" was left at default "database" option, and not "file and filegroups" option?
E 12°55'05.63"N 56°04'39.26"
Yes, I have only database-complete or database-differential options enabled. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-19 : 11:30:04
|
| Completely Incorrect. Full backup should capture everything.Are your index created before full backup and their FG?Or restore recent fullbackup. |
|
|
|
|
|
|
Indexes missing after restore