Thanks for stepping in with clarification Gail.

I for one certainly appreciate it.

Excellent news! Glad we could help.

Reading through the following thread containing similar issues may prove benificial.

http://www.sqlservercentral.com/Forums/Topic724748-146-1.aspx

To the original poster, please DO NOT...

Hi Tia,

You can roll your own solution if you are prepared to invest a little time into developing and setting it up.

For example, you can store and record the results...

Hi Ajay,

As Pradeep explains, you need to manage and tweak the schedules of the three log shipping jobs (backup/copy/restore) to your needs.

Hi Ajay,

Take a look at the following Microsoft Reference for an explanation of the results produced from DBCC MEMORYSTATUS.

Using DBCC MEMORYSTATUS to Monitor SQL Server Memory Usage

Hope this helps.

I cannot say for sure what your latency will be becuase it is dependent on factors specific to your environment i.e. the hardware involved, the network and of course the...

In a very very small nutt shell, SQL Server Log Shipping is made up of three jobs, a backup, a copy and a restore.

The Backup Job creates a Transaction Log...

Hi,

It is quite possible and normal for this to occur. It depends on how many Transaction Log backups need to be applied to the Log Shipped Database.

I assume you configured...

The majority of our environments are clustered enabling us to easily rollout monthly patching runs without interruption to service.

Grant, an “Annual Power Down” sounds like some sort of dance party...

Hi,

Moving/Rebuilding the clustered index to an alternative filegroup will move the table data. This is because the clustered index IS the physical table data, so to speak.

To confirm, it will...

Hi,

Can you provide us with some more information about your I/O Subsystem please? What type of storage are you using, how many disks etc.

Also are you certain that the SAP...

Hi Brian,

Good stuff. I have eddited my prior post for improved clarity.

Afternoon All,

The physical storage of character strings in SQL Server is controlled by collations. A collation specifies the bit patterns that represent each character and the rules by which characters...