Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
accesser2003
Starting Member
14 Posts |
 Posted - 2010-10-31 : 17:56:52
|
| I have a SQL Server database consists of two files:BAHRAIN_Data.MDFBAHRAIN_Log.LDFThis database was created as back-end for a system.After two years I back to the database backup and the system backup. Unfortuantely, the PC which was hosting the system and database became damaged. Thus, I forced to shift the both Backups to a new PC.Now, I need to rectify and fix all the problems arise when running the system in the backup. What I can did is to reconnect the system to the backup of the database. How can I make this using the ODBC, given that I am using MSDE 2000 and want to locate the database backup into an instance name called Bahrain. How can I add the backup of the database to the MSDE instance Bahrain, using the SQL Statements??Thanks, |
|
|
|
|
|
How can I reconnect to an existence database