Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
How to Attach Database SQLServer 2005 Express
February 23, 2011
i have to attach database to created in mssql Server 2005 (Express Edition) which is created in mssql server 2005. is it possible?
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
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
To post reply
Related Questions Related Questions
How to validate username and passsword from database using ASP.net C# Sqlserver-2005
How to take Backup of Database at runtime... SQL-2005....
Sql Server 2005 to sql 2000 database conversion
About MS SqlServer 2005
Retrieve values from database and store it into checkboxlist control in asp.net 2005?
Datatable to sqlserver database in vb.net
database attach to exe
How to make Exe and Attach database to it
Enable DataBase Mail in SQL Server 2005
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend