Error Attaching .mdf

Feb 2, 2006

I have been asked to edit a web based database and have been given the site on cd.

I have installed IIS, sql server express and Visual Web Developer express.

I am having problems getting the mdf database connected. It works at the school where they have it installed and as far as I know I have mirrored the configuration they have on one  of my test servers.

The database is in App_Data

the connection string is "Data Source=.SQLEXPRESS;AttachDbFilename=c:inetpubwwwrootApp_Datacampbell.mdf;Integrated Security=True;User Instance=True"

And the state is closed.

When I view one of the aspx pages in IE I get the following.



Server Error in '/' Application.


Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level.  This error can be caused by a virtual directory not being configured as an application in IIS.

Source Error:





Line 6: <compilation defaultLanguage="vb" debug="true" />
Line 7: <customErrors mode="Off" />
Line 8: <authentication mode="Windows" />
Line 9: <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
Line 10: <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password=" cookieless="false" timeout="20" />
Source File: c:inetpubwwwrootappcampbell_houseweb.config    Line: 8


The common error is:

"Error 1 It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level.  This error can be caused by a virtual directory not being configured as an application in IIS. c:inetpubwwwrootAppCampbell_HouseWeb.config 8 "

When I test the database connection I get a message

The header file for 'c:inetpubwwwrootApp_Datacampbell.mdf ' is not a valid database file header. The File Size property is incorrect. An attempt to attach an auto named database  for file 'c:inetpubwwwrootApp_Datacampbell.mdf ' failed.A database with the same name existsor the specified file cannot be opened or it is located on a UNC share


Any help would be great.

View 3 Replies


ADVERTISEMENT

Help - Error In Attaching Database

Jun 12, 2008

i try to attach sqlserver db but i get this error
 
TITLE: Microsoft SQL Server Management Studio Express------------------------------
Attach database failed for Server 'srvsqlsrv'.  (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.  If this is an existing database, the file may be corrupted and should be restored from a backup. (Microsoft SQL Server, Error: 5173)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=5173&LinkId=20476
------------------------------BUTTONS:
OK------------------------------
 
 
what i will do to solve this  error

View 1 Replies View Related

Attaching Db Error After Copy

Mar 4, 2005

i tried to copy the database manually by using sqldmo
here r my codes:


On Error GoTo CopySQLDB_Err

'Create Objects
Set sql = CreateObject("SQLDMO.SQLServer")
Set db = CreateObject("SQLDMO.Database")

'Connect to the server
sql.Connect strSrv, strLogin, strPwd

'Set the database object
Set db = sql.Databases(strDatabase, "dbo")

'Determine the location of database files, primary and log
strMDFfilePath = db.PrimaryFilePath
strMDFfileName = _
Trim(db.FileGroups.Item(1).DBFiles.Item(1).Physica lName)
strLOGfile = Trim(db.TransactionLog.LogFiles(1).PhysicalName)

'Clear out the database object
Set db = Nothing

'Detach database to allow copying
sql.DetachDB (strDatabase)

'Copy database files to new names
FileCopy strMDFfileName, strMDFfilePath & strNewName & ".mdf"
FileCopy strLOGfile, strMDFfilePath & strNewName & "_log.ldf"

problem comes when i tried to attach the db using enterprise manager, error come out :

"passed to log scan in database "SIPS' is invalid" come out ...what is the problem of this?

View 3 Replies View Related

Error While Attaching Database

Jul 19, 2006

hi all
i am working on sql server 2005
When i am trying to attach database in my server i am getting following error. Plz help me to fix this error.
the error as as follows :

Attach database failed for Server 'myserver'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'ReportServer'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

View 2 Replies View Related

Error While Attaching Database

Jul 19, 2006

hi all
i am working on sql server 2005
When i am trying to attach database in my server i am getting following error. Plz help me to fix this error.
the error as as follows :

Attach database failed for Server 'myserver'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'ReportServer'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

View 1 Replies View Related

Error Attaching .mdf File...

Jan 7, 2008

Attemping to reattach a recovered .mdf and associated .ldf from a crashed disk drive and I am getting the error below. I attempted to create a new db, stop the service, replace the new data files with the recovered db files and restarted the SQL service so that I could run a dbcc checkdb while the db was in suspect mode, however was unable to do this. This error leads me to belive that the log file needs to be rebuild, but that the mdf files could be a decent shape. Any help would be apprecaited. Thanks!

===================================

Attach database failed for Server 'AUTOBASEAutobase'. (Microsoft.SqlServer.Smo)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files, String owner)
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.Attach()
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SendDataToServer()

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Server.AttachDatabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)
at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files, String owner)

===================================

An error occurred while processing the log for database 'ABSystem7'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
Could not open new database 'ABSystem7'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=9004&LinkId=20476

------------------------------
Server Name: .Autobase
Error Number: 9004
Severity: 21
State: 1
Line Number: 1


------------------------------
Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

View 7 Replies View Related

Error Attaching .mdf File

Mar 6, 2008

I have a VBExpress 2008 application that uses LINQ to SQL to manipulate data in an SQLExpress 2005 database.

I successfully instatiate a DataContext object and examine its metadata through its .Mapping methods and properties. But when I attempt to set the DataSource for a BindingSource control to one of the tables, I get a run-time error.

Specifically:

Dim dc As New DiabetesData(My.Settings.DiabetesData_dbPath)

For Each mt As MetaTable In dc.Mapping.GetTables

...(examine some properties)...

Next


frmEZView.bsPrimary.DataSource = dc.GetTable(Of BGTest)()


generates the error:
System.Data.SqlClient.SqlException was unhandled
Class=14
ErrorCode=-2146232060
LineNumber=65536
Message="An attempt to attach an auto-named database for file SbearMedicalDiabetesDiabetesData2.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
Number=15350
Procedure=""
Server="\.pipe8280AA0D-38A6-41 sqlquery"
Source=".Net SqlClient Data Provider"
State=1



From the Immediate window: ?My.Settings.DiabetesData_dbPath

"SbearMedicalDiabetesDiabetesData2.mdf"


bsPrimary is a BindingSource on a form named frmEZView.


Public Class DiabetesData includes a property Public BGTests As Table(Of BGTest) and a subsequent definition of BGTest.


Can anyone tell me what I'm doing wrong?

Thanks,
--Mable

View 3 Replies View Related

Error On Attaching A Database

Jan 4, 2006

When attaching a database that was detached  from another SQL Server instance(copied raw .mdf and ldf files)..

I got the error message below:

Error 602: Could not find row in sysindexes for database ID 25, object ID 1,
index ID 1. Run DBCC CHECKTABLE on sysindexes.

how can i solve this problem. i am using SQL Server 2000

Thanks and Regards

View 4 Replies View Related

Error In Attaching .mdf Files.. How Can This Be Solved?

May 11, 2006

We've tried attaching the mdf files given to us by some customers using the script they've provided, too.

I created the database with the corresponding names, and tried to run their script. However, I get the message "The media family on device 'D:DatabaseDVVAD01.mdf' is incorrectly formed. SQL Server cannot process this media family."

What could possibly have gone wrong? Is it also possible that the file was not properly detached, or what?

View 1 Replies View Related

Error In Creating Or Attaching Database

Dec 6, 2006

I was getting following error while creating a database or attaching a database to sql server 2005

"The file <<*.mdf>> is compressed but does not reside in a read-only database or filegroup.."

In this scenario, if you try sp_attach_db procedure, you get following error:
Msg 5118, Level 16, State 1, Line 1

After
little bit of troubleshooting, I found this was happening because of a
folder option (of the folder where database file reside (in case of
attach) or being created (in case of create)).

Go to folder
properties, General Tab, click on Advanced button,check "Compress or
Encrypt attributes" section. If the first option (Compress contents to
save disk space) is checked, you get that error. Uncheck it to fix that
problem.

View 1 Replies View Related

Syntax Error Attaching Database - T-SQL

May 20, 2008

Hi all,

I'm trying to attach a database file and it's associated database log file to SQL Server. However I am using the 'SQLDataRoot' value from the registry to determine the absolute path to the DB file and DB log file. Like so...

USE [master]

DECLARE @RC int

/* read path to SQL Server Express Data directory from registry */
DECLARE @sql_server_data_dir sysname
EXEC @RC = master..xp_regread N'HKEY_LOCAL_MACHINE',N'SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1Setup',N'SQLDataRoot', @sql_server_data_dir OUTPUT
SET @sql_server_data_dir = @sql_server_data_dir + N'Data'

CREATE DATABASE [PROJECT_DB] ON
(FILENAME = '''' + @sql_server_data_dir + 'PROJECT_DB.mdf'''),
(FILENAME = '''' + @sql_server_data_dir + 'PROJECT_DB_log.ldf''') FOR ATTACH;

GO

I have also tried using the sp_attach_db stored procedure as follows

EXEC @RC = dbo.sp_attach_db 'PROJECT_DB',
'''' + @sql_server_data_dir + 'PROJECT_DB.mdf''',
'''' + @sql_server_data_dir + 'PROJECT_DB_log.ldf'''

They both the error:

Msg 102, Level 15, State 1, Line 18
Incorrect syntax near '+'.

The quotes in the calls are single quotes not double quotes in case someone queries that. Thank you.

Regards,
Paul

View 3 Replies View Related

Error When Attaching Adventure Works Database

Oct 14, 2006

Hello Everyone,

I am very new to SQL and just completed an install of SQL 2005 Express. After install, I downloaded the Adventure Works database and attempted to attach through both the Object Browser (right-click 'Databases'--->'Attach') and by running the script that is located on the SQL download page where I got the Adventure Works db.

Here's the error that I get:

"Could not find row in sysindexes for database ID 8, object ID 1, Index ID 1. Run DBCC CHECKTABLE on sysindexes."

I have attempted to go through the help files, but unfortunately the above message is too cryptic for me and I have no idea what it's telling me.

Can someone help?

Thanks!!

View 6 Replies View Related

Access Denied Error Attaching An Existing MDF

Apr 25, 2007

I guess I messed up somehow, but I am not sure how to fix this.

On Vista, with SQL Server 2005 Developer Edition, I created a 6GB database and loaded it up with data. I then decided that I wanted to burn a copy of the files, so I detached (no problem.) But when I wanted to copy the physical MDF and LOG file to another folder. Vista said I did not have access to the folder, but if I hit continue, no problem--it would correct the situation. I did. I copied the files (no problem), but now when I go to reattach to the MDF (that is still in the Data folder), I get a "CREATE FILE encountered operating system 5 (Access is denied)" error. I checked permissions and SQL Server has full rights. I am the only user on the system (Admin), and the files do not appear to have anything weird set (read only, advanced permissions, etc.)

What did I do wrong? And how do I fix this? Oh the joys of advanced Vista security features Even the admin is locked out now.

Thank you for your help!
Michael

View 8 Replies View Related

Getting Error On Mail Task While Attaching File Of Size &&> 2MB

Mar 14, 2007

Hi,

can any one help me , i am facing an issue on SSIS mail task, i want to attach a file of size 2 MB. it's getting error :

[Send Mail Task] Error: An error occurred with the following error message: "The operation has timed out.".

thanks,

sun.

View 4 Replies View Related

Attaching DB's To Sql Server Management (User Instantances) Error

Apr 2, 2007

I have been working on a website in Visual Studio 2005 Pro using the MS SQL Server that comes with VS. I have tried Attaching those MDF files in Visual Studio to the SQL Server Express Management but it wont let me, get an error::



Error Number: 5133
Severity: 16
State: 1
Line Number: 1



TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Attach database failed for Server 'WYATT-PCSQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

Directory lookup for the file "C:UsersWyattDocumentsVisual Studio 2005WebSitesAdultUnderWorldApp_Dataaspnetdb.mdf" failed with the operating system error 5(Access is denied.). (Microsoft SQL Server, Error: 5133)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5133&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------




Here is the info for the Web.config Connection Strings::



<connectionStrings>

<add name="Personal" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient" />

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" />

</connectionStrings>



I want to attach the above databases into the SQL Server Management Studio,so how can i go about doing this??



View 1 Replies View Related

Error In Attaching MSDE Database To SQL Server 2005 Express

Jul 3, 2006

I'm trying to attach a MSDE 2000 database to SQL Server 2005 Express.

I simply issue sp_detach_db XXX where XXX is the name of my MSDE database. Then sp_attach_db or create database ... with attach and both way gets the following message:

Event ID. : 3415

Description: Database 'XXX' cannot be upgraded because it is
read-only or has read-only files. Make the database or files writeable, and
rerun recovery.

What does it mean?

Thanks for any help,

Peter

View 4 Replies View Related

BIDS Noob Requesting Help With Error Attaching Auto-named Database

Apr 25, 2008

Greetings, helpful people of the Internet.

I'm learning to use BIDS, and have been going through the exercise in Chapter 19 of the book Professional SQL Server 2005 Integration Services. I'm probably in over my head with this since I've never used any SQL services/software before, but the company I'm interning at wants to build a workflow using SSIS, and for some reason unbeknownst to me, I volunteered to train myself for the task. I'm at a part in the book exercise where I'm editing one of the components of a Data Flow task - an OLE DB Destination. When I try to select the table/view in the editor for this, it gives me the following error:


€œAn attempt to attach an auto-named database for file C:Documents and SettingsgroseMy DocumentsVisual Studio 2005ProjectsCase Study ExerciseCase Study ExerciseCase Study.database failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.€?


When I googled this, most people seemed to be getting it through other SQL software, so I'm not sure if the error has the same cause or not. I know that the file in the above error message already exists, but I don't understand why the task editor won't just let me select a database that already exists so I can complete the component. Can anyone explain this to me?

View 1 Replies View Related

SQL Server Management Studio Express On Vista Home Premium (Error On Attaching And Detaching .mdf)

Sep 5, 2007



I have SQL Express 2005 SP2 installed in my Vista Home Premium. I am using SQL Server Management Studio Express to manage .mdf.

When I click "Add..." to attach .mdf database, I have this prompt error message :

The server principal "My-PCMyName" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916)


I have elevated the rights, "Run as administrator", of my SQL Server Management Studio Express, but still having problem.

I also encounter security error when detaching the existing .mdf :
The EXECUTE permission was denied on the object 'sp_detach_db', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)


Please advice. Thanks.

View 8 Replies View Related

Error Attaching Adventureworks Database And SSIS Training Database

Oct 4, 2006

Hi there,

I got this error when i tried to attach the adventureworks database and SSIS training database.

an exception occurred while executing a transact-sql statement or batch
(microsoft.sqlserver.connectioninfo)

could not find row in sysindexes for database ID 17, object ID 1, index ID 1. Run DBCC
checktable on sysindexes.



I join join a network domain for my computer. Previously it doesnt have this problem.

View 1 Replies View Related

Re-Attaching DB

Aug 10, 2005

Forgive my ignorance, but I'm just working thru some examples, and I tried to reattach a db to another server, without the log file I created for the db. Having reattached it, it worked fine - without the log file??? Where does it make any log records? Why didn't it complain?

View 3 Replies View Related

Attaching MDF Without LDF

Oct 27, 2005

Hi GuysI'm recovering from a hard disk crash, trying to reattach recoveredfiles.The MDF file seems fine, but I get:"Server: Msg 9004, Level 23, State 1, Line 1An error occurred while processing the log for database'NetCoverAdmin'."when I try to include the LDF file. My command was:EXEC sp_attach_db @dbname = N'NetCoverAdmin',@filename1 = N'c:Program FilesMicrosoft SQLServerMSSQLDataNetcoverAdmin_Data.MDF',@filename2 = N'c:Program FilesMicrosoft SQLServerMSSQLDataNetcoverAdmin_Log.LDF'Is there any way I can restore the database without the LDF file?My backups where on another disk that mysteriously failed at the sametime, so I have to work what I got...Any help appreciated!!Thanks

View 2 Replies View Related

Attaching Files

Jun 21, 2005

I have just started using ASP.net.I have to develop a system that attaches word and PDF files to form.  I also need to be able to do a full text search on the documents attached.I'm currently using SQL server 2000 as my backend DBMS, but I have never used it to attach files. My mates recommend using BLOGS but I'm not sure how to do this and I'm not sure if I can do a full text search using this solution.Could some body please recommend a solution to get me started.Thanks in advancedPaddy

View 1 Replies View Related

Attaching 6.5 Databases To 7.0

Mar 17, 2001

Hi there:

Can any one help me for attaching the 6.5 databases to 7.0

Thanks,Jay

View 3 Replies View Related

Re-Attaching Databases

May 5, 2004

Haven't posted in a while but got great advice the last time I did - http://www.dbforums.com/t573220.html
I hope someone can give me some advice this time.

Due to a flawed Microsoft hotfix the o/s on which my SQL Server was trashed completely causing me to lose some databases completely. The o/s and SQL Server have now been reinstalled (same version as before).

I have about 716 databases and logfiles which I need to re-attach to the server. I don't have the old master db or a db of all the database names. I was thinking I could write an asp script using FSO to get all the database & log file names & paths and attach them using sp_attach_db.

If anyone knows an easier way to do it or has advice to give, I would be really greatful.

View 5 Replies View Related

Detaching And Attaching

Dec 10, 2006

Hi,
Im not new to SQL Server but I am new to v.2005. We have done a class project and to finish up I am creating schemas, logins and different user roles and permissions.
I now need to detach the DB and send it to our team leader for submission. I'm scared to do this because I don't know if all the logins and passwords I've created will appear in it's new location. Will they be there in the new server's security folder just as I created them or will they dissapear into the ether?
Signed:
Sweating very much


It is better to be prepared and not have an opportunity than to not be prepared and have an opportunity

View 7 Replies View Related

Renaming While Attaching

Apr 26, 2007

I am using SQL Server Management Studio with SQL Server 2005. On my development SQL server, I have developers using a database named TestData. An off-site developer has sent new versions of TestData.MDF and TestData.LDF. I want to attach this new database to the same development server for testing, without overwriting the existing database in use by the developers. How can I rename this new TestData to something like TestDataNew while attaching it? I only have the MDF and LDF files.

Thanks.

View 2 Replies View Related

Attaching A Database

Apr 2, 2008



The situation :
I am making mass changes to my program and database.
The goal is to not make changes to the database at the customer sites, but to clone their current database, and work with that one.

The solution:
I wrote code and queries to detach the database, copy it to another directory on the same computer with a different name, then attach it with the new name.
The process is:
run : sp_detach_db "' + aDatabase + '", ''false'';' (aDatabase is the original database name)
Then, in code, delete the original .ldf file, and copy the database.mdf file to new directory with new name.
then run (for both the new and the original databases):

