How to copy whole/entire database from one SQL Server instance to another

by Jagadish Pulakhandam on 9/23/2011 7:35:31 AM
Rated 0 from 0 votes
Brief: Demonstrates on copying an entire database from one SQL Server instance to another
Posted to: Microsoft SQL Server - Quick Learn ("How to"s for Developers)
Add to DiggAdd to del.icio.usAdd to FURLAdd to RedditAdd to YahooAdd to BlinklistAdd to GoogleAdd to ma.gnoliaAdd to ShadowsAdd to Technorati

Attached video demonstrates the following:
  • Shows SSMS connected to three (SQL Server) instances
  • Uses "Copy Database" feature in SSMS to copy database from one instance to another
  • Copying Database using SMO method (and not attach/detach method)
NOTE: You need to have "SQL Server Agent" of both source and destination instances to be running in order to use "Copy Database" feature.  You can always check the current status of "SQL Server Agent (instancename)" by opening Start || Programs || Microsoft SQL Server 2008 || Configuration Tools || SQL Server Configuration Manager

Join the .NET Code Central Community and join the discussion!
Signing-up is FREE and quick. Do it now, we want to hear your opinion

Rated 0 from 0 votes ( login  to rate)
DotnetKicks DotnetKicksDe DotNetShoutout

Video/Screen Recording (may not have audio narration/annotations)
You need to Login or Join for FREE to download the following