The key here is the above line. It looks like the backupfile cannot be created. Verify the filepath and access permissions to...

You have defined the loop to look...

I also find the schedules you mention very odd.

A rather common frequency is:

FULL: weekly

DIFF: daily

LOG: every 30 mins

But the frequency really depends on your business requirements. How much data loss...

If you run in FULL recovery modus, you can query the [sys].[databases] table. In the column "log_reuse_wait_desc" is stated what holds the log file from being re-used (and thus is...

The SQL instance failed on the cluster. You refer (with deadlock, concurrency) to the error in the ODBC connection. This error is not the rootcause. This error just occurs because...

If you can't use the utility and you don't want to use the extracter, then it's all over. What did you expect?

Only option is what a previous poster allready mentioned:...

You could accomplish this by adding a second jobstep to each backup-job. In this second jobstep you start the next job. Only the first job has a schedule attached.

So:

You or...

There are multipe ways to get this information. Below are some examples:

select * from master.sys.dm_exec_sessions

select * from master..sysprocesses

exec sp_who2

JAMMOD (7/18/2013)[hrThanks for the replies guys! just a couple of questions on the above, would you be able to explain a bit more about why the DIFF and LOG backups...

Explanation of the code:

Both tables (june and july) are joined on the matching columns. Because it's a FULL OUTER join, all the records will be in the result, even if...

You can place this code as the first CASE statement:

WHEN DATA_TYPE = 'decimal'

THEN '(' + Cast(NUMERIC_PRECISION AS VARCHAR(5)) + ',' + Cast(NUMERIC_SCALE AS VARCHAR(5)) + ')'

You can expand the...

Because for INT and DECIMAL the value for CHARACTER_MAXIMUM_LENGTH is a NULL value. Adding a NULL value to a string will result in a NULL value.

Change the CASE statement to:

,...

SQL Server doesn't have a Transaction Undo File. I think you are working with Oracle. This forum is about Micorosoft SQL Server. Very few posters will...

If you want the highest value of multiple rows, this is also a working solution:

select

IDActivity

, MAX(Subject) as 'Subject'

, MAX(ProjectName) as 'ProjectName'

, MAX(Fullname) as 'Fullname'

, MAX(CusName) as 'CusName'

from table_name

group by IDActivity

please explain: "tuf file"