有没有一种方式修改sql server bak文件里面的逻辑数据库的名字

Question

譬如用restore filelistonly  from disk ='D:\TestResource\chineseDBName01.bak'检查出逻辑名字里面含有中文，有没有一种办法直接修改该bak文件里面的逻辑名字为英文？然后再用filelistonly来检查看到的是中文。因为使用的程序里面不能是中文，如果是中文，恢复将会失败

Answer 1

You maybe able to make change with kind of binary editor if know how, but restore may fail.

Answer 2

how to change it now, i can try it?

Answer 3

You can get binary editor and try.

Answer 4

it's not a good way, do have any other way to update it, such as some like sql to edit it ?

Answer 5

Sounds you should get some basic sql training. 

Answer 6

sql server修改数据库的逻辑名称是用Alter database命令的，需要联机。单独的修改数据库的备份文件没有命令。有一个Workaround,Restore修改逻辑名称，完了之后再备份出来。不过针对你的也实现不了。

---

Please Mark As Answer if it is helpful.