How to find out used media id's in SQL agent based restore
Could you please let me know that how can I find number of used medias in a SQL agent based restore.
I was restoring the database and selected full + differential backup to restore. After restore start it gave 1 media id and I requested for that media.
After restore completion another stream for restore started(Most probably for differential) and was using another media which was not in the library.
It took double time to restore the data.
Please let me know the procedure to find out the media ids.Thanks in advance.