tosscrosby-60625 (1/20/2010)

---

Isn't that...

Potentially a permissions issue on the share you are backing up to. The service account running the agent service may not have the needed permissions to write to that...

Please read the first article I have referenced below in my signature block regarding asking for assistance. Please follow the instructions in that article and provide us with table...

dma-669038 (1/20/2010)

---

Hi Lynn, I didnt think i was..who you are in an organisation is a combo of what you think and what their values are. I was in a position...

Please, I am not disagreeing with Gail. We need to look at each situation and make the appropriate decisions, after all, isn't that why we make the BIG $$$$?

The flip side to that coin is thinking you are indispensable by not passing on knowledge to coworkers and less experienced team members. By passing on your knowledge you...

See a pattern below:

SELECT

@aerialStatus = case when p.AerialBy IS_MEMBER null

...

Sorry, i use the native sql backup with HyperBac. Can't help you with the Redgate product, not familiar with it.

I do have a suggestion, use it to backup to...

Try this:

SELECT @aerialStatus = case when p.AerialBy IS_MEMBER null then'red' else 'green' end FROM Prospects p WHERE ProID = @ProID ;

select @aerialStatus;

No, your not. I understand fully that you shouldn't restart a SQL Server instance or server. All I am saying is it really is an "It depends" thing....

Partly answered my questions. You may have experienced a network issue during the backup. It is recommended that you complete your backups to a local disk resource and...

GilaMonster (1/20/2010)

---

Depends on what the exact error is. Cases like this, where it's a file that...

shripati (1/20/2010)

---

Hi...

You can try this steps:

Truncate the log file --- and shrink it to minimum size possible.

This is the code...

USE DatabaseName

GO

DBCC SHRINKFILE(<TransactionLogName>, 1)

BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

DBCC SHRINKFILE(<TransactionLogName>, 1)

GO...

dba_neo (1/20/2010)

---

Team,

My Backup job have faile dwith the following error.

BACKUP failed to complete the command BACKUP DATABASE [T1] TO VIRTUAL_DEVICE = 'SQLBACKUP_23C612B2-3FB4-4AE2-AE44-88D91328CC35' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536,...

Liked it too, I did. 😀