Thanks for immediate response

there are no extra app or services running.

i will assign more memory to pronicipal server then mirrored

but just tell me fixing memory can decrease...

this system has very bad/low configurartion of .

Only 160gb space in one drive ( all the 4 instances are using same drive)

no transaction log is being taken

mirroring is also on...

Only the data was refreshed from other server, so the settings\configuration of server was same as earlier

although i tried , by starting it with aspnet_regsql.exe with required parameter btu...

I restored the backup with FILE = 1 (instead of FILE =2 )

Is it OK ? you can review thw script i sent in the first post mail (when...

Thanks for reply

Backup is working with option FILE = 1 (it restored sucessfully)

but not with FILE = 2, as i am getting below error

Cannot find file ID...

hi that problem has ben solved by re-installing the instance but caught with a new problem

please refer

below link , see if you can help me in this case...

how can i clear event log ? i dont know the way

please assist

i m keeping my files in other drive

i will do that but how can this be done if we are working on any live server ???

is there any ways so that we can rectify these kinds of...

When i checked EVENT VIEWER

i got the following error

FCB::Open failed: Could not open file D:\PROD\MSSQL.3\MSSQL\DATA\model.mdf for file number 1. OS error: 32(The process cannot access the file...

Finally , i got the area which was making issues , that was actually my mistake ? .

The first instance was installed with sql server 32 bit while new instance...

Thanks

While browsing to HKEY_LOCAL_MACHINE>>software>>microsoft>>microsoft sql server

in the instance folder "REPORT_DEV"

REPORT_DEV>>MSSQLSERVER>>SuperSocketNetlib folder

therer should be one more folder "Tcp"

can u please tell me how can i generate it...

hi vishal ,

one thing i would like to share with u, if i see "sql server surface area configuration " i can see there new instance ...thats some...

Hi,

i just observed that i have used local login account(limited priviledges), so can this be issue ?

i really apologise for this