Solved

SQL Restore failed got loading

Posted on 2006-06-14
8
208 Views
Last Modified: 2008-03-17
i was restoring a database and the network went down now my database says loading next to it..and i cannot restore...
any ideas
0
Comment
Question by:TRACEYMARY
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 20

Assisted Solution

by:Sirees
Sirees earned 100 total points
ID: 16906418
Do you have the backups on the server?
0
 
LVL 13

Accepted Solution

by:
MikeWalsh earned 400 total points
ID: 16906425
I would copy the backups locally, and do the restore over. Drop your database first and then just start the restore over again.
0
 
LVL 13

Expert Comment

by:MikeWalsh
ID: 16906430
It is safer this way to prevent network issues causing that.. So basically just delete/drop your database, and run the restore process to restore it again.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 7

Author Comment

by:TRACEYMARY
ID: 16906700
Delete database like its does not exist and then re add it again...............like new..
I give that a go
0
 
LVL 13

Expert Comment

by:MikeWalsh
ID: 16906717
well don't readd it like it is new.. Just delete it and then restore it.
0
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 16907043
Right click on database delete then ..........new database ........that what you mean....cause that what i did...
getting a lot of i/o errors but i think the network is messed up.....

i be back
0
 
LVL 13

Expert Comment

by:MikeWalsh
ID: 16907813
ok.. well first copy the file locally... Zip it up and copy it to the SQL Server.
0
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 16908104
i close post i did delete it ..then readded it but got i/o errors but i think i am on my way now...i see tomorrow when the network guy puts the server on the correct gig switch

Thanks
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question