p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   problem with mdf file (http://p2p.wrox.com/showthread.php?t=12425)

Rahil April 29th, 2004 09:11 AM

problem with mdf file
 
hi all,

can i use the .mdf file again in new sql server.

i have my databse in data folder of sql server but i can't see in the enterprise manager.

so pls help me out

Regards
Rahil

Rahil April 29th, 2004 09:48 AM

i solved the problem
by using
sp_attach_single_file_db armandb1, 'c:\ebook\data\warmandb_Data.mdf'
this syntax.

Regards
Rahil and Tejas

defiant April 29th, 2004 11:03 PM

there is also an "Attach Database" right-click menu option in SQL Server Enterprise Manager, right next to "Backup Database" and "Restore Database".


All times are GMT -4. The time now is 07:51 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.