Hi Shamantha4,

Analysing Deadlock and its resolution...

Hi,

Please check the Autogrow settings on DB file and change it to some definite number of MBs instead of percentage increase. Looks like in your case 10 % of...

Hi,

Please also monitor following on databases involved:-

1. Index Fragmentation

2. Statistics Update

3. Blocking to ensure that jobs are not being blocked by any oher process

4. I/O & Waitstats (As already...

Hi,

When a user have permissions to do RDC (remote desktop connection) to a physical/virtual server, only then the green arrow is shown else not.

Showing Blank means you do not have...

Hi,

First of all ensure that all backup files are correctly formed (means with no corruption). You can do this by checking backups with Restore with VERFILYONLY option atleast for few...

Hi,

Please check link: https://support.microsoft.com/en-us/kb/975752

Regards,

Ankur

Hi,

You can take help of Windows admin to see and add members in this AD group because it is created on Active Directory (AD) and that is being managed...

Hi,

Please check following:-

1. Check Eventvwr to get insight of error if any.

2. Check SQL Server Error Log.

3. Check all resources are online and have no issues.

4. Create/Configure Cluster Error Log...

Hi,

Thanks for the confirmation

This is what I am looking for.

🙂

Regards,

Ankur

Hi Perry:

Restore job runs after every 15 minutes. Suggested points are Ok for future perspective.

Can you please suggest as per current scenario, where Log file containing disk at secondary...

Hi,

Mahesh:

Drive size in which DB log file is placed at secondary server: 25 GB

Size of the Database that is being logshipped: 23 GBs

Perry:

Databse log file containing drive...

Hi,

You can also make use of the suggestions written in wonderful article from Pradeep on below link and act accordingly:-

http://www.sqldbadiaries.com/2010/11/13/tempdb-please-allow-me-to-shrink-you/

With regards,

Ankur

Hi,

Please do take care of the security settings (Logins, database roles, permissions) need to preserved on the newly refershed database. Restoring backup doesnot include permissions and security settings..

With regards,

Ankur

Hi Experts,

Please help to know how to perform this task..

With regards,

Ankur

Thanks All,

For a time being I am taking compressed backups on local hard disk. Also last day backup of same database to same network device occured successfully. :w00t:

As suggested by...