October 4, 2015 at 7:29 am
Hi,
When we do DB migration using backup-restore, do we need to keep object,row count as part of checklist? I think if backup and restore goes successfully without any errors, the counts must match in source and target.
Please suggest.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
October 4, 2015 at 7:45 am
A restore will recreate the database exactly as it was at the time of 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
October 5, 2015 at 5:12 am
As long as you're using the BACKUP DATABASE command to create the backup, you're getting a page by page copy of the database. The backup is going to be the same as the database at the point of the backup. The only issue there is data that was actively being changed. This is managed by the backup and restore process, but could, in theory, result in slightly different row counts depending on when you took the counts.
"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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply