How to attach/detach databases in SQL Server instance

by Jagadish Pulakhandam on 9/22/2011 1:48:21 PM
Rated 0 from 0 votes
Brief: Demonstrates on detaching and attaching databases using SQL Server Management Studio
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:
  • Detaching a database
  • Moving database files to a new location
  • Attaching a database (back to the instance)
NOTE: When a database is detached (from SQL Server instance), no one will be able to connect/operate against that database.

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
0

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