Attach Database Sql Server Error 3415
Contents |
One games Xbox 360 games PC sql server error 5123 attach database games Windows games Windows phone games Entertainment All
Sql Server Error 5120 Attach Database
Entertainment Movies & TV Music Business & Education Business Students &
Sql Server Error 9003 Attach Database
educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security
Sql Server Attach Database Error 5 Access Denied
Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Band Microsoft sql server attach database error 5171 Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business microsoft sql server error 3415 Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation how to attach database in sql server 2008 without log file Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like how to attach database in sql server 2012 you, helping each other. Join them; it only takes a minute: Sign up Error attaching a database (.mdf file) to SQL Server up vote 1 down vote favorite 1 I'm having trouble attaching a database DBName.mdf to https://support.microsoft.com/en-us/kb/2710782 a network SQL Server. The admin can manually attach the database but if I try, I get the following error message. Database 'DBName' cannot be upgraded because it is read-only, has read-only files or the user does not have permissions to modify some of the files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415) Here is my code: System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(); conn.ConnectionString = @"Server=" + SQLServerName + http://stackoverflow.com/questions/15929043/error-attaching-a-database-mdf-file-to-sql-server ";database=master;User ID=" + UserName + ";Pwd=" + Password; ; try { conn.Open(); System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand("CREATE DATABASE DBName ON ( FILENAME = '" + @"C:\DBName.mdf" + "' ), ( FILENAME = '" + @"C:\DBName_log.ldf" + "' ) FOR ATTACH", conn); com.ExecuteScalar(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } Here is the details of SQL Server - Product - Microsoft SQL Server Express Edition (64-bit) - Version - 11.0.2218.0 I can create a new database just fine but cannot attach an existing database. What am I missing here? Any help will be appreciated. c# sql-server share|improve this question edited Apr 10 '13 at 18:40 asked Apr 10 '13 at 14:43 Butters 3372821 Could you try to do it "CREATE DATABASE DBName ON ( FILENAME = '" + @"C:\DBName.mdf" + "' ), ( FILENAME = '" + @"C:\DBName_log.ldf" + "' ) FOR ATTACH" manualy? Does it work? –Dimi Apr 10 '13 at 14:47 It gives the above error if I do it. If the admin of the machine of that SQL Server does it, it works fine. –Butters Apr 10 '13 at 14:54 So you need the admin credentials to do it. Are you using here conn.ConnectionString = @"Server=" + SQLServerName + ";database=master;User ID=" + UserName + ";Pwd=" + Password; ; an ADMIN login? Perh
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us http://serverfault.com/questions/93300/sql-server-error-3415 Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up sql server and rise to the top SQL Server error 3415 up vote 3 down vote favorite When i attaching mdf file to SQL Server i am getting error database cannot be upgraded because it is read only or it has read only file. Make sure Database or files are writeable. sql-server share|improve this question asked Dec 11 '09 at 4:04 kamel migrated from stackoverflow.com Dec 11 '09 at 6:22 sql server error This question came from our site for professional and enthusiast programmers. what version are you upgrading from? & what version are you going to? –Nick Kavadias Dec 12 '09 at 3:57 add a comment| 4 Answers 4 active oldest votes up vote 3 down vote The database you attach is an previous SQL build. It has to be upgraded and it cannot be upgraded because the file is read only. share|improve this answer answered Dec 11 '09 at 4:24 Remus Rusanu 7,4981020 add a comment| up vote 2 down vote before you detach the database in the previous version. Change any read-only file groups to read-write. Microsoft also recommends that you turn on auto-grow if its disabled. After you've attached the database in the new version, can then change the filegroup back to read-only and disable auto-grow. share|improve this answer answered Dec 11 '09 at 4:30 Nick Kavadias 9,73372743 add a comment| up vote 1 down vote I had this issue when attempting to attach a sql server 2000 database to a sql server 2008 r2 server. Checked that nothing had been marked read only. Ran management studio as administrator, problem solved. The moral of my story is "Try running management