February 23, 2016 at 5:38 pm
If I backup a fragmented database and restore it on a different server will the fragmentation be carried forward to the new server? Is this specific to the index type? Please advise.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
February 23, 2016 at 5:52 pm
fizzleme (2/23/2016)
If I backup a fragmented database and restore it on a different server will the fragmentation be carried forward to the new server?
Yes. It will be a complete copy of the database with the same fragmentation etc.
February 23, 2016 at 5:56 pm
A backup is copy of the pages. There is no effort made to recompute anything or look at the contents. They are copied to disk on backup, copied back on restore.
This is why corruption flows through backups.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 24, 2016 at 10:53 am
Thank you gentlemen!
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply