DBA GENESIS

  • Courses

  • Certification

  • Contact

  • Members

  • More

    Use tab to navigate through the menu items.

    Book a mock interview and get instant feedback - Learn More

    To see this working, head to your live site.
    • Categories
    • All Posts
    • My Posts
    lynda gacem
    Jul 25

    backups sql server

    in Oracle Database Administration

    HI guys ,


    Can you telle me please how to find where is the backups in sql server (not the default repository) it's urgent


    Thank you

    2 answers0 replies
    2 Comments

    Share Your ThoughtsSign up to leave a comment.

    Piyush Ranjan
    Jul 27
    •

    The simplest way to obtain the database backup history and the most recent backup information if you are using SQL Server Management Studio (SSMS) as your SQL Server client application is to use the backup and restore events report.


    Right-click the database in the SSMS object explorer panel.


    From the right-click menu select Reports >> Standard Reports >> Backup and Restore Events.


    Or


    You can run below command to get the details

    SELECT
        bs.database_name,
        bs.backup_start_date,
        bs.backup_finish_date,
        bs.server_name, 
        bs.user_name,
        bs.type,
        bm.physical_device_name
    FROM msdb.dbo.backupset AS bs
    INNER JOIN msdb.dbo.backupmediafamily AS bm on bs.media_set_id = bm.media_set_id
    1

    L
    lynda gacem
    Jul 25

    .

    1
    2 comments
    Similar Posts
    • Kill session in Oracle Database using SQL DEVELOPER
    • Oracle Database SQL Developer shares report on GIT
    • How to reset an Oracle Database password using SQL Developer

    support@dbagenesis.com

    • Facebook
    • Instagram
    • Twitter
    • YouTube

    © 2023 Biggest Database Forum by DBA Genesis