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 changing the name on File Explorer, what else do I need to do?
I can also take another backup but it's going to take me a long time.
I want it renamed so that the filename is meaningful
TIA
- 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
bake13Microsoft
Hi SQLServerRookie -- That is it! You did all that you need to do. Take care.
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
Hello, you should take in this matter and extension can be changed by windows explorer.
