SQL 2008 R2 Complete Backup?

Viewing 1 post (of 1 total)
  • Author
    Posts

  • QuattroDave
    Member
    #165016

    Afternoon all,

    a hard disk failed on my test SQL server over the weekend. Not a huge issue as I have images & SQL backups.

    New hard disk installed, Image copied back to hard disk, server booted first time. Opened SQL Management Studio and restored my databases…. Easy I thought, all done in less than an hour…!

    After a short while I realised that the database backup only backs up the data, it doesn’t backup any of the instance, logon or user information. It took longer to recreate this that it did to copy the image back…

    Question: Is there anyway I can backup the entire SQL instance to I can restore in one go…?

    Many thanks

    Dave

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

External Sharing and Guest User Access in Microsoft 365 and Teams

This eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

You will learn:

  • Who should be allowed to be invited as a guest?
  • What type of guests should be able to access files in SharePoint and OneDrive?
  • How should guests be offboarded?
  • How should you determine who has access to sensitive information in your environment?

Sponsored by:

 
Office 365 Coexistence for Mergers & Acquisitions: Don’t Panic! Make it SimpleLive Webinar on Tuesday, November 16, 2021 @ 1 pm ET

In this session, Microsoft MVPs Steve Goodman and Mike Weaver, and tenant migration expert Rich Dean, will cover the four most common steps toward Office 365 coexistence and explain the simplest route to project success.

  • Directory Sync/GAL Sync – How to prepare for access and awareness
  • Calendar Sharing – How to retrieve a user’s shared calendar, or a room’s free time
  • Email Routing – How to guarantee email is routed to the active mailbox before and after migration
  • Domain Sharing – How to accommodate both original and new SMTP domains at every stage

Aimed at IT Admins, Infrastructure Engineers and Project Managers, this session outlines both technical and project management considerations – giving you a great head start when faced with a tenant migration.the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

Sponsored by: