I got answer for first two. We can find it through below script

SELECT

P.Publication

,P.Publication_type

,S.Subscriber_ID

,S.Update_Mode

FROM

MSPublications P

INNER JOIN

MSSubscriptions S

ON P.Publication_ID = S.Publication_ID;

Publication_type:

0 = Transactional

1 = Snapshot

2 = Merge

Update_mode

0 = Read only

1 = Immediate...

Thank you Des and Chris for the help so far.. below is the query plan and table columns

[ABC_Schema].[ABC1_Table] contain (shortname [varchar](50) +other columns

[ABC_Schema].[ABC2_Table] contain ([OtherId] [varchar](50) NOT NULL,

[priority] [smallint] NULL,

[amended_date]...

Apologies Jeff...but being certified with these doesnt mean one should know everything about SQL Server .. :ermm:

Hi Gail,

Many thanks for your time and help..!

We accidentally ran index rebuild without mentioning the partition number and it was just not finishing..and not letting us to decide whether...

Sql statements would be executed always in a serial way regardless of specifying a go separator.

to find out the LSN try combining 3 tables:

backupset(backup_set_id column) ,backupmediafamily(backup_set_id column) and restorefile(restore_history_id column) tables

and order by restore_date descending

the best way as Gail suggested is to make owner as 'sa'

Another way is(if you want a db owner as a windows a/c) then make SQL server service a/c...

If we add/change the SQL server service a/c from configuration manager then all the required/necessary permissions are automatically granted.

backup /restore and detach-move-attach will almost take same amout of time... If you have alwayson enabled(I guess you may have as you posted the question in SQL2012 forum) then...

anyone to help?

please have a look at this as well

http://www.sqlservercentral.com/scripts/tempdb/72007/

http://thesqldude.com/2012/05/15/monitoring-tempdb-space-usage-and-scripts-for-finding-queries-which-are-using-excessive-tempdb-space/

Yeah.. but didn't got any clue from errorlog or trace.. :ermm:

<<The post is 6+ years old but just replying if someone ends up searching this post..! >>

Would like to add 3 more steps

(1) Free up the logspace for principal database...

This is quite old question,but just in case if someone google it later,here is the query to find it out if the backup is configured using litespeed.

This works for SQL...

Good Question 🙂