DISQUS

DISQUS Hello! Tech-Recipes is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

Tech-Recipes

Cookbook of Tech Tutorials
Jump to original thread »
Author

SQL Server 2005: How To Restore a Database from a Backup | Database | Tech-Recipes

Started by qdideas · 9 months ago

No excerpt available. Jump to website »

8 comments

  • Anonymous

    1 year ago

    Hi all,

    Am having the backup data in my network drive(X:) I want to restore the data from that drive. I followed the same process what u mentioned in the forum.

    After clicking the add button in the specify backup window it shows only my local disks and removable devices not showing the network drive(x:)

    Is there any option to map the data from the network drive...
    reply
  • umesh

    7 months ago

    I taken backup of database from Sql server 2005 from other PC and try to Restore it on my PC. Both having Windows authentication. But i am facing following error

    System.Data.Sqlclient.sqlError:The media set has 2 media families but only 1 are provided.All member must be provided.(Microsoft.Sqlserver.Smo).

    IS it problem of Ownar . because owanr of .bak file is different from where i try to restore it.
    reply
  • Himanshu

    5 months ago

    Hi,
    This is not the problem of owner, it is just because while selecting the restoring device there must be two paths (1. Default by Microsoft, 2. Given by you).
    So delete the default path given by SQL Server itself, so it remains only one path that is given by you.
    Do let me know in case this doesn't work also
    Regards,
    Himanshu
    reply
  • sundar

    7 months ago

    hello sir/madam,

    i have stored mdf file and ldf file in dotnet solution file. i have copied my project from another system. i have to restore the database inorder to run my dotnet project.
    i have followed your procedure, but when i click the ok button, it shows error.

    please help me....
    reply
  • How To attach database sql

    3 months ago

    mdf and ldf files are not sql2005 based.. its sql 2000.. so install that and not need to restore.. you right click the database in enterprise manager in sql2000..attach the MDF file from location.. then run the program
    reply
  • Shamsul

    2 months ago

    Great step by step guidance. Worked a treat for me who is a complete novice
    reply
  • Osmar Mateus

    4 weeks ago

    I need to restore my database to a new location (we are moving to another server).

    What do I have to do in this case?

    Thanks
    reply
  • Sunil

    2 weeks ago

    Really This was very helpfull to me.
    Thank You!!
    Thank You very much
    reply

Add New Comment

Returning? Login