小编给大家分享一下如何解决sql server:alter database name的问题，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！

--step1:修改数据库名称USEmasterGOALTERDATABASEGeovinDuCmsSETSINGLE_USERWITHROLLBACKIMMEDIATEGOEXECmaster..sp_renamedb'GeovinDuCms','DuCms'GOALTERDATABASEDB_SHANGHAISETMULTI_USERGO--step2:查看修改名称后的数据库逻辑名及物理文件名USEmasterGOSELECTnameAS[LogicalName],physical_nameAS[DBFilePath],type_descAS[FileType],state_descAS[State]FROMsys.master_filesWHEREdatabase_id=DB_ID(N'DuCms')GO--step3:修改数据库逻辑文件名称USEmasterGOALTERDATABASEDuCmsSETSINGLE_USERWITHROLLBACKIMMEDIATEGOALTERDATABASEDuCmsMODIFYFILE(NAME=N'GeovinDuCms',NEWNAME=N'DuCms')GOALTERDATABASEDuCmsMODIFYFILE(NAME=N'GeovinDuCms_log',NEWNAME=N'DuCms_log')GOALTERDATABASEDuCmsSETMULTI_USERGO--step4:修改数据库物理文件名称之前先打开xp_cmdshell支持USEmasterGOsp_configure'showadvancedoptions',1GORECONFIGUREWITHOVERRIDEGOsp_configure'xp_cmdshell',1GORECONFIGUREWITHOVERRIDEGO--step5:重命名数据库物理文件名称USE[master]GOALTERDATABASEDuCMSSETOFFLINEWITHROLLBACKIMMEDIATEGOEXECxp_cmdshell'RENAME"E:\2005database\GeovinDuCms.mdf","DuCms.mdf"'GOEXECxp_cmdshell'RENAME"E:\2005database\GeovinDuCms_log.ldf","DuCms_log.ldf"'GO--step6:将数据库逻辑名称指向新的物理文件，并将数据库onlineUSE[master]GOALTERDATABASEDuCMSMODIFYFILE(NAME=DuCms,FILENAME='E:\2005database\DuCms.mdf')GOALTERDATABASEDuCMSMODIFYFILE(NAME=DuCms_log,FILENAME='E:\2005database\DuCms_log.ldf')GOALTERDATABASEDuCMSSETONLINE--step7:查看全部修改完成后的数据库情况USEmasterGOSELECTnameAS[LogicalName],physical_nameAS[DBFilePath],type_descAS[FileType],state_descAS[State]FROMsys.master_filesWHEREdatabase_id=DB_ID(N'DuCMS')GO--step8:关闭xp_cmdshell支持USEmasterGOsp_configure'xp_cmdshell',0GORECONFIGUREWITHOVERRIDEGOsp_configure'showadvancedoptions',0GORECONFIGUREWITHOVERRIDEGOUSEDuCMSGO

看完了这篇文章，相信你对“如何解决sql server:alter database name的问题”有了一定的了解，如果想了解更多相关知识，欢迎关注亿速云行业资讯频道，感谢各位的阅读！