• You need o run this query in th eserver you take the backups. ie the original server.

    Make sure you give the correct database name. look at the databasename available in backupset table in msdb.

    Select distinct database_name from backupset

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]