Tracking Restores

  • 1. Create a server list on Report server and create table RestorHistory_All  table as RestorHistory table with one additional column server name.

    2. create a procedure get the restorehistory into a permanent temp in tempdb  and deploy this procedure to all servers using OSQL.

    3. Create a procedure on Report server to BCP out/in from all servers one at a time and insert NOT exists data into RestorHistory_All table.

    4. Schedule the procedure created in step3 on Report server.

    Initially this may take 1-2 hour of write the script but later it saves lot of time.

    I use this technic to collect SQL error log in sql2000 from all servers...

     

    MohammedU
    Microsoft SQL Server MVP

Viewing post 1 (of 2 total)

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