IBM's Tivoli Storage Management product has the option to do file/filegroup backups

Have you verified that the sql server can ping the FTP server?

Not correct.

There is only one command and it is 'Backup Log....'

The Tail - log backup is just the last one you do before beginning a point in time recovery. (...

I prefer to backup on old box and restore on the new box.

before doing the backup restore operation, I use the stored procedures found here

http://support.microsoft.com/kb/246133/EN-US/. This article describes the...

You can use SSMS, but you must fist register your instance of Integration Services.

At the top right in SSMS, there is the box titled 'Registered Servers'. Instead of the database...

I don't believe it does save them. Each time you want to see the permissions on a securable, you need to re-"Add" the securable to the top window.

When you open the role properties, the top window (securables) is blank. The button says "Add" which seems to say Add permissions. This is not what the Add button does....

What you want is a Counter Log in perfmon. The trick is to first create a DSN (ODBC Data Source Name) that points to the database where you will store...

In SQL management studio,

Right click on the role you want to check the permissions for and select properties.

On the properties control, select the 'securables' page. The top window for 'securables'...

Right click your publication and select properties.

On the 'snapshot' tab are options to run 'additional scripts' you can specify a script to run before or after the snapshot.

The triggers I...

If you navigate to Publication Properties>Article defaults. Choose tabel articles and select the 'commands' tab you will see that there are options as to what happens when an INSERT, UPDATE,...

With credits to the Microsoft Scripting Center....

WMI script to check service status

strComputer = "<server_name>"

Set objWMIService = GetObject("winmgmts:" & _

    "{impersonationLevel=Impersonate}!\\" & strComputer & "\root\cimv2")

Set colServices = objWMIService.ExecQuery("SELECT * FROM Win32_Service")

For...