Hi, you required only shanpshot.

YOu require the Clustered index for transactional replication

Hi,

It's feature of Sql Instance when you started the sql server then autometically Index, function, View and Stored procedure store the RAM(Instance) and as you cache is part of...

Hello Frnd......

you can unlocked user:

Login with administrator--> open a local user and group manager .

In the right pane under the Name column, double click on the locked out user...

Hello friend,

Please check your index status, If index fragmention have been over 30% then need reorganize index. If table is very big then make a plan Index re-organization on alternate...

Hi ,

It's not possible because your LSN has been breaked. And as you know In logshipping without Log sequence number you can't restore.

Rajesh Singh

+91-9560888360

Hi ,

Yes, you can give the permission only for sql agent.

Login with SSMS with sa and creat a user.

select the MSDB and seleect SQLAGENTOPERATORROLE, SQLAGENTREADERROLE.

RAJESH SINGH

DBA.

HCL COMNET

thank for question

you rebuild index and then you start the job