Do you need to:
With the Database Mover tool of SQL Admin Toolset, move or copy databases for instances of SQL Server with ease.
This is how easy it is:
When moving a database, the tool detaches the source database to copy the data files for the specified database to the target instance. The tool then attaches the database at the origin and destination instances, and copies the logins to the target instance. When copying a database or moving data files, the tool leaves the source database intact. When moving a database, the tool deletes the source database after successfully copying the database.
Watch the video for more details:
Try this yourself by downloading the free 14-day trial of SQL Admin Toolset.
Powered by IDERA