September 2, 2009 at 3:49 am
I tried restoring adifferential backup on a database.But at the final stage it throws an error like
"can't associate files with different database"
Again wen i tried it is keep on failing showing the error
"cant access the backup device"
wat can i do to restore that differential backup.
database is showing loading status...
September 2, 2009 at 4:24 am
shanila_minnu (9/2/2009)
I tried restoring adifferential backup on a database.But at the final stage it throws an error like"can't associate files with different database"
Again wen i tried it is keep on failing showing the error
"cant access the backup device"
wat can i do to restore that differential backup.
database is showing loading status...
I am assuming that you have done a restore using the latest full backup with norecovery and then you are trying to restore a differential after that, I take it that the differential is for that database, can you run a restore headeronly and a restore filelistonly from the differential backup file and see if the backup is the correct one. even use restore verifyonly perhaps
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 2, 2009 at 4:36 am
how can we perform restore header only and fle only...since that database is in laoding state ,i cant open the query analyser for that database
September 2, 2009 at 4:56 am
shanila_minnu (9/2/2009)
how can we perform restore header only and fle only...since that database is in laoding state ,i cant open the query analyser for that database
Right OK...
All I am suggesting is that you look at the differential bak file. it is nothing to do with the database. open another query window in query analyser and select a different database.
restore headeronly from disk = 'd:\mydatabasefolder\mybackup.bak'
restore filelistonly from disk = 'd:\mydatabasefolder\mybackup.bak'
what you will get, is information that will confirm details about your differential backup.
If I am suggesting anything wrong, feel free, anyone, to correct me...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply