Script to check enterprise vault databases fragmentation level


DB_NAME(DB_ID()) as DatabaseName,

OBJECT_NAME(ddips.[object_id], DB_ID())  AS TableName ,

i.[name] AS [Index_Name] ,

ddips.[Index_Type_Desc] ,

CAST(ddips.[avg_fragmentation_in_percent] AS SMALLINT)AS [Logical_Scan_Fragment_%] ,

CAST(ddips.[avg_fragment_size_in_pages] AS SMALLINT)AS [Avg_Frag_Size_in_Pages] ,

ddips.[Fragment_Count] ,


ddips.[avg_page_space_used_in_percent] AS Avg_Page_Dens,

ddips.[Partition_Number] ,

ddips.[Alloc_Unit_Type_Desc] ,

ddips.[Index_Depth] ,



sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, ‘Detailed’) ddips

INNER JOIN sys.[indexes] i ON ddips.[object_id] = i.[object_id]

AND ddips.[index_id] = i.[index_id] WHERE

ddips.[avg_fragmentation_in_percent] > 15

AND ddips.[page_count] > 1000 ORDER BY

ddips.[avg_fragmentation_in_percent] DESC,

OBJECT_NAME(ddips.[object_id], DB_ID()), i.[name]

Backup Exec retry snapshot , Can be use as workaround to temporary fix the failure because of snapshot

As you all know sometimes we come across the snapshot failure issue, a quiescing snapshot is required to take backup but due to issue from VMware or Hyper-V backup, we can’t do any things from backup exec side. 


I have come across the issue where the backup snapshot was failing at first attempt but when again we run the snapshot it completed successfully, so basically at second or third attempt it got successful


I have an open case with VMware and they provided solution and issue were resolved but I have waited almost five days to get the final solution from VMware. so as a workaround I have increased the snapshot value so for those five days(s) therefore I always used to have the successful backup.


Also, make sure, failed snapshot should be deleted from snapshot manager

Access backup Exec Server and follow below to increase retry snapshot,

regedit32.exe and navigate to “HKEY_LOCAL_MACHINE\SOFTWARE\Symantec\Backup Exec for Windows\Backup Exec\Engine\VMWare Agent “

You will need to create the following keys:

  1. “Snapshot retry interval” value data = 60
  2. “Snapshot retry attempts” value data = 5
  3. “Use hybrid snapshot method” value data = 1

All keys are DWORD (32-bit), set to Hexadecimal and are case sensitive.

5 Things That Smart People Do On Weekends

If you think weekend is only about watching television mindlessly or browsing the internet, you are wrong. If you think it is only about visiting a bar or a restaurant with your friends, you are wrong yet again. But it is definitely the time when we are not under pressure to wake up early, reach office at time and prepare a power point presentation scheduled for an evening meet.

It is the time when we are free to do what we like to do. Some people utilize this time to discuss certain family issues and sort them out. Some make plans for the upcoming week. Here, we share five things effective people do on weekend.

1. Cut down on internet: If you spend less time on internet, you will find time for yourself and your family. So, tell everyone in your family to minimize usage of smartphones and laptops during weekends so that they can find more time for one another. If you are supposed to work on weekends, chose odd time to complete office commitments for example in the morning or during the night.

2. Make plans for next week: Try to spend some time either on Sunday or Saturday night to check yourcalendar and make schedule accordingly for the next week. If some event or festival is scheduled for the week, make preparations in advance on weekend as you won’t be free during weekdays.

3. Learn new things: If you could not find time to exercise or practice yoga during week days, you can do so over the weekend. Moreover, you can first learn the art by joining the yoga class on Sundays and Saturdays. Similarly, if you are a music lover and want play a guitar or a sitar, enroll yourself to a music class. 

4. Social work: If you want to do volunteer for some organization or NGO, weekend is the right time to do so. You can either teach kids for free or organize drawing or essay competitions for them. This will provide an opportunity for children to learn new things and in return make you happy and satisfied.

5. Discussions: Weekend is the perfect time to sit with your family members for lunch or dinner and discuss issues pertaining to them. You will be able to assess how well your kids are doing in school, tuitions or other areas. You can clearly ask you mother or father if they have any sort of problem and address them.


SQL permission for backup Exec

“Any logon that requires permissions to perform backup or restore operations should be provided membership in the following SQL Server roles:

Server Role : sysadmin

DB role : db_backupoperator, dbo_owner

Permissions required for performing restore –

Server role : sysadmin, dbcreator

DB role : db_owner”

netbackup unable to truncate sql logs but is job session logs no error or failure are reported.

NetBackup does NOT truncate the log files. MSSQL runs a backup to a virtual device (NetBackup) using the BCH parameters. If NetBackup reports the backup successful, MSSQL will check if the log can be truncated and truncate if required.

If the truncation fails or does not happen, the issue is from SQL and not from NBU..(if no error reported)

You can check the log truncation by querying the log_reuse_wait and log_reuse_wait_desc columns of the sys.databases catalog view.

 Also if the truncation is done successfully ,It is normal for the SQL transaction log files to remain the same size even after they have been truncated. The truncate function only increases the free space in the log file to allow SQL to reuse that space vs creating a new log file.

How to disable & Enable circular logging in Microsoft Exchange so that differential or incremental backups of Exchange Storage Groups and Databases can be performed

To disable circular logging in different version of Exchange Server, perform the following: 

How to Disable circular logging in Exchange 2000 Server and Exchange Server 2003 :

1.       Click Start, point to Programs, point to Microsoft Exchange, and then click System Manager.

2.       Expand Server, right-click the storage group that you want to change, and then click Properties.

3.       In the Properties dialog box, click to clear the Enable Circular Logging check box.

4.       Click OK. When you are prompted to confirm that you want to continue, click Yes.

5.       Restart the Microsoft Exchange Information Store service. To do this, follow these steps:

a.       Click Start, point to Programs, point to Administrative Tools, and then click Services.

b.      In the right pane, click Microsoft Exchange Information Store. Then, click Restart on the Action menu. If you receive a message that other services will also be restarted, click Yes.

Microsoft Technote:

How to Disable Circular Logging in Exchange 2007 :

  • To use the Exchange Management Console to disable circular logging:

1.      Start the Exchange Management Console.

2.      In the console tree, expand Server Configuration, and then click Mailbox.

3.      In the work pane, right-click the storage group for which you want to enable or disable circular logging, and then click Properties. The <Storage Group NameProperties dialog box appears.

4.      Clear the Enable circular logging check box.

5.      Click OK.

6.      To make your changes to the circular logging settings effective, Restart the Microsoft Exchange Information Store service, or dismount and then mount all of the databases in the storage group.

  • To disable circular logging using Exchange Management Shell, run the following command:

Set-StorageGroup -Identity “First Storage Group” -CircularLoggingEnabled $false

ow to Disable Circular Logging in Exchange 2010 :

  • To use the Exchange Management Console to disable circular logging:

1.      In the console tree, navigate to Organization Configuration | Mailbox.

2.      In the result pane, on the Database Management tab, select the database you want to configure.

3.      In the action pane, under the database name, click Properties.

4.      Click on the Maintenance tab

5.      Clear the Enable circular logging check box.

6.      Click OK

7.   To make your changes to the circular logging settings effective, Restart the Microsoft Exchange Information Store service, or dismount and then mount all of the databases in the storage group.

  • To disable circular logging using Exchange Management Shell, run the following command:

Set-MailboxDatabase -Identity “Database Name” -CircularLoggingEnabled $false