Viewed 1k times. Some errors often occurs: Exclusive access could not be obtained because the database is in use. The backup set holds a backup of a database other than the existing 'xx' database Does anyone encounter this case? Any advice is greatly appreciated. Regards, T. Improve this question.
Thuan Thuan 5 5 bronze badges. Add a comment. Active Oldest Votes. I always like to take the cautious approach to administration. Restore the database to the new instance. Improve this answer. John Sansom John Sansom 1, 6 6 silver badges 10 10 bronze badges. StanleyJohns StanleyJohns 5, 2 2 gold badges 19 19 silver badges 44 44 bronze badges. Sign up or log in Sign up using Google. If I type in my database name, it creates a new. Am I doing everything correct up until now?
Well, that's strange although I don't use VB so I wouldn't know how the connection works. Strange that there is no SQL Server in vb options. Just keep the thread open, I hope that somebody with vb will step in with a solution soon.
This was my original problem. The work around I proposed has been working since late December of last year even after the recent upgrade.
The content you requested has been removed. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums V. Visual Basic Express Edition. Sign in to vote. How do I connect to a database that has already been created? Saturday, May 1, PM.
Marked as answer by theskinnygimp Thursday, May 6, PM. Sunday, May 2, PM. I believe the problem is as Mary suggested. In the Attach Databases dialog box, to specify the database to be attached, click Add ; and in the Locate Database Files dialog box, select the disk drive where the database resides and expand the directory tree to find and select the. The possible icons are described in the Status description, below. Attach As Optionally, specifies a different name for the database to attach as.
Owner Provides a drop-down list of possible database owners from which you can optionally select a different owner. Status Displays the status of the database according to the following table.
Message Displays either a blank message or a "File not found" hyperlink. Add Find the necessary main database files. When the user selects an. Remove Removes the selected file from the Databases to attach grid. To verify or change the pathname of a file, click the Browse button If a file does not exist, the Message column displays "Not found.
You need to either update the file path in the database details grid to point to the correct location or remove the log file from the grid. If an. Original File Name Displays the name of the attached file belonging to the database. File Type Indicates the type of file, Data or Log.
Current File Path Displays the path to the selected database file. The path can be edited manually. Message Displays either a blank message or a " File not found " hyperlink. Copy and paste the following example into the query window and click Execute.
This example attaches the files of the AdventureWorks database and renames the database to MyAdventureWorks. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
0コメント