restore verifyonly is not executing | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

restore verifyonly is not executing

Hi All,
I have taken a backup of two databases of 40 gb and 95 gb and than tried to execute the following command to verify the backup file .
restore verifyonly from disk=’C:downloadsmydatabase.bak’
Its just executing the command without any result,,,,even after 45 mnts ….its still executing…..Any ideas will be helpful…thanks in advance
Yukon DBA

Can you tell us if you have executed with default option or other option ?

Is your backup set on media or Tape ?
How big is your back up file ?
an you move the back from production machine and to standby server try the same ?


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |