 |  |  |  |  |  |  |  |
guidence urgently needed!
 |
Hi guys! having a hard time solving questions on attach and detach database for MCDBA certification exam 70-228.Any suggestion from any one on how to prepare for this exam will be highly appreciated!
•
•
Join Date: Aug 2005
Posts: 239
Reputation: 
Solved Threads: 5
Posting Whiz in Training
when you detach a DB, you're not deleting or losing any data, simply removing it from the management console. In most cases, once detached, you won't be able to connect via SQL Server provider.
To detach a DB, you can simply right click on the database on SQL Server, and detach. The MDB and LDB files will still exsist in the current directory.
To "attach" is when you bring over an existing MDB and LDB files, or the Database. It's new data to your server, or console, to manage.
To attach, you select attach and select the MDB file from the directory they are found.
Do you follow so far? Is that what you needed or do you need more, I can still try to help.
To detach a DB, you can simply right click on the database on SQL Server, and detach. The MDB and LDB files will still exsist in the current directory.
To "attach" is when you bring over an existing MDB and LDB files, or the Database. It's new data to your server, or console, to manage.
To attach, you select attach and select the MDB file from the directory they are found.
Do you follow so far? Is that what you needed or do you need more, I can still try to help.
|
Similar Threads
- Hamming codes encoder/decoder in C or C++ (C++)
- First complete project (Geeks' Lounge)
- URGENTLY NEEDED: PHP Whizz (Web Development Job Offers)
- Preparing for an interview and need some questions answered (C)
Other Threads in the IT Professionals' Lounge Forum
- Previous Thread: Balmer reveals Microsoft's defeat-Linux Strategy
- Next Thread: interesting tool -- for webmasters? is it?
Views: 2269 | Replies: 1
| Thread Tools | Search this Thread |
Latest IT Professionals' Lounge Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for IT Professionals' Lounge
1gbit advertising advice amazon answers archive british broadband business businessprocesses carrier censorship cern china cio collectiveintelligence connectivity consumer consumers corporateearnings css datatransfer debtcollectors dictionary digg digital ebay ecommerce email employment facebook food government grid high-definition hottub infodelivery infotech intel internet interview ipod isp japan kindle lhc library malware marketing mit moonfruit news onlineshopping php piracy piratebay pope porn program questions r&d religion remoteworking research schools security sex shopping simple skype smb sms socialmedia socialnetworking software softwareengineer spam speed ssl startrek statistics stocks study stumbleupon survey technology touch-screen touchscreen training twitter uk vbulletin videoinprint voips vulnerability web webdesign webdeveloper windows words
