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 12»»

Database restoring,,,,, since 20 hrs Expand / Collapse
Author
Message
Posted Saturday, November 30, 2013 3:01 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, December 05, 2013 3:31 AM
Points: 65, Visits: 202
Hi,

i have 25 GB database backup file. I just restored it with a different database name. after starting restoring process it took hardly 20-30 minutes to complete the process successfully.

but even after 20 hrs, sql server management studio shows :

Database
abc
def (Restoring ...)

why this 'restoring... ' is been showing even after complition of restore process. ?

Post #1518640
Posted Saturday, November 30, 2013 4:52 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 @ 7:59 AM
Points: 41,530, Visits: 34,447
What was the exact restore command/options that you used?


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 #1518642
Posted Saturday, November 30, 2013 2:32 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:13 PM
Points: 35,969, Visits: 30,261
KcV (11/30/2013)
Hi,

i have 25 GB database backup file. I just restored it with a different database name. after starting restoring process it took hardly 20-30 minutes to complete the process successfully.

but even after 20 hrs, sql server management studio shows :

Database
abc
def (Restoring ...)

why this 'restoring... ' is been showing even after complition of restore process. ?



Did you try right clicking on it and selecting "Refresh"? The Explorer window is rather famous for not automatically updating.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1518663
Posted Saturday, November 30, 2013 6:47 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, April 12, 2014 11:40 AM
Points: 2,795, Visits: 8,297
Did you restore with "NORECOVERY" ?

That would show it "restoring" as it leaves it in a condition for you to restore additional Differentials or transaction logs.

If you do not have additional Diff or T-Logs to restore and want to use the database as it is, then run:

restore database MyDatabase with recovery



Post #1518672
Posted Monday, December 02, 2013 2:16 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, December 05, 2013 3:31 AM
Points: 65, Visits: 202
HI here my restore process.

- I just selected 'Restore Database' from 'database' from MSSMS.

- then i entered name of new database and defined a path to save location.
(Yes, Original database name is different from which i have defined due to i want a copy of same database with different name)

- Selected 'From Device'
- specified a backup file
- start restore. nothing else.

(i checked today morning, its still in same state)

Post #1518798
Posted Monday, December 02, 2013 2:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, December 05, 2013 3:31 AM
Points: 65, Visits: 202
Yes, i tried 'Refresh'. nothing happened.
Post #1518799
Posted Monday, December 02, 2013 2:41 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 @ 7:59 AM
Points: 41,530, Visits: 34,447
Are you absolutely sure that you didn't check the option to allow more log backups to be restored?




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 Attachments 
RestoreNoRecovery.png (133 views, 10.21 KB)
Post #1518805
Posted Monday, December 02, 2013 4:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 5:29 AM
Points: 147, Visits: 580
Hi,
If you got disconnected before your database fully recovers from restoring then it stays in Recovering mode forever, this had happens with me once when i was restoring database over the network and network got disconnected.





Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1518827
Posted Monday, December 02, 2013 4:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, December 05, 2013 3:31 AM
Points: 65, Visits: 202
yes, i think (99%) didn't checked this option.
Post #1518833
Posted Monday, December 02, 2013 4:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, December 05, 2013 3:31 AM
Points: 65, Visits: 202
Dear PravB4u,

i was not disconnected from database before completing restore process.
As i mentioned in my first post there was a message saying 'process is completed successfully'.
Post #1518834
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse