MS SQL Server 2008 R2 new Instance

[Bumbzy]

Machanla podi udauwak one..

Mehemai seen eka....server ekaka establish karapu sql server instance ekak ewidiyatama wena machine ekaka establish karanne kohomada...mata machan company eke testing purposes walata wenama machine ekaka system eka daganna ona wela tiyenawa machanla..vendor karayo testing karala version out karanne na..eka nisa mage environment ekakama sql server dagena test karagannai one...kohomada meka karanne machan....physical server clone karatat hari giye na..Need help machanla

 

[Bumbzy]

bump

Thanks machan

 

[gtx]

uba use karanne sql server database eka vitharak nam backup ekak gahala, wena machine ekaka SQL server install karala gahapu backup eka restore karanne
What purpose you are using sql server?

 

[Bumbzy]

man ehema karala baluwa machan...but system eke call karana instance ekama e sql server eket tiyenna onaneda....e tiyena widiyema instance ekak hadagannekohomada...machine name ekat same wenna ona neda...the purpose is to implement a testing environment. ekama wenasa tiyenne test environment eke network agent eka duwanne na. but local VM eke witarak duwanawa...and thanks for the reply machan..

 

[JacknJill]

Ekko application eken connection string wenas karala dapan aluth server ekata point karala. Nathnam e host name Ekenma n e instance name Ekenma aluth server instance eka hadapan. Authentication kohomada kiyala nam danne naha

 

[The_Killer]

Ekko application eken connection string wenas karala dapan aluth server ekata point karala. Nathnam e host name Ekenma n e instance name Ekenma aluth server instance eka hadapan. Authentication kohomada kiyala nam danne naha

uba use karanne sql server database eka vitharak nam backup ekak gahala, wena machine ekaka SQL server install karala gahapu backup eka restore karanne
What purpose you are using sql server?

Mehema karanna

 

[gtx]

machan mama loku expert kenek newai but Machan system eka call karanne server name ekata thiyene instance ekata ubala akama network eka same name thiyene instance 2k thiya ganne ba.(at the same time)
Machan uba purpose eka test environment ekak nam entire applciation ekatama seperate test environemnt ekak thiyenne oni.
ubata database eka vitharak wenas karala eka nama dunna kiyala front end(user interact) aplication eka danne nane. eka parna vidiyatama original DB ekata data operation karanawa.
normal application gaththama sql server eka use karanne db ekak vidiyata. thawa sql wala Business intelegence part ekak thiyenewa SSIS, SSRS, SSAS.....uba use karanne monawage syste ekak da kiyala danne nathuwa
instruction denne amarui.