How long do these backups take?

22GB is not a large database by any measure and a backup of it should not take very long at all.

Are you backing up...

You shouldn't really be running CheckDB with REPAIR_REBUILD...

They are both good methods for moving databases. The main difference is that the dettach/attach method will require you to take the database down for the move.

Also don't...

Quatrei.X (8/26/2010)

---

hmmmm...

:hehe: I was planning to create a generic function which gets a comma separated list of words in a string and use CTE to seperate those strings to table...

I would start by restoring the Monday night backup to see if the update has happened by then, if it had then you will need to restore each t-log...

The reason we chose Enterprise is because it supports semi-additive measures in datawarehousing. There are work-arounds for standard but they take a lot of extra work.

The index rebuild will cause the log expansion.

Also not all those tasks are esential database maintainence, you should not be regularly shrinking your database as this causes massive fragmentation.

have a look at your log reader agent job history, there should be an error in there. Most likely a permissions issue at a guess.

maybe i am just jaded from setting up replication / log-shipping so many times. It seems like it is only a few more clicks of the mouse. But the planning...

At a guess, from the logs.

2nd week: you tried to drop a table that you don't have permission to.

3rd week: table already exists so you can't create it

They are all different technologies that have overlaps, what exactly are you trying to achieve?

Also replication is no more difficult to setup/maintain than log-shipping infact the process is...

You need to find out what the two different queries are, run a server side trace on the database and compare the query that is run externally with the...

It's not something I would be happy with.

Have you had a look at the queries and tried the standard tuning steps on them?

they could possible be missing a couple of...

State 16 means that the user does not have permission to log into their target database.

Usually happens when the user does not have permission to their default database.

Check the default...

I would stay away from bit fields and choose a tinyint instead.

It seems that your problem is in the reporting of the values? if this is the case...