I agree with Steve.  Save yourself the hassle of managing a bunch of separate backup files and just append all the log backups for a day to the backup device...

Check BOL->job steps->creating job steps.  Here's an excerpt showing how to add a T-SQL job step in Enterprise Manager (you can also do it in T-SQL by using sp_add_jobstep):

1. Create a...

Your question could be rephrased to ask whether Enterprise Edition is better than Standard Edition.

You could see better performance because only SQL Server Enterprise Edition can be installed on a...

We have a four person data management group that does all the traditional dba jobs of installation, upgrading, backup & recovery, security, performance tuning, and user administration.  Additionally, they help...

We've gone with option #3, not only for user-defined functions, but also for tables and views that are used by multiple applications.  We've found that it's easier to maintain than storing...

You have a lot of choices when using DTS to import data.  The simplest thing you can do to avoid having to reassign permissions on the destination tables is to...

1. Change all object ownership to dbo

2. Drop user 'test' from database

3. Change database owner to 'test'

User 'test' will be the aliased as dbo so all the objects will be...

I use Log Explorer, but for a quick, cheap look into a T-log, try the undocumented DBCC LOG.

Syntax:

DBCC log ({dbid|dbname}, [, type={-1|0|1|2|3|4}])

where:

dbid or dbname...

I've used the dtsrunui utility to generate the dtsrun command, then copied it into a new job step.

Check this SQLDTS.com article for brief instructions on how to use dtsrunui.  I...

I see the red squiggly line when I've paused the SQL Server service.

"B) I always thought an MSDN subscription was the most cost-effective way of licensing SQL Server (and other dev tools) for a development environment...?"

Considering that the current retail prices for...

The sysdtspackagelog table in msdb contains package log data.

Run this in Query Analyzer to show the names of packages that have been executed with logging enabled:

use msdb

select name from sysdtspackagelog

If...

I have a couple of guesses, but can you post what goes wrong when you schedule the package?  Do you get an error message?

My guesses:

1. The account that SQL Server...

Homebrew01,

A database user can create an object owned by DBO by specifying the object name as 'dbo.objectname' rather than just 'objectname'. 

You could backup the msdb database on your development server and restore it on your production server.

There's something in the script library that claims to script all jobs at once,...