Thursday, December 3, 2015

Attaching a database in SQL Server Management Studio


Databases > Attach

Make sure the database is in the folder that has not permission restriction, give the target db the new name and make sure the ldf file is present at the same location. And for Current File Path pick the correct location where the .mdf file is at. By default it shows irrelevant path.



No comments:

Post a Comment