Results 1 to 5 of 5

Thread: To check backup

  1. #1
    Join Date
    Jul 2002
    Posts
    48

    Unanswered: To check backup

    Hi
    In a SQL Server, how to verify whether backup has been taken or not?
    To be precise with the help of query analyser we need to verify whether for a particular database backup is been taken or not? If you have any method to check can you please let me know...

    Thanks
    Nagesh

  2. #2
    Join Date
    Aug 2002
    Location
    india
    Posts
    41
    One of the best option to check wheather database-backup taken or not

    emngr -> server database -> (select database) -> properties -> there is an option backup just below that u can see the last database backup
    taken it shows the date time etc...

  3. #3
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    In MSDB you can find backup history in tables: backupfile, backupset ....

  4. #4
    Join Date
    Jul 2002
    Posts
    48
    Originally posted by snail
    In MSDB you can find backup history in tables: backupfile, backupset ....

    Thanks a lot...

  5. #5
    Join Date
    Sep 2002
    Location
    MI
    Posts
    19
    You can also set the verify option when backing up, this is slower, but will also clear tans log durring trans backup
    Jon Nelson

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •