This topic has been archived. It cannot be replied.
-
工作学习 / IT杂谈 / Help!!!! How to open the files with suffix "MDF" and "DB". They look like some kind of Database file. Thanks
-oceandeep(北极熊® Zzz Zzz);
2002-12-13
(#911538@0)
-
SQL server
-canadian(有多少中国人懂得自由);
2002-12-13
(#911548@0)
-
or sybase
-canadian(有多少中国人懂得自由);
2002-12-13
(#911549@0)
-
If it's a sybase one, do I have to open it under sybase enviorment?
-oceandeep(北极熊® Zzz Zzz);
2002-12-13
(#911574@0)
-
SQL Server database file. you need to restore it in SQL Server.
-luoboyang(萝卜秧);
2002-12-13
(#911551@0)
-
I am in sql enterprise manager now, but I don't know how to restore ittools-------data transformation service------import?
-oceandeep(北极熊® Zzz Zzz);
2002-12-13
{52}
(#911557@0)
-
tools-------restore database, then select from device, -> select your file
-luoboyang(萝卜秧);
2002-12-13
(#911587@0)
-
错。.MDF不可能被restore，只能被attach, run sp_attach_db @dbname=?, @filename=*.mdb.
-yangn(Raymond);
2002-12-13
(#911904@0)
-
da lao, can you explain what you said in detail. Where can I key in these commands and how. Thank you so much
-oceandeep(北极熊® Zzz Zzz);
2002-12-13
(#911934@0)
-
Details1.Open your query anylyzer and run the following:
use master
sp_attach_db @dbname='database name',@filename1='.mdf file'
or
2.if you r using SQL 2000, u can open enterprise manager, select server->databases-all tasks->attach databases
-yangn(Raymond);
2002-12-13
{243}
(#911971@0)
-
sorry, 我忘了说mdf了，我说的是DB。而且，对于mdf 如果要attach的话，最保险的是sp_attach_singlefile。
-luoboyang(萝卜秧);
2002-12-13
(#912003@0)