Problem Statement:

One of my colleague has reported an issue as below while he is trying to restore a database from backup.

SQL Server – Invalid Urn filter on server level: filter must be empty, or server attribute must be equal with the true server name

To my best knowledge, I was seeing this error first time and I was trying to understand about the issue with my google search and there are quite few good posts out there too.

http://blog.patricknielsen.net/2011/01/sql-server-invalid-urn-filter-on-server.html
https://debabratahowlee.blogspot.com/2016/09/sql-server-invalid-urn-filter-on-server.html

But somehow I was thinking something different as I was sure there were no activities at server level. Then I simply closed all open connections and restarted SSMS and tried and it worked perfectly this time. So, I do not have any clue yet what would have happened under the cover, however, am sure there is something gone bad it could be a failover/underlined network or anything that it could not resolve the server name.

If you have any different thoughts, please share in comment section.

I’d like to grow my readership. If you enjoyed this blog post, please share it with your friends!