how to create MDF file of database

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

SQL Server 2005 Forums

SQL Server Administration (2005)

how to create MDF file of database

Author

Topic

abul_mohsin
Starting Member

21 Posts

Posted - 2014-01-20 : 04:06:24

Dear
I need to create MDF file of database
i have a sql server 2005 database i am using sqlserver 2008 management server, i need to convert the database to MDF file .
please provide some help and useful links.

Thanks & Best Regard's
Abul Mohsin

Thanks & Best Regard's
Abul Mohsin

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2014-01-20 : 04:47:19

A database its data IS already stored in an mdf file.
In Management Studio / Object Explorer right click on your database then click "properties" then click on "files" and you will see...

Too old to Rock'n'Roll too young to die.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-01-20 : 07:02:45

duplicate of
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=190810
please dont crosspost

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

abul_mohsin
Starting Member

21 Posts

Posted - 2014-01-20 : 07:48:44

Thanks for the reply...............
i will take care of not to cross post next time.

Thanks & Best Regard's
Abul Mohsin

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources