Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Where .mdf File is stored?

Author  Topic 

Akirien
Starting Member

5 Posts

Posted - 2009-07-17 : 09:00:47
I created a new database in SSMS 2005. I want to know the location of created database in computer.. Can somebody help me?


Live to learn..

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-07-17 : 09:09:18
Go to properties for the database and look where you have put it, go to the files tab and there is a path.
Go to Top of Page

Akirien
Starting Member

5 Posts

Posted - 2009-07-17 : 09:14:14
Thank you very much..
One more question.. Can I rename that .mdf and .ldf file an re-attach them from a new location?

Live to learn..
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-07-17 : 12:18:18
http://support.microsoft.com/kb/224071
Go to Top of Page
   

- Advertisement -