Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Friday, February 21, 2014 5:44 AM
Points: 8, Visits: 31
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: Today @ 9:07 AM
Points: 5,339, Visits: 9,794
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: Tuesday, August 26, 2014 5:30 AM
Points: 811, Visits: 1,165
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: Yesterday @ 6:55 AM
Points: 5,989, Visits: 12,927
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: Tuesday, July 29, 2014 12:44 AM
Points: 77, Visits: 568
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:52 PM
Points: 42,849, Visits: 35,978
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 2008, MVP
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:41 PM
Points: 6,318, Visits: 13,623
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: 2 days ago @ 8:32 AM
Points: 2, Visits: 183
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:52 PM
Points: 42,849, Visits: 35,978
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 2008, MVP
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