I dont think its setup issue bcos other database mirroring are working fine. Only specific databases mirroring goes to suspended mode.

I need to find what caused the mirroring to break(suspended...

we have enterprise edition. Will it still lock the table?

wow that was great article thats exactly what i was looking for

thankx guys

my .bat file code

@ECHO OFF

start D:\microsoft\Scripts\DB_Trans_Log_Ship.vbs

it works through CMD prompt as per ur instructions but not in SQL-agent

runas /user:microsoft\xyz "d:\microsoft\scripts\db_trans_log_ship.bat"

Enter the password for microsoft\xyz :- asddassadad

opens a small popup black window for 1 sec and...

if i go to cmd prompt and type cscript.exe d:..../aa.vbs it works

but not from SQL-job agent

hi i got this error

The step did not generate any output. Process Exit Code 1. The step failed.

what kinda permission the user account who is invoking the job has all the permissions i have also checked the sysadmin permission for that user.

is there any examples are...

u mean C# or vb.net?

i know SQLCLR means all written in .NET code and compiled as dll etc

it is even showing more 🙂 than data

is it acceptable?

how to make it better performable?

if indexes cannot be dropped and essential for the system is there ay other way...

ta u very much

i found the issue there was a truncation i skipped the error after that i could insert all records

Cheers

Hi all

i found the trick click on the indexes folder and then keep ur "object explorer details" window open then u can select multiple indexes and generate a script

Cheers

hi did indexes r not coming part of the script

ta John,

Worked like a gem

Cheers