.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

How to Attach Database SQLServer 2005 Express

Posted By: Vikramraj     Posted Date: February 23, 2011    Points:2   Category :Sql Server
i have to attach database to created in mssql Server 2005 (Express Edition) which is created in mssql server 2005. is it possible?


Responses
Author: prakash1598             
Posted Date: February 23, 2011     Points: 5   

Yes ,one can attach the database in ms sql server2005 express edition but you must have the appropriate credential ...Step 1-> first you need copy the database in the following location
C drive:/program file/mssqlserver/mssql 1.0/data
Step2-> copy your database into data folder
There must two files one is mdf and other is log file
Step->3 now open your mssql server and configure server explorer
And right click on the database wehre you will get the attach option
Choose it
then select the database name that you want to attach
then click on the ok

now your job has been got over.




Click on the add button


Finally click on the ok
Later on you will find your data base in the sqlsever





Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend