Ask the Community
Groups
Perform a Manual Full Database Backup from SQL - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>QUESTION</strong></p> <p>How do I perform a manual Full Database Backup from SQL Server Management Studio?</p> <p><strong>ANSWER</strong></p> <p>Follow the steps below to manually create a full database backup.</p> <p>1) Log into <strong>SQL Server Management Studio</strong>. You will need to either authenticate as your '<strong>sa</strong>' <strong>account</strong> or your <strong>Windows Credentials</strong>:</p> <p><img src="/attachments/token/q1L98ndLFmCAwHllYbhtgBAD3/?name=7-22-2016+2-30-22+PM.png" alt="7-22-2016_2-30-22_PM.png" class="embedImage-img importedEmbed-img"></img></p> <p>2) Expand the <strong>SQL Instance>Databases</strong> and right-click on <strong>ksubscribers</strong> and select <strong>Tasks>Back Up</strong></p> <p><img src="/attachments/token/ir5aspynHT70pSDKwBzwn0170/?name=7-22-2016+2-31-18+PM.png" alt="7-22-2016_2-31-18_PM.png" class="embedImage-img importedEmbed-img"></img></p> <p>3) Modify the settings as needed as displayed below:</p> <p><img src="/attachments/token/KpXHjgXNimNznXA9ojLreKFHD/?name=7-22-2016+2-33-32+PM.png" alt="7-22-2016_2-33-32_PM.png" class="embedImage-img importedEmbed-img"></img></p> <p>4) Click OK to begin the backup. This may take some time to complete depending on the size of the Ksubscribers database.</p> <p><strong>REFERENCE</strong> </p> <p>Reference: <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fms187510.aspx">https://msdn.microsoft.com/en-us/library/ms187510.aspx</a></p> <p><strong>APPLIES TO</strong></p> <p>All versions</p> </article> </main>