How to Backup and Restore database in SQL Server | C#

Sdílet
Vložit
  • čas přidán 12. 10. 2020
  • Why is it important to back up a database?
    Backups help to restore computer devices during the process of disaster recovery and restore data after files have undergone damage or deletion. Database backups are essential for protection against data loss that can completely disrupt business operations.
    If the Backup Path Error shows then:
    1. Open Service by typing Services
    2. Locate and open the SQL Server (SQLExpress)
    3. Go to the LogOn Tab
    4. Choose Local System Account ( Also Check for Allow Services to interact with desktop )
    5. Click OK. Stop the service. Restart the service.
    Problem solved.
    SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    The above query will rollback any transaction which is running on that database and brings the SQL Server database in a single user mode. Cannot drop database “YourDbName” because it is currently in use.
    SUBSCRIBE MY CHANNEL FOR MORE TUTORIALS
    / @csharpmoderndesign
    👩‍💻 I Offer Software Development Gigs
    Upwork: www.upwork.com/workwith/muham...
    Fiverr: www.fiverr.com/muhammadahmar61
    ____________________________________________
    Thanks for Watching Friends...
    Like, Comment, Share and Subscribe for more videos... :)
    ____________________________________________
  • Věda a technologie

Komentáře • 2

  • @itlove6045
    @itlove6045 Před 3 lety

    ЛУЧШИЙ!!! Благодарю за подробный туториал 👍

  • @oglamrayat7372
    @oglamrayat7372 Před 3 lety

    bro help please
    restore does not work properly
    its Not a syntax error