Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to run this query

RESTORE DATABASE dbname
PAGE = '1:442'
FROM DISK = 'C:\dbname.bak'
WITH NORECOVERY

but getting the error:

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'PAGE'.

Can you help me with this? I've found information here and here, and can't figure out there is the problem.

share|improve this question

migrated from stackoverflow.com Aug 27 '11 at 23:36

This question came from our site for professional and enthusiast programmers.

7  
You are using SQL Server 2000, and that document is for SQL Server 2008. This feature probably doesn't exist in the 2000 version. –  cdhowie Aug 27 '11 at 18:50
    
@cdhowie Are there any other options to restore (maybe only one table)? –  VMAtm Aug 27 '11 at 18:52
1  
I don't know, I am not a SQL Server user. I just noticed that the document was for a newer version, that's all. –  cdhowie Aug 27 '11 at 18:53

2 Answers 2

up vote 2 down vote accepted

Page level restore isn't supported in SQL 2000. You will need to do a repair with data loss, restore the database with another name, then copy over the missing rows.

share|improve this answer

Why don't you restore the database as a different database, then copy the table over?

share|improve this answer
    
Because there are consistency error, and no operations with table are commited. –  VMAtm Aug 27 '11 at 22:40
4  
And you don't have a valid backup? –  Aaron Bertrand Aug 27 '11 at 22:59
    
Why do think what? Did you read this line: 'C:\dbname.bak'? It is a valid backup. I'm trying to know - is there any way to restore just one page from backup, and you just say - do the full backup. –  VMAtm Aug 28 '11 at 21:00
1  
I was just trying to suggest a workaround (the same workaround in the answer you accepted). –  Aaron Bertrand Aug 29 '11 at 17:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.