April 2, 2008 at 1:23 pm
1 how can we check whether the backup is in consistent state or not
2. while restoring the transaction logs on secondary server in log shipping can the users access the database
April 2, 2008 at 1:40 pm
1 how can we check whether the backup is in consistent state or not
See Restore verify_only.. in BOL
2. while restoring the transaction logs on secondary server in log shipping can the users access the database
In standby mode... Users have read only access to secondary..make sure to select the option "Disconnect users in the database when restoring backups" otherwise tlog backups will accumulate..
NJ
April 3, 2008 at 12:41 am
sandhyarao49 (4/2/2008)
1 how can we check whether the backup is in consistent state or not
Restore it. It's the only way to be absolutely sure.
If you're using SQL 2005, have page checksums enabled and do your backup WITH CHECKSUM, then the verify_only can be mostly trusted. Otherwise it's not guarenteed to pick up all the potential problems with the backup.
I have seen backups that verity as OK, but fail part way through the restore.
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply