Cloud Network

Cloud Network

Networking | Support | Tricks | Troubleshoot | Tips

  •

    • Buymecoffe

    Buy Me A Coffee

    Wednesday, October 23, 2019

    How to Schedule Weekly Automatic Backup in SQL Server 2012, 2014 and 2016

    October 23, 2019
    How to Schedule Weekly Automatic Backup in SQL Server 2012, 2014 and 2016






    Schedule Automatic Backup in SQL Server 2012

    Before scheduling automatic backup we have make sure the following two points:
    • User should have the SYSADMIN privileges to schedule automatic backup.
    • SQL Server Agent service should be running.

     Schedule Automatic Backup

    • Click on the Start and Navigate to SQL Server Management Studio
    • Login to SQL Server Management Studio with User having SYSADMIN privileges.
    • Navigate to Management Node from the object explorer, and then select the Maintenance Plans node.
    • Right click the Maintenance Plan and then select New Maintenance Plan.
    • Enter the Name of the New Maintenance Plan


    • Now the configuration page will appear for Maintenance Plan


    • Now click on the Calendar Item as shown in the above image (on Top) and following screen pop up. Now in this screen we can configure Schedule as per requirement and click OK.
    • From the Maintenance Plan Tasks tool box pane in the left side, select the Back Up Database Task. Drag and drop backup database task to the right side or just double click on it.


    • After that right click on backup database task and click Edit it will allows you to configure the database configuration for the backup. Here you configure the databases that you need to backup, then specify a location for the backup, specify the extension for the backup files as per requirement.


    Click OK to finish configuration. Now backup plan configured. The backup files will be created on the scheduled time to the mentioned folder. The name of the file will be created by appending the date so that you can identify the back up for a particular date.
    By at
    Tags: ,

    How to use IIS without Local Administrator Rights In Windows Server

    October 23, 2019
    How to use IIS without Local Administrator Rights In Windows Server




    Internet Information Services (IIS)

    Use IIS without Local Administrator Rights

    Follow the below steps to allow the user to manage IIS (Internet Information Services) without the local administrator rights:
    1) First Login with the local administrator rights.
    2) Than to Control Panel and then Add/Remove Programs and then Windows Components. Then, install IIS components.(with i386)
    3) After installing IIS, you have to Download “IIS Resource Kit Tools” from the below given link
    IIS Resource Kit Tools   Click Here to download
    4) After Download "IIS Resource Kit Tool" , Install it.
    5) Now you have to open file "Metabase Explorer” from the below given path
    C:\Program Files\IIS Resources\Metabase Explorer
    6) In “IIS Metabase Explorer” window, right click on the computer name and select the “Permissions” tab
    7) Now Add the user to whom you want to provide IIS access and give permission as "Read".




    8) Now right click on the "LM" node and click on permission
    9)If any Security Warning dialog box appears, then just click on NO.
    10) Now in Permission , add the user give him with "Read"
    11)Than, expand “LM” node and then right click on “W3SVC” node and select Permissions.add the user and give him with "Full" Permissions
    12) Now Expand "W3SVC"
    13) Right Click on "Filters" and "Info" and select Permission and add the user with "Full" permissions
    14) Now ext the Metabase Explorer.
     15) You need to logoff now.
    16) Now login with the user account to whom you have provided access rights and try toManage IIS Manage Console.
    It will work perfect

    This way you can use IIS without providing the user's with Local System Administrator Rights.
    By at
    Tags: ,