Thanks i got what writer meant to say..

Thanks a lot

One of the Geek sent me message specifying the answer as C

but how do you differenciate between standard and non standard clause?

I don't see such distinguishment in BOL...

http://technet.microsoft.com/en-us/library/bb510625.aspx

DBCC Memorystatus

Also you can try setting "sql server performance condition alerts"

does it always skips 1000 rows or any random number?

multiple reasons could be there:

1. Some other backup process is scheduled or taken manually

2.Recovery mode might have changed to simple and then

3.Might have taken full backup with copy only option

4.Might...

you question is not clear enough..

hope this may help:

get the servername from sql server configuration manager (run>sqlservermanager11.msc)..

open ssms2012 and try connecting to the above server with your credentials.

There could be multiple reasons to it,,

There is huge date in the work_order and task_seek table

index is missing or inappropriate

sol:put the result of these tables in temp tables without applying...

to reclaim the space using shrink command,following command should return 'NOTHING'.

else the log won't be truncated and file won't shrink

select log_reuse_wait_desc from sys.databases where name='Your_db_name'

if i were you then i would have taken the backup first then

tried

DBCC CHECKDB (<db>, REPAIR_ALLOW_DATA_LOSS)

Note:note sure this will work on 2000 or not?

are you able to connect to the database using ssms with same user?

you can use 2008 express edition as a witness instead of using 2005..

Edition do not matter for witness server but versions do matter.

Thanks Martin and Hugo

sql server agent>alerts>Log shipping_<xyz>

right click and disable on both primary,secondary

Nice one