While restoring the database full/differential/ log file am getting an error like "Exclusive action could not be obtained because the database in use"

Question

While restoring the database full/differential/ log file am getting an error like "Exclusive action could not be obtained because the database in use"

Chowdary's

SSCrazy

Points: 2978
More actions
April 6, 2014 at 10:42 pm

#292057

Dear All,
am using 2008,
I have taken backups all the backups and trying to restore it but it is throwing error like
"Exclusive action could not be obtained because the database in use"
PFA....
Regards
Jagadeesh.K
Regards
Chowdary...

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

Database which you are going to restore is in use hence your restore fail. No one should connected to the database your are restoring. If you found any connections to the database you can KILL with the concent of the user.

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Chowdary's SSCrazy Points: 2978 More actions · Answer 2

Thank U for giving reply sir,

But am only using my server ,no other connections are there.

please give me some suggestion

Regards

Jagadeesh..

Regards
Chowdary...

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 3

Ok, try this;

Alter database [your database name here]

Set restricted_user with rollback immediate

Then do

Use Master

Go

Then try your restore again.

Chowdary's SSCrazy Points: 2978 More actions · Answer 4

Hi Sir,Thank U So Much now am able to restore the database backups(Full and Differential) .

But am trying to restore the Log Backup Files to the DB but it's not happening,

Ex:-

I am having 4 log files i have selected those 4 and trying to restore with norecovery model,It is showing that "A more recent log backup that includes LSN number xxx can be restored "

PFA...

Regards

Jagadeesh....

Regards
Chowdary...

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 5

Beatrix Kiddo

SSC-Dedicated

Points: 32407

April 7, 2014 at 4:03 am

#1703699

(Dup.)

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 6

It sounds like you're trying to restore a log file that is older than your Full or Differential backups. Check the times on all your backups and only restore logs that are newer than your differential (taken after it).

Chowdary's SSCrazy Points: 2978 More actions · Answer 7

Hi Sir,

Thank U So Much for giving reply.

it is throwing an error like in the attachment but there is no LSN Number like that ,there was only 4 logs with different LSN number .

PFA..

Regards
Chowdary...

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 8

What's the timestamp of your full backup and of your differential backup?

Chowdary's SSCrazy Points: 2978 More actions · Answer 9

Hi Sir,

My Full Back Time Stamp is :04:01:01

Differential Is: 04:20:18

Regards

Jagadeesh....

Regards
Chowdary...

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 10

Ok, so they were both (Full and Differential) taken at about 4 a.m. (i.e. in the morning)?

According to your screenshot, your log backups were taken between 2 and 3 in the afternoon. What happened between 04.20 and 14.59? Did you take any log backups? If so where are they now?

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 11

Ok, so they were both (Full and Differential) taken at about 4 a.m. (i.e. in the morning)?

According to your screenshot, your log backups were taken between 2 and 3 in the afternoon. What happened between 04.20 and 14.59? Did you take any log backups? If so where are they now?

Chowdary's SSCrazy Points: 2978 More actions · Answer 12

Sorry Sir, that was taken at 4pm only not 4 am.

i just taking the backup within less interval only

like

every 30 min Full backup

every 20 min differential

every 10 min log sir.

Sir,Here is one query for me.

While restoring the log file if i get select the ['From previous backup of the database'] its getting restore but if is select ['from file or tape'] it is throwing an error like that sir.

PFA....

Regards

Jagadeesh....

Regards
Chowdary...

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 13

In that case your log backups were taken before your full and differential backups I think (?), which is why you can't restore them.

It's really hard to tell more from here I'm afraid. What do you get if you do

restore headeronly from disk = 'D:\path of your full backup'

Go

?

Chowdary's SSCrazy Points: 2978 More actions · Answer 14

Thank U So Much Ur Patience sir,

Am very poor in that,just learning sir..

Very Sorry for giving trouble to u sir.

after following ur logics i got some ideas about restoring the db's.

Still am struggling with log and tail log LSN Mismatches,very soon i ll get clear on that sir ...

Please give me some related topic links if u have sir.

Am Very thank full U sir..

Regards

Jagadeesh...

Regards
Chowdary...