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

Editor to share with you how to copy the database SQL Server Management Studio, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

It looks like a good start.

The process of finding the replication database is very simple. Right-click the database on the SSMS and you can find the option to copy the database in the task. Click to enter a very friendly graphical interface.

Select the source database server and the target database server in turn, which is similar to the task of SSMS. It seems that it is not complicated to replicate databases across servers. Click next and prompt

OK, then go to the SQL Server configuration Manager (SQL Server Configuration Manager) to open the SQL Server agent (which can also be opened in the system service). After opening it, you can proceed to the next step normally. Pay attention to the warning. Because it is a warning and the development environment, try to ignore the warning to see if it works.

Select the name and entity location of the target database, and then go all the way to the next step (you can choose to output to the Windows log. When I try not to select it, I can see the result in the SQL Server log. After selecting it, I can only read it in the Windows log.)

Sure enough, failure, and success without twists and turns

Sure enough, failed, go back to see the warning ignored

"to use the detach and attach method, the Integration Services agent account used to run the SQL Server agent job must have access to the file systems of the source and destination servers"

OK, observe that the user of the SQL Server agent (which can be seen in the SQL Server configuration manager and also found in the system service) is NT SERVICE\ SQLSERVERAGENT.

You can find the user in the security-user name of SSMS, click on the user attributes, and find that there are only sysadmin and public roles, but no diskadmin roles.

Originally, it should be OK to check the diskadmin role, but because I don't know much about the SQL Server agent, since the installation is not selected by default, then keep it as it is, and database replication is not commonly used. I temporarily changed the user of the Server agent to a local user to re-perform replication.

OK, copied successfully. Change the user of the SQL Server agent back to NT SERVICE\ SQLSERVERAGENT again.

These are all the contents of the article "how SQL Server Management Studio replicates databases". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.