SQL Restore failed got loading

i was restoring a database and the network went down now my database says loading next to it..and i cannot restore...
any ideas
LVL 7
TRACEYMARYAsked:
Who is Participating?
 
MikeWalshConnect With a Mentor Commented:
I would copy the backups locally, and do the restore over. Drop your database first and then just start the restore over again.
0
 
SireesConnect With a Mentor Commented:
Do you have the backups on the server?
0
 
MikeWalshCommented:
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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
TRACEYMARYAuthor Commented:
Delete database like its does not exist and then re add it again...............like new..
I give that a go
0
 
MikeWalshCommented:
well don't readd it like it is new.. Just delete it and then restore it.
0
 
TRACEYMARYAuthor Commented:
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
 
MikeWalshCommented:
ok.. well first copy the file locally... Zip it up and copy it to the SQL Server.
0
 
TRACEYMARYAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.