Solved

SQL Restore failed got loading

Posted on 2006-06-14
8
205 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

726 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