Shulou(Shulou.com)05/31 Report--

This article will explain in detail about the sql statement to modify the logical name, database name, physical name of the SQL Server database. The content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Change the Sql statement of the physical file name of the MSSQL database

Note: make sure that no process is connected to the database you want to rename in the activity monitor!

The Sql statement is as follows

USE master-- change logical name ALTER DATABASE YQBlog MODIFY FILE (NAME='YQBlogAA',NEWNAME='YQBlog')-- GOALTER DATABASE YQBlog MODIFY FILE (NAME='YQBlogAA_log',NEWNAME='YQBlog_log')-- GO-- change database name EXEC sys.sp_renamedb @ dbname = 'YQBlogAA',-- sysname @ newname =' YQBlog' GO-- detach database EXEC sp_detach_db YQBlogGO-- open xp_cmdshell function EXEC sp_configure 'show advanced options', 1GORECONFIGUREGOEXEC sp_configure' xp_cmdshell' 1GORECONFIGUREGOAfter YQBlogAA_log.ldf YQBlog_log.ldf'--GO-----change the physical name (note: do not appear in Chinese in the path) EXEC xp_cmdshell 'ren C:\ Users\ Administrator\ Desktop\ YQBlogAA.mdf YQBlog.mdf'-----change the physical name EXEC xp_cmdshell' ren C:\ Users\ Administrator\ Desktop\ YQBlogAA_log.ldf YQBlog_log.ldf'--GO---- re-append EXEC sp_attach_db @ dbname = Noble YQBlog' @ filename1 = NumberC:\ Users\ Administrator\ Desktop\ YQBlog.mdf', @ filename2 = NumbC:\ Users\ Administrator\ Desktop\ YQBlog_log.ldf' about the method of sql statement to modify the logical name, database name and physical name of SQL Server database. I hope the above content can be of some help to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.