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

Today, I will talk to you about how to rename the SQLServer database, many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

The first step, backup database, open enterprise manager-right a database-- all tasks-- backup database-- purpose-- backup to choose to add-- enter a backup file name (note, if there is a file name, to delete it)-OK

The second step is to restore the database, specify a new library name, and modify the physical file name. Enterprise Manager-right click "Database"-all tasks-restore Database-enter the restored database name xuebuyuan.com in "restore to Database"-restore Select "Slave device"-Select device-add-add your backup File-OK Go back to the interface of database restore-- backup number-- Select content-- Select what you want to restore that backup-- option-- change the physical file name in "move to physical file name" to the file name of your data file to store. Change it to xuebuyuan.com_Data.MDF (database file) and xuebuyuan.com_Log.LDF (log file)-- if the database you want to restore already exists, select "Force restore on existing database"-- OK.

Third, modify the logical file name. If you want to change the logical file name, you can enter alter database [xuebuyuan.com] modify file (name='Admin10000_Data', newname='xuebuyuan.com_Data') alter database [xuebuyuan.com] modify file (name='Admin10000_log', newname='xuebuyuan.com_log') in the query analyzer.

Step 4, finally delete the old database jb51

After reading the above, do you have any further understanding of how to rename the SQLServer database? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.