SQL Server Management Studio (Attaching a DB)

How to attach a database: In SQL Server Management Studio, after you’ve connected to a server, right click databases and attach a database (see image). Click Add, find the database and click ok. Note: if the database didn’t come with a log file, then remove the log file from the ‘Database details’ section. You may also get an ‘access denied’ error, if so you must edit the security properties of the file so that every group has full control of the file.