Solved

SQL Restore failed got loading

Posted on 2006-06-14
8
204 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
  • 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

860 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