[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 167
  • Last Modified:

Need to copy 200 databases from one SQL server to another using SQL Server Management Studio.

Need to copy 200 databases from one SQL server to another using SQL Server Management Studio. How to do that in an easy way?

0
TANGLAD
Asked:
TANGLAD
  • 3
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
You cn use Database copy wizard
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Right click on any of those databases -> Copy database
this will introduce the wizard window, choose source and targets, choose the dbs (Make sure that the Agent service is running on the target machine  )
0
 
TANGLADAuthor Commented:
Okay. So I start SQL Server Management Studio on the new server (target) and connects to both servers. Then I choose any of the DB's from the source server and right-click -> Copy database, sellects all the wanted DB's and follow the Wizard.

Is that correct understood?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
from your source machine  right click on any of the source dbs -> all tasks -> copy database
0
 
TANGLADAuthor Commented:
Thanks
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now