Backup time

  • ok..

    Thanks.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • If you look at the table msdb.dbo.backupset it has a column called user_name which will tell you who performed the backup.

    It will also tell you lots of useful information about the backup like when it started, finished, how big it was. All useful stuff.

    Backup events are also logged in the SQL Server log (accessible in a number of ways - you can use sp_readerrorlog).

  • @ steven

    Thanks a lot.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply