Ray Mond (8/24/2010)

---

That script won't work on SQL Server 2000. You did post on a SQL Server 2005 forum after all.

Run sp_who2, find if the BACKUP processes are being...

Steve Jones - Editor (8/25/2010)

---

A differential backup is an incremental. Please use that terminology or it becomes hard to talk about this. As Jason mentioned, the more changes that occur,...

CirquedeSQLeil (8/24/2010)

---

If you can only have a couple hours data loss at the max, then enable Full recovery model and setup a backup schedule for your tran logs.

As for the...

CirquedeSQLeil (8/24/2010)

---

How long does it take you to perform the full backups currently?

What is your allowable data loss in the event of a server down?

How many backups do you intend...

Thank you for your reply.

I'm going...

Ray Mond (8/24/2010)

---

That script won't work on SQL Server 2000. You did post on a SQL Server 2005 forum after all.

Run sp_who2, find if the BACKUP processes are being...

This is the stored procedure that runs the 'Truncate Transaction log'

ALTER PROCEDURE [dbo].['name of stored procedure']

AS

BACKUP LOG 'Databasename'

WITH

TRUNCATE_ONLY

The hard drive is formatted in NTFS and the only job that runs every half hour throughout the day is the "Truncate Transaction log" job but when I re-run the...

When I check drive E, it has one of the databases backup files but with the file size of 0, which obviously means that nothing has been backed up.

The...

All the Databases are live so I'm concerned backing up any of then during the day. I will set the job to run, just one of the databases (the main...

I set the backup to run at 4am because there are no other backups that occur at that time except for the "Truncate transaction log" job. The job continually runs...

Thank you for the reply.

When I try to run the Truncate Log job it gives me the following error message:

Msg 3023, Level 16, State 3, Procedure 'stored procedure name', Line...

Sorry I forgot to let you know that only differential back up occurs and it is on the external hard drive.

Thank you

The Differential back up happens on the daily biases. Currently it looks like if it’s appending but I need it to backup all the data that I have not been...

It’s not maintenance plan, I have done the back up through SQL Server agent. It takes about 1 hour and 30 minutes to back up all databases. It looks like...