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

I have an existing SQL engine on machine ip 192.168.1.133,1433 and i am able to Attach new Database as mention above but i would like to create new SQL engine on machine 192.168.1.137,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?

Thanks
Gvilbis
gvilbisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

http://www.microsoft.com/en-gb/download/details.aspx?id=29062

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

Please install new instance of sql server using below link:

1. http://technet.microsoft.com/en-us/library/ms143219(v=sql.100).aspx
OR
2. http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/
OR
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.

thanks.....
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.