Sunday, February 12, 2012

Cannot restore db

I'm trying to restore a Db from my web site back to my local machine.

Whichever way try, I get an error message saying

RESTORE detected an error on page (0:0)in database "new databasename"

> as read from the backup

Can anyone tell me what the error might be?

Many thanks

post back the restore database statement you used... also check the backup set .... if it is sql server 2005 use verify only option to verify the backup set... i doubt its corrupted.

Madhu

|||

Madhu,

I'm a newbie to SQL...

The backup was created by my web host - I have no control over how it is was created.

My database is SQL 2005 Express and I am trying to restore using SQL Server Management Studio Express - I do not see how to use "verfiy" using this tool.

Please can you give me some more guidance?

Many thanks for your help so far.

No comments:

Post a Comment