<h1 id="retrievinglistofbackupsperformedforspecificdatabase">Retrieving list of backups performed for specific database</h1> <hr /> <h2 id="problem">Problem</h2> <p>When creating your backup strategy with Cloudberry Backup sometimes you need to analyze backup perfomance.</p> <hr /> <h2 id="suggestionsandresolution">Suggestions and Resolution</h2> <ol> <li><p>Start MS SQL management studio;</p></li> <li><p>Create a new script;</p></li> <li><p>Select the database to run against;</p></li> <li><p>Insert the following script and execute it.</p></li> </ol> <pre><code>SELECT s.database_name, m.physical_device_name, CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS bkSize, CAST(DATEDIFF(second, s.backup_start_date, s.backup_finish_date) AS VARCHAR(4)) + ' ' + 'Seconds' TimeTaken, s.backup_start_date, CAST(s.first_lsn AS VARCHAR(50)) AS first_lsn, CAST(s.last_lsn AS VARCHAR(50)) AS last_lsn, CASE s.[type] WHEN 'D' THEN 'Full' WHEN 'I' THEN 'Differential' WHEN 'L' THEN 'Transaction Log' END AS BackupType, s.server_name, s.recovery_model FROM msdb.dbo.backupset s INNER JOIN msdb.dbo.backupmediafamily m ON s.media_set_id = m.media_set_id WHERE s.database_name = DB_NAME() ORDER BY backup_start_date DESC, backup_finish_date GO </code></pre> <p>Reference: Pinal Dave (<a href="https://blog.sqlauthority.com/">https://blog.sqlauthority.com</a>)</p> <hr /> <p><center></p> <h5 id="customersupport">Customer support</h5> <h5 id=""> </h5> <h5 id="cantfindwhatyouneedgiveusacall">Can’t find what you need? Give us a call.</h5> <h5 id="-1"> </h5> <h5 id="-2">—</h5> <h5 id="-3"> </h5> <h5 id="12128639918">1.212.863.9918</h5> <h5 id="mf8amto6pm">M – F, 8am to 6pm</h5> <p></center></p>