Can you clarify what it is you need.

Thanks

Chris

ANSI_PADDING should also be a correct answer!

Below from BOL;

In a future version of Microsoft SQL Server ANSI_PADDING will always be ON and any applications that explicitly set the option to...

GilaMonster (8/12/2011)

---

chris.mcgowan (8/12/2011)

---

The only thing i would say make sure of is that you verify your backups. If you get corruption on one of your database on your primary...

Your environment looks to be sound then from a recovery point of view.

You have a warm standby in place with log shipping so if you loose your primary...

The notification through the job properties won't it will just alert that the job has failed. If you build some custom error handling into the TSQL in the job...

To make the secondary log shipping instance 'online' and accesible you need to restore a transaction log with recovery. This then means you would need to resetup log shipping...

I would change the max value to 6.5GB just to give the OS that little bit of breathing room, 7GB only leaves 1GB for the OS which isn't much.

Thanks

Chris

What is it that you are trying to acheive?

It Depends.

You cannot take a native backup of the databases if they are in Standby/Read Only.

If your SQL Databases make use of SAN storage then you can take a snapshot...

A collation encodes the rules governing the proper use of characters for either a language, such as Greek or Polish, or an alphabet, such as Latin1_General (the Latin alphabet used...

You can E-mail an operator when the job fails (right click the job / properties / Notifications) or you can put error handling in the TSQL within the job step...

Sean is right this shouldn't be an issue, howerver there are two things to watch out for in my experiance;

Deprecated features / TSQL Syntax changes.

Log shipping will not work after...

Windows Error Reporting is not just used by SQL Server if you are getting an exception chances are it will be recorded in c:\program data\.....

Thanks

Chris

A collation encodes the rules governing the proper use of characters for either a language, such as Greek or Polish, or an alphabet, such as Latin1_General (the Latin alphabet used...

It would be worth having a look at Windows Error Reporting

http://msdn.microsoft.com/en-us/windows/hardware/gg487440

Kevin's blog post albeit short has helped me identify an issue with the Reporting Services service which i am waiting...