SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Question : Error 927 : Database xxx cannot be opened.


Question : Error 927 : Database xxx cannot be opened.

Author
Message
Killer -136848
Killer -136848
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 1

Database xxx cannot be opened. It's in the middel of a restore.

Ok, i am completly blank on Microsoft SQL server, i don't know anything (almoust)...

I don't know how long we have had this stautus on the database, it's an old databse that is going to be used again. How do i unlock it? Or should i get a really old Veritas backup of it?

Roy


SQLBill
SQLBill
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25384 Visits: 1087

You can't use a database when it's being restored.

That said, if it's been restoring for a while - it's possible the restore was done incorrectly.

You didn't give enough information to really figure out what's wrong, so I'm going to make some guesses here...

Look at the database in Enterprise Manager, does it show LOADING?

If you are not actively restoring the database, but it's still in a restoring state (LOADING) that means that the option WITH NORECOVERY was probably used and the database is awaiting another file to be restored.

Try running this command:
RESTORE dbname
WITH RECOVERY

Change the dbname part to the real name of your database.

-SQLBill





Killer -136848
Killer -136848
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 1

Yes, correct, it says LOADING, and i haven't done anything to start a restore.

But here' comes a real newbi question! Where do i type :

RESTORE dbname
WITH RECOVERY

?

Roy


sa24
sa24
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3539 Visits: 1
You can type it in SQL Query Analyzer. You can open SQL Qeury analyzer from the tools tab in enterprise manager or go to start-> run and type in isqlw and press enter, query analyzer will pop up.



SQLBill
SQLBill
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25384 Visits: 1087

Or you can find QA at Start>Programs>Microsoft SQL Server>Query Analyzer

Also, if you aren't aware of it, SQL Server has the Books OnLine (refered to as BOL) which is it's Help function. It's installed as part of the Client Tools and you can find it at Start>Programs>Microsoft SQL Server>Books OnLine. Make it your friend, it can be very helpful.

-SQLBill





Killer -136848
Killer -136848
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 1

Thanks...but it didn't help, i think the database need sto be replaced with an old copy of it...

Roy


Killer -136848
Killer -136848
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 1

My backup was also not good...and the

RESTORE dbname
WITH RECOVERY

did not work either, it keeps saying "incorrect syntax near the keyword with" ?? It doesn't turn up in the database liste either (in SQL Query Analyzer)

I'm lost....


Annabel Pearce
Annabel Pearce
SSC Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 3

This is interesting, I'm trying to find any help I can on the particular problem we have. This forum is the closest I can find.

Description: SQL server 7 and running a Veritas restore.

Problem : Restore gets to 99% complete on the Veritas restore process, Database is in a state of "(loading)".

Also, the Restore shows the following statement being used by Veritas

RESTORE DATABASE [dbname] FROM virtual_device = 'BackupExecSqlAgent_dbname_00' WITH REPLACE, RECOVERY

It is 'awaiting command' according to sp_who2 under Query analyser and 'sleeping' under EM current activity.

So as far as I can tell, the restore has been done using the RECOVERY option. I can't see why this doesn't appear to complete.

Database is quite large (33GB) and logfile (about 1GB).

How long should this take to finish "loading" or is this likely to be still this way tomorrow morning (about 18 hours from now).

We need this database back and this is a full restore so should bring it all back the way it was when the Backup was taken.

I'm completely confused and don't know what to do next.

Can anyone help me?


Ritch
Ritch
Mr or Mrs. 500
Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)Mr or Mrs. 500 (500 reputation)

Group: General Forum Members
Points: 500 Visits: 1

Roy,

This article may help you http://www.sqlservercentral.com/columnists/bknight/unmarksuspect.asp

Ritch




"I didn't do anything it just got complicated" - M Edwards
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search