I'm brand new to SQL and I'm practicing some queries with a DB. I've now just detached the database using Tasks > Detach Question 1: When I detach a file, I'm guessing it's saved to an MDF file? Where would I locate this file? Question 2: When I create a new DB, where do the related files get saved? I'm assuming an MDF and an LDF set of files are created. If it helps, here's my version info <blockquote> Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) </blockquote> Thanks!

Ok so if you have already detached the database, and then realized that you are clueless where it is, you can do this trick. <ol> <li>Expand server, then on <code>Databases</code> click <kbd>Right Mouse</kbd> then choose <code>Attach...</code> </li> <li>Click <code>Add...</code> </li> <li>Then in the new window that opens will be a path to the directory where your detached database is (if you haven't navigated from default location earlier)</li> </ol> Also, the default location for MSSql databases is: <code>C:\Program Files\Microsoft SQL Server\[YourSQLVersionGoesHere]\MSSQL\DATA</code> <img src="https://i.stack.imgur.com/htSqJ.png" alt="enter image description here"> <img src="https://i.stack.imgur.com/ekDLi.png" alt="enter image description here"> Hope this saves you some time.

You can always look at the database properties in your Object Explorer in SQL Server Management Studio before detaching - the file(s) will not be moved or anything when detaching.... <img src="https://i.stack.imgur.com/LIbAi.png" alt="enter image description here"> In the <code>Properties</code> dialog box, go to the <code>Files</code> section and to your right, the relevant info can be found: <img src="https://i.stack.imgur.com/TYy7n.png" alt="enter image description here">

Beginner's SQL: How do I find a detached database?

2 Answers

Ok so if you have already detached the database, and then realized that you are clueless where it is, you can do this trick.

Expand server, then on Databases click Right Mouse then choose Attach...
Click Add...
Then in the new window that opens will be a path to the directory where your detached database is (if you haven't navigated from default location earlier)

Also, the default location for MSSql databases is:

C:\Program Files\Microsoft SQL Server\[YourSQLVersionGoesHere]\MSSQL\DATA

enter image description here

Hope this saves you some time.

169

answered Oct 21 '22 20:10

Matas Vaitkevicius

You can always look at the database properties in your Object Explorer in SQL Server Management Studio before detaching - the file(s) will not be moved or anything when detaching....

enter image description here

In the Properties dialog box, go to the Files section and to your right, the relevant info can be found:

enter image description here

answered Oct 21 '22 21:10

marc_s

Related questions
                            
                                Mapping to varchar and nvarchar in hibernate
                            
                                SQL Server ARITHABORT
                            
                                C++ Access to SQL Server from Linux
                            
                                In SQL, are there non-aggregate min / max operators
                            
                                How to identify invalid (corrupted) values stored in Oracle DATE columns
                            
                                'invalid for creating a default constraint' error when trying to add a constraint to an existing table
                            
                                INSERT of 10 million queries under 10 minutes in Oracle?
                            
                                Analysing/Profiling queries on PostgreSQL
                            
                                PostgreSQL obtain and release LOCK inside stored function
                            
                                Split Table into many to many relationship: Data Migration
                            
                                How can I limit DBeaver Data Editor to limit result set size?
                            
                                What is the best way to partition large tables in SQL Server?
                            
                                How to best handle the storage of historical data?
                            
                                rails union hack, how to pull two different queries together
                            
                                Get Number of Rows from a Select statement
                            
                                Adding a new row Using SQL Server Management Studio?
                            
                                SQLAlchemy - ObjectDeletedError: Instance '<Class at...>' has been deleted. Help
                            
                                Why can't I GROUP BY 1 when it's OK to ORDER BY 1?
                            
                                sqlcmd script with spaces in filename
                            
                                Explanation needed for missing rows with left join and count()

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With

Beginner's SQL: How do I find a detached database?

Tags:

sql

sql-server-2008

Ray

People also ask

2 Answers

Matas Vaitkevicius

marc_s

Recent Activity

Donate For Us