yes we are taking backups locally and we are using HP backup Tape drivers.Total time is 10 to 12 mins and size 275 MB for T-log.

The users...

Daily we are scheduling the backups for both servrers @ below timings

Databases server:-8 am full backup and 11 am t-log and 4 am t- log ;

Application Server:-5 am full backup...

thanks

i've checked each and everything no issues.

Nothing i did now its working fine.Really i dont known where i have to check.My Boss is asking me to give explanation why...

Thanks for ur reply.

Till now there is no updates,anti virus happening in server.Normaly users are working daily basis.Today morning onwards all applications running slow.Almost 2000 users are accessing SQL Server...

hi ,

please find the below connection string for web application

add key="ConnectionString" value="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=BMS_MILLENNIUM_ENTRY;Data Source=10.12.22.32;"

we are using below connection string for connecting databases

strConnString = "Data Source=12.4.4.17;Database=trace;Integrated Security=SSPI”

wish u a very happy new year to all

thanks for reply..

yes everyone is able to connect to server through application and onemore information While working on the application if user...

hi all, thanks for giving suggestions.

At last i got the solution, the problem is in application side. developers add some

enchancements in coding and also issues in server side

In SQL...

thanks for reply kshitij kumar

still we are getting the same error

after executing the below command

CACLS %WINDIR%\assembly /e /t /p administrators:W

please do the needful

hi,

actually i want to export data from sql table to excel

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=d:\pendingdet.xls;',

'SELECT [ENTRY DATE],PRACTICE,[SCAN FILE],[ACCOUNT #],[PG NUMBER],[P NAME],DOS,SUSPENDED,[NON BILLABLE],REMARKS,RESPONSIBILITY,[RESP REMARSK],OPERATOR FROM [Sheet1$]')...