Why aren't you just scheduling the correct sqlagent jobs to do your backups ?

btw I don't have dynamic backup jobs (meaning generated on a day by day basis) because you...

Paul Randal (3/12/2010)

---

We're talking about table corruption here. The real crux of the matter was 'rebuilding indexes' being offered as a solution without demonstrating understanding of the problem. All caps...

Hey, hey, I don't argue about being wrong or not.

I can live with the fact I'm only human.

I've only received way to much calls stating heaven did fall down,...

LOGINPROPERTY doesn't show that (bol ref http://msdn.microsoft.com/en-us/library/ms345412.aspx)

Off course you can enable login recording to sqlservers errorlog file, but you'll have to process that yourself and off cours, depending on the...

Let's see what full error info OP provides and work from there on.

since we don't know the actual dbcc output .....

If...

Still ... NO NO NO convert to the correct datatype !!!!

Declare @data varchar(MAX)

, @Delimiter char(1)

Select @data= '3/8,3/9,3/10,3/11'

, @Delimiter...

Post the actual dbcc output !

Can you drop and re-create all indexes of that / those tables ?

First of all .... buy huge servers to be able to cope with the little load you need !

Use the correct data type for your columns and make it mandatory.

Only...

simply sead :

Powershell is the new vbscript.

SQLCMD is only intended for usage related to sqlserver.

So .... two different worlds with a bit of overlap.

SQL2008 right ?

Check books online ! "Backing Up and Restoring Replicated Databases "

I would just feed the varriables value in a "variables" table and have the job or dts pick it up from there.

I stongly discourage this kind of constructs.

sp_oa stuff is known to frequently suffer memory leaks, ... which may cause your sql instance to be unstable and crash or reboot.

Workaround:

Create...

You should provide as much error info as possible !

Error text, sqlserver errorlog info, sqlagent.out logging info, ...

As well as your used setup scipt! (of...

IMO it shouldn't matter if you have only one db with a single user, or 100 db with n users.

The cost of having a systems db backup should not...