AJ,

Thanks for the note. Most of the problems we have had are with SPAM filters. Whitelisting can help, but when it's at a postmaster level, we or the user typically...

Are you putting rbanchtype in the companybranchaddress table? Also, not sure why branch name is separated out. Are you planning on sharing names among companies? I'd question that idea, but...

Keep in mind you're limited to starting on the minute, so seconds involved and the job are not reentrant. If it's already running, it will not run again.

did you check the error log and are you sure that the pathing for attaching them is correct?

That's an interesting thought. Not sure how many people do this and if it's worth the time.

Advertising is an issue as many of the ads are not mobile friendly...

Sometimes we rerelease the articles, and the posted date changes based on when we set it for publication. I have the old date, should add an item to display that.

How large is the db? Loading means just that, it's loading from a restore. Is it possible that you checked the box that allows for more restores?

Did the restore complete?

You can limit the view by including a WHERE clause.

select * from myview where username = 'x'

It shouldn't happen. Are you sure you've got the correct current size? The log could grow itself if you haven't limited it.

The big loopholes are the ones you won't think of. Haveing the DBA handy is the important thing since unforseen things might happen.

Other than that, DR could be as simple...

I typically run optimizations once a week and integrity before all backups.

I'd run integrity, then optimizations.

I assume the space was already allocated on your SAN drive and SQL just picked it up? How much space was added v how much was there? Are you sure...

You can make it the last step in the package, or make a second package and use the job system to call the 2nd when the first successfully completes.

I'm not sure what you are looking to compare? If you want the current fillfactor of the table, then it will be gathered by dbcc showcontig, but this only works...

SQL Server preallocates space for the dbs and then fills it up. If you create a 10GB database, SQL Server allocates that much space from the OS filesystem, then zeros...