In the first part of this article we showed you the best way to move database files. Now we're going to show you the other way and briefly discuss a third way, though you'll never use it… at least you'd better not.
What kind of cloud are you? Take our quiz to find out how Microsoft® cloud services can help you offload commodity workloads, manage security capabilities and "shadow" IT applications, and generally give your department the freedom, agility, and flexibility to grow your business. Let's get quizzical.
How can Microsoft's cloud services help you?Take the quiz and find out...
Detach/Attach
There's a real difference between taking a database offline and detaching it. Setting a database offline merely changes a value in the sys.databases table in the master database. Detaching a database actually removes the entry for that database, so it stands to reason that re-attaching a database can be a bigger ordeal than just bringing it back online. For starters, there are some restrictions; you can't detach a database if any of the following conditions exist:
- Database is a system database
- Database is being mirrored
- Database is [...]
No comments:
Post a Comment