Today I've discovered an utility that can help me to save time expecially on
my database backups: DbQuickLaunch.
DbQuickLaunch is a nice utility written by William Bartholomew that
allows you to launch database tools for a specific database directly from the
system-tray (so no needs to open Enterprise Manager or other management
tools).
All you have to do is to configure the utility with the tool you want to
launch, in an easy manner well explained by William. For example, if you want to
have a quick launch for your database backup, just open the configure window and
write as follow:
Program Name: Backup Database
Executable: SQLCMD.EXE
Arguments: /S
{Data Source} /E /q “BACKUP DATABASE [{Database}] TO
DISK=’{Database}.BAK’”
When you select the menu item the tokens {Data Source} and {Database} are
replaced with the server name and database name respectively. You can use any of
the properties that appear in the server configuration window by surrounding
them with curly-brackets, eg {User ID}.
I think I'll install it on one of my server... 