Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

full and differential backup Expand / Collapse
Author
Message
Posted Thursday, March 28, 2013 1:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 5:37 AM
Points: 8, Visits: 32
hi
when i am taking full backup and i am restoring full back up
i am getting error like "the database is not accessible"
please help me
regards,
gamit
Post #1436294
Posted Thursday, March 28, 2013 2:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, April 29, 2016 9:42 AM
Points: 6,437, Visits: 13,117
Gamit

What is the exact error message and what command are you using to restore the database? If you are using the GUI, there is a script button you can use to generate the command.

John
Post #1436308
Posted Wednesday, April 17, 2013 9:55 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:39 AM
Points: 863, Visits: 1,299
Are you trying to restore on a top of database which already exists?
If yes then use:-
Alter database <DBNAme> set offline with rollback immediate
go
alter database <DBNAme>set online
go
restore command
Post #1443350
Posted Wednesday, April 17, 2013 10:02 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, April 29, 2016 4:43 AM
Points: 6,107, Visits: 13,540
sounds like there are connections to the database preventing you restoring to it.

---------------------------------------------------------------------

Post #1443356
Posted Wednesday, April 17, 2013 9:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 25, 2016 4:42 PM
Points: 77, Visits: 575
Try this:

Alter database <DBNAme> set single_user with rollback immediate
go

<your restore statement>
go

alter database <DBNAme> set multi_user
go
Post #1443578
Posted Thursday, April 18, 2013 12:02 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:08 AM
Points: 44,494, Visits: 42,105
Connections to a database will not give you the 'database inaccessible' error message. If you're getting that error when backing up, then the database you're trying to back up is not accessible. Don't try things like taking it offline/online without looking at the root problem first, they could make matters worse.

What exactly are you trying to do, what are the exact error messages and what messages are in the SQL error log?



Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1443610
Posted Thursday, April 18, 2013 12:15 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, April 28, 2016 1:32 PM
Points: 8,096, Visits: 16,273
gamit124 (3/28/2013)
hi
when i am taking full backup and i am restoring full back up
i am getting error like "the database is not accessible"
please help me
regards,
gamit

Are you getting this error during the backup or the restore??


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1443613
Posted Thursday, April 18, 2013 11:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 12:53 PM
Points: 2, Visits: 515
The problem is with the backup
Post #1444023
Posted Thursday, April 18, 2013 11:12 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:08 AM
Points: 44,494, Visits: 42,105
Then...

GilaMonster (4/18/2013)
If you're getting that error when backing up, then the database you're trying to back up is not accessible. Don't try things like taking it offline/online without looking at the root problem first, they could make matters worse.

What exactly are you trying to do, what are the exact error messages and what messages are in the SQL error log?



Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1444030
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse