A common dilemma is to see that you have MS SQL Server 2008 installed but not the Microsoft SQL Server Management Studio on your PC, to do it go to : -
http://www.microsoft.com/download/en/details.aspx?id=7593
This link installs the Express edition which does essentially everything you need associated with MS Server 2008, as it says its an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server 2008!
What I found also is that the installation file wouldn’t install it automatically, you have to select New Install on the SQL Server 2008 Setup, and manually tick the one and only (yes one) shared feature which is Management Tools – Basic to install the Microsoft SQL Server Management Studio on your PC Desktop. Wait for 10 minutes. Voila!
Also if you are programmer, you want to test certain database files for local use in Microsoft Visual Studio 2010, and that means that you want to be able to attach the database on another server (well locally on Visual Studio 2010), then this is what you can do:
- Detach the database (right click the database and click
Detach) - Copy the mdf and ldf files to your backup location
- Attach the database (right click
Databasesand clickAttach)
No comments:
Post a Comment