Copy Database – SQL in Sixty Seconds #169

Copy Database - SQL in Sixty Seconds #169 169-CopyDatabase-YT-800x450 When I go to Comprehensive Database Performance Health Check often we have to make changes in the database as well as various objects like stored procedures or queries. While I like to work in the development environment to validate the checks, often there are no good copies of the database in the development environment. At that time I use this technique of copy database while keeping the database online. This method is very simple and efficient. Let us see that in today’s SQL in Sixty Seconds video.

Here is the video of how to copy database.

There are two important things we need to remember.

First – we need SQL Server agent enabled.

Second – we need to select copy via database object as that is the safest way to copy database.

If you accidentally select detach and attach method, your live production database may go offline for a while and also have service interruption.

Here are my few recent videos and I would like to know what is your feedback about them.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

, ,
Previous Post
9 SQL SERVER Performance Tuning Tips – SQL in Sixty Seconds #168
Next Post
Best Value for Maximum Worker Threads – SQL in Sixty Seconds #170

Related Posts

Leave a Reply

Menu