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
 Database Design and Application Architecture
 How do I save my database as a .mdf?

Author  Topic 

spmchugh82
Starting Member

13 Posts

Posted - 2009-02-19 : 17:58:13
I have a database. I need two things from it.

Thing 1.) I need to be able to locate it on my hard drive
Thing 2.) I need it to be in .mdf format.

I am new to SQL Server so hopefuly that is why I can't figure this out. I can save the solution. But I need to save just one database in the solution as a .MDF file.

Someone told me that if I could create a table in the database then the .mdf file was already created but

Ting 1.) I need to be able to locate it on my hard drive

got in the way (if it was actually created which I doubt it was)

Would you please help? I have been ******* with this stupid thing for an hour and a half and all I need is a *** **** .mdf file.

Thank you!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-19 : 18:09:23
Duplicate, locking thread.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -