Sample Header Ad - 728x90

What is the purpose of attaching a database?

3 votes
3 answers
1526 views
I always see this option called attach database in SQL Server. Why would someone attach a database? Why not just restore a database from the .BAK file? I guess I don't see the purpose of it. What would be the result of attaching it? It's quicker than a restore, but what is the technical result? Can you still alter the database? Add data to it? The preferred method or not recommend it? I have seen https://dba.stackexchange.com/q/11177 but nothing in there explains the purpose of attaching or detaching. It basically doesn't even touch on it.
Asked by user18139 (87 rep)
Jul 7, 2017, 09:28 PM
Last activity: May 1, 2018, 06:14 AM