Hello Folks,

am in similar kind of situation, on one of my Production server there are so many lockings are there it is causing performance problem.

1)I run a query sp_who4 active...

Thanks for your replies,

I've fixed this issue by rebooting Windows server..

hi, this Query may help you.

SELECT

i.name AS IndexName,

...

Do you want to copy T-log backups to secondary?

if yes check what is the last T-log backup restored with Standy in secondary and copy all the T-logs after restored...

hi folks,

can anyone help regarding this issue which i've attached. some people are not receiving automated mails. But am able to send the test mail from the same profile..

TIA..

oopsssss, i found it.

Thanks a lot..

Ninja And Gila,

After shrinking the log i didn't face the problem till date, can u ppl please guide me in my case what to do and what not to do,...

Adiga,

Good to know this from you......

Adiga,

Can u elaborate briefly with ur reply..

Actually I dont know. this job is automated my Windows team 2 years ago and in the production there are morethan 50 jobs are running on 24*7 basis. Moreover, production...

if you are taking a backup of the database it compress and encrypts the database. so that it reduces the workload on DBA.

i came across similar kind of issue in my production.

After database recovered i checked the log size and it is near about 170 gb. Later i shrinked the log...

IN SQL Server 2008.

1) Backup encryption is possible.

2) Data compression and Resource governor.

3) Installation improvements. Disk images and service pack uninstall options.

4) TDE(transparent Data Encryption) Ability to encrypt entire database.

Gila is absolutely correct,

you unable to do anything on the database which is in IN recovery mode.

you can able to see the status of the database in error logs like...

hi naresh,

if u r restoring the database through GUI. follow the steps.

1.right click on the databases and select restore database.

2.To database is ur existing database name.

3.in source for restore, select...