Create Database "' + aDatabase + '" on
(NAME = ''' + aDatabase + ''', FILENAME = ''' + FormatFilePath(aPath) + aDatabase + '.mdf''
For Attach

This works, up to a point.
The problem :
When I inspect the properties of the newly attached database, with the new name and new directory, the logical name of the database is still the original name.


I TRIED running this query :
sp_attach_single_file_db @dbName= "' + aDatabase + '",'
@physname= ''' + FormatFilePath(aPath) + aDatabase + '.mdf'

but it returns(even though I have deleted the .ldf files for the original dataset) :
Could not open new database 'Test62'. CREATE DATABASE is aborted.
Cannot create file 'E:Data6Test62Test62_log.LDF' because it already exists. Change the file path or the file name, and retry the operation.
File activation failure. The physical file name "E:Data6TestTest_log.LDF" may be incorrect.

(original database name = data6 est est, new database name is data6 est62 est62)
Is there a way to do this? Or do I just need to give it up?

View 1 Replies View Related

Attaching DB Without .ldf File ???

Aug 12, 2006

hi !!

I want to attach database to SQL Server, but I'hv only .mdf file.

I lost .ldf file, how should i attach this DB to server ?

Thanks

SP



View 38 Replies View Related

Help Attaching The Database

Oct 11, 2007



hello
i am having a problem attaching database.
The Problem :


I have created a database using sqlserver express edition.now i have installed enterprise edition ,so i am attaching the database which is created in sqlserver express edition into the enterprise edition.it is showing error


TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'SRINIVAS'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 13, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'FMS'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Can anyone Help me

thanks

View 1 Replies View Related

Attaching A DB In Express 2005

Jun 14, 2007

I am having trouble attaching a db to ms sql express 2005.I have the db in a folder deep down in my drive, within an asp.net website project. For some wierd reason i can't drill down more than two levels to get to the DB Anyone have any ideas why? Ilan   

View 3 Replies View Related

Attaching DB And Mapping Users

Oct 15, 2007

I am trying to attach a db to SQL Server 2005 and assign a User to the DB that can read and write.  I am using one user (CreateDBs) to attach the DB and a second user (TestUser) to do the reading and writing.  I run the following code and the DB is attached but I get the following error when I run the code below.
********************ERROR********************
System.Data.SqlClient.SqlException: Cannot open database "hello2" requested by the login. The login failed.
Login failed for user 'CreateDBs'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at NewSite.submit_Click(Object sender, EventArgs e) in X:InetpubRMA4NewSite.aspx.vb:line 120
 
********************CODE********************
'Need to attach to SQL Server
Dim objConn As New SqlConnection("Server=Web-testbedSQLExpress;uid=CreateDBs;pwd=ABC123;database=master")
objConn.Open()Dim objCmd As New SqlCommand("EXEC sp_attach_db @dbname = N'" & sitename & "', @filename1 = N'X:sites" & sitename & "Database" & sitename & ".mdf', @filename2 = N'X:sites" & sitename & "Database" & sitename & "_log.ldf'", objConn)
objCmd.CommandType = CommandType.Text
objCmd.ExecuteNonQuery()
objConn.Close()objConn = New SqlConnection("Server=Web-testbedSQLExpress;uid=CreateDBs;pwd=ABC123;database=" & sitename)
objConn.Open()objCmd = New SqlCommand("EXEC sp_addrolemember db_datareader, TestUser", objConn)
objCmd.CommandType = CommandType.Text
objCmd.ExecuteNonQuery()
objConn.Close()objConn = New SqlConnection("Server=Web-testbedSQLExpress;uid=CreateDBs;pwd=ABC123;database=" & sitename)
objConn.Open()objCmd = New SqlCommand("EXEC sp_addrolemember db_datawriter, TestUser", objConn)
objCmd.CommandType = CommandType.Text
objCmd.ExecuteNonQuery()
objConn.Close()
 
It still doesn't work if I use sa as the user.  I know I am missing a step, what is it? 

View 2 Replies View Related

Attaching .mdf To SQL Server 2005???

Feb 27, 2006

If I only have a .mdf file available, how can I attach it to SQL Server 2005? It keeps asking for a .ldf file which I don't have.This one's related to post http://forums.asp.net/1210138/ShowPost.aspx

View 5 Replies View Related

Attaching Old DBs After Server Re-install

Feb 24, 2000

Hi. I'm just learning SQL Server. I built a db last week, then had to reinstall SQL Server in a new O/S this week(Win 98, if it makes any difference. was WinNT.). How can I get my new SQL Server to recognize the db? Can I do this in Enterprise Manager? Thanks for any help...

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved