Home Forums SQL Server 2008 SQL Server 2008 Administration Need a Query to Capture all the information In SQL RE: Need a Query to Capture all the information In SQL

  • October 27, 2015 at 1:15 pm

    #1835886

    New persopn (10/27/2015)

    Thanks for your information.

    Is there any query to capture the information like Type of Backup, Mode of Backup information in SQL server

    Backups occur on a per database level, and not at the server level, so the scope/assumption is incorrect.

    select dbz.name,dbz.recovery_model_desc from sys.databases dbz shows you which db's are in FULL/SIMPLE/ recovery mode, but whether you have an actual backup of those db's, and what type the last ones were require querying the msdb database for last backups.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!