?
Solved

SQL Restore failed got loading

Posted on 2006-06-14
8
Medium Priority
?
210 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 400 total points
ID: 16906418
Do you have the backups on the server?
0
 
LVL 13

Accepted Solution

by:
MikeWalsh earned 1600 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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.
Suggested Courses

770 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