| Author |
Topic |
|
jajjii
Starting Member
8 Posts |
 Posted - 2010-12-13 : 15:44:12
|
| A couple of months ago, I performed an online page restore on our database. Everything has been working fine until we upgraded our SQL server from 2005 to 2008.Now when I try to setup/run backup on the database .mdf file, I get an error message. The log file is being backed up just fine. Failed:(-1073548784) Executing the query "BACKUP DATABASE [ADS] TO DISK = N'\\\\<domainName>..." failed with the following error: "Backup of file 'ADS' is not permitted because it contains pages subject to an online restore sequence. Complete the restore sequence before taking the backup, or restrict the backup to exclude this file.BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.Any pointers are welcome… |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jajjii
Starting Member
8 Posts |
Posted - 2010-12-13 : 16:02:20
|
| It showed nothing.DBCC CHECKDB ('ADS') WITH NO_INFOMSGSresultCommand(s) completed successfully.Basically you are saying that I should create a new database and import all the data into it. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jajjii
Starting Member
8 Posts |
Posted - 2010-12-13 : 16:10:12
|
| The error points to 'Complete the restore sequence '.As far as I know, when doing a page restore, there is no end statement that has to be written.Is there any script that will check a page restore status?I'll wait for them as you recommend... |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-13 : 16:32:33
|
| From the sound of things, the page restore wasn't done properly. Don't suppose you remember what you did?--Gail ShawSQL Server MVP |
|
|
|
jajjii
Starting Member
8 Posts |
Posted - 2010-12-14 : 11:16:53
|
| Hi Gail,I did a page restore as described here [url]http://msdn.microsoft.com/en-us/library/ms175168.aspx[/url]Once it completed, the database started to work again, and I have had no problems. Backups were running on both log and the database, and since we moved it to Server 2008, I cannot perform the backup on the database.I have also moved the database before between different servers, both running SQL 2005 without any problems. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jajjii
Starting Member
8 Posts |
Posted - 2010-12-15 : 13:30:15
|
| I just remebered that I blogged about the situation and the steps I took here [url]http://blog.ralfelt.com/post/Database-ID-52c-Page-(14171728)-is-marked-RestorePending2c-which-may-indicate-disk-corruption.aspx[/url]Please see if you can give me feedback about it. |
|
|
|
jajjii
Starting Member
8 Posts |
Posted - 2010-12-15 : 14:17:38
|
| Sorry the link did not come out right. Copy and paste into your browser insteadhttp://blog.ralfelt.com/post/Database-ID-52c-Page-(14171728)-is-marked-RestorePending2c-which-may-indicate-disk-corruption.aspx |
|
|
|
jajjii
Starting Member
8 Posts |
Posted - 2010-12-16 : 10:11:36
|
| Any comments? |
|
|
|
jajjii
Starting Member
8 Posts |
Posted - 2010-12-29 : 13:34:58
|
| I ended up creating a new database, and scripted all the tables, stored procedure, and triggers.Recreated and set all the permissions on the users.After this, I could backup the database. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Complete the restore sequence before taking ...