SQL Server : can we find out who has renamed database?

Question

Is there any way in SQL Server 2012 to identify who has changed the database name? Is there any audit log or some thing that would help?

Answer 1

The rename operation will be written to TLOG no matter how you do it.

I did a small test and renamed a database. This rename operation is written to the TLOG as you can see in below screenshot:

You can read the log and know the name using this query:

select 
    suser_sname([transaction sid]) as username,* 
from 
    fn_dblog(null,null)

This is subject to below clauses

1. Your master db is in full recovery model
2. Even if your master db is not in full recovery model, you may get that data, if that is not truncated

Also note reading log on live production database is not recommended, so I advise taking backups of TLOG and reading them seperately