Forum Discussion
How to rename an existing backup file
Really simple question. I took a backup of several small and large databases but I forgot to add the extension ".BAK". I would like to rename the backup but I want to do it properly. Other than chang...
- The backup history is stored is DB msdn system tables; it's not supported the content of them.
https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/backup-and-restore-tables-transact-sql?view=sql-server-ver16
SQLServerRookie , my feedback is more: Why? The file name/extention don't matter much.
Yes, you can change the file extention via Windows File Explorer, but keep in mind, it won't check the file name in SQL Server backup history.
Olaf
- olafhelper, I know they don't matter much but I would like to keep things tidy. Is there a way to rename the file at SQL Server level as well? I guess I'm looking for an UPDATE statement but I don't really know the data dictionary.
- The backup history is stored is DB msdn system tables; it's not supported the content of them.
https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/backup-and-restore-tables-transact-sql?view=sql-server-ver16
