• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

how do i create new SQL engine for SQL server 2008?

I have an existing SQL engine on machine ip,1433 and i am able to Attach new Database as mention above but i would like to create new SQL engine on machine,1433 and to cancel the existing one and then to attach new database which i have the MDF and Log file

what are the step to do that?

2 Solutions
Lee SavidgeCommented:
If SQL isn't installed, you need to run the SQL Installer, for which you need to buy a licence. If you only want SQL Express, then download it from Microsoft.


This is a link for SQL 2012 Express. Make sure you get the right version and understand the limitation of Express.

Please install new instance of sql server using below link:

1. http://technet.microsoft.com/en-us/library/ms143219(v=sql.100).aspx
2. http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/
3. http://www.codeproject.com/Articles/305113/How-to-Install-SQL-server-2008-on-Windows-7

After installing attach SQL Server database mdf and ldf file to a new instance.

If you want to cancel the existing sql server instance you need to un-install the sql server.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now