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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

how to attach database from removable or external

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
how to attach database from removable or external  hard have ip address 

View Complete Post

More Related Resource Links

unable to attach database, security setting?


Hi folks,

I am using VS 2010 Professional with SQL Server 2008 Developer.  I right click on the App_Data folder in solution explorer and add an existing item, then navigate to the correct database.  However, I receive a pop up that Access is Denied.  How do I fix this? 

cannot attach database from server explorer


Hello all,

In Server Management Studio, I am attempting to attach a database.  After selecting the database in the wizard

I receive an error: This file is in use, Enter a new name or close the file that's open in another program. 

I don't have SSMS open, and have restarted the computer to make sure the memory is cleared.  Not sure what to try next.  Any ideas?

Detach/Attach database question

I recently restored a database from SQL7 to SQL2005.  When restoring the database I needed to create a c:\data\data folder or else it would not restore the mdf and ldf files. I would like to move these files to a new location.  Copied the the two files to a new folder, C:\database.  Using the sql studio manager, preformed a task to detach the database, then attach the database with the new location. This seemed to work, I am able to access my application that uses this database.  However, any changes I make to the program, are not writing changes back to the mdf file.  When I open the program, these changes are still in place, but the mdf file should be updated, correct?  When the database files were stored in the c:\data\data folder, any little change I made to the program changed the modified time for the mdf file. Is there something missing or where could these changes be written to?

attach sample database failed in sql 2008 express RTM

I'm having a trouble attaching sample database northwnd database,screen show me the error attach database failed for server 'computername\sqlexpress' additional inforamtion: the database 'northwind' cannot be opended because it is version 661.this server supports version 655 and earlier.a downgrade path is not supported.could not open new database 'northwind',create database is aborted,()microsoft sql server,error:948) my os is xp sp3,sql express version is  Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)   Jul  9 2008 14:43:34   Copyright (c) 1988-2008 Microsoft Corporation  Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)  I 'm sure database 'northwind' is ok.I can used database 'northwind' on my other computer.the other computer install express 2008R2 .    install RTM computer  ,database route is C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS,not C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. actually I 'm install sample database in sql express RTM on my computer.I just wonder why attach good database failed,how to solved this issue. http://sqlserversamples.codeplex.com/releases/view/45923 this link is avialable   thanks for you help

Cannot crawl sharepoint site and mysite after database attach upgrade form sharepoint 2007 to 2010.

After database attach upgrade site and mysite from sharepoint 2007 to 2010 , I have full crawl and get "The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly. If the repository was temporarily unavailable, an incremental crawl will fix this error. ( Error from SharePoint site: HttpStatusCode ServiceUnavailable The request failed with HTTP status 503: Service Unavailable. )" for mysite and get "Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled." for sharepoint site. The content access account for search is "db_owner" of both of site and mysite. How do I solved this problem ?

How to attach distribution database files

Hi  i am new to sql server. when i am exploring replication concepts, i did a small mistake i.e. i have deleted distribution database.after that i realised and try to create a new one but it still points to the old database named as "distribution" which is not available. i didnt take the backup of the database before dropping. But i have mdf and ldf files of the distribution database. so can i use the sp_attach method to add the  mdf and ldf files? or any other way to fix this issue? please help me on resolving this issue Thanks, Rock  

Attach database with MSSMS

I have installed SQL 2008 R2 Express and want to attach a database stored in: C:\Users\Me\Documents\Visual Studio 2010\Projects\Databases\Databases\ACME however, when I try to open the Documents and Settings folder it doesn't show the child folders. This is a real pain and I have been unable to find a solution. Any ideas?Still trying to program

database attach method migration wss3.0 to foundation 2010

I am confused in data base attach migration method for the follwoing scenario .Can you please give me clarity? it is urgent. We have a production system in wss3.0. I took  backup of the content database using sql servr management studio tool. Can I restore this content DB to a test environment ( on sun Virtual box with 'windows 7' 64-bit host OS) and from test env't to new production system?  If my testing is done and ready to move to new production system then How can I add the data accumulated during testing period (one month) to new prod'n system from wss3.0 system. Best regards,

Attach Database Error 5120

Hi- I just started a SQL class and now have SQL Server 2005 and SQL Management Express.  The teacher gave out two databases to attach but I get the following error when trying to attach either database: Attach database failed for Server 'xxx\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo) ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)      =================================== Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AP_log.LDF". Operating system error 2: "2(The system cannot find the file specified.)". Microsoft SQL Server, Error:  5120)   ------------------------------ Any help would be appreciated as I have homework that's due this week.   Thanks!

unable to attach database

Unable to attach Database (SQL Express 2005):DATABASE-->When supposed to add new database by click right button of the mouse,clicking 'Attach and in window 'Attach Databse' when I click 'ADD' Button : I receive error: Failed to retrive data for this request.(MS.SqlServer.Express.SmoEnum) Additional Information: Failed to connect to Server .....(MS.Sqlserver.express.connectionInfo)   PLEASE HELP.    

how to attach sql database file to creating .exe setup in c#

I create a Setup file and put data folder, in data folder i put database file , but the problem is i have to mannualy attach database file in sql server 2005. I have to automatically attach database file when installing setup file.

An attempt to attach an auto-named database ....\aspnetdb.mdf failed

I've installed VWD 2005(Beta 2) and MS SQL Express and also followed the aspnet tour at http://beta.asp.net/guidedtour2. After trying new webcontrol (login control) and trying to execute the page, I've got an error such as below: An attempt to attach an auto-named database for file c:\inetpub\wwwroot\Demo\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file c:\inetpub\wwwroot\Demo\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  Stack Trace: [SqlException (0x80131904): An attempt to attach an auto-named database for file c:\inetpub\wwwroot\Demo\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] Syste

Problem trying to attach database file to Microsoft SQL Server Management Studio

I was trying to attach a database to SQL Server MGT Studio and got an exception error.  The message stated that the database file I was trying to attach could not be opened because it was version 661.  The SQL Server shows to support version 655 and earlier.  It states that a downgrade path is not supported. Question:  Is there some download ; fix; I can make to SQL Server 2008 that will allow me to attach the version 661????  I am not technical at all.  Please speak slowly.  :)  Thanks

Can't connect to an external database



We have a sharpoint site hosted on our company's central shaerpoint server (not MOSS). We have a MS SQL DB running on one of our local servers.

I need to coneect to this DB, so through Sharepoint Designer, I try to connect to a data source. But it always fails to connect to this DB. However, I tried the same connection through VisualStudio, just to check, and it was able to connect to the DB.

Am wondering is it because the DB is not on the same server as the shareopint, so is this because of some trust relates issues? In any ways, is connecting to the DB from the SPD as data source the only way to connect to it?

What am I doing wrong here to get the conncetion going? Any inputs appreciated.


C# Database created but does not show up in Server Management Studio unless I manually attach it.


I used C# Linq to Sql to create a database. I look on the hard drive and the database .mdf and .ldf files are there. I open Server Management Studio 2008, attach to SQL express and the database is not there unless I actually attach the database.


First, is this correct behavior?

Second, is it possible to create a Sql Express database that is automatically registered(?) in Management Studio? If so, please give pointer.


Thanks very much.



Cannot attach a database file to SQL server 2008 Express


When I try to attach a database using SQL server 2008 express version, it gives me an error message.  it says

"Msg 18456, Level 14, State 1, Server LINDA\SQLEXPRESS, Line 1
Login failed for user 'LINDA\Linda'"

How can I fix this error?


About database attach upgrade method




I'm planning an upgrade from MOSS 2007 to Sharepoint 2010 with database attach method and I would like to know what happens with links inside content pages and documents (words, excel, etc...) that points to the own site. Must we change the url host once we have finished to upgrade process in the new farm?. I suspect no, because I have meet some other experience attaching content database between MOSS 2007 farms and the host url has been updated (I don't know why) .

Where can I found information about it? Anyone has any related document?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

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