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. 😀

Chad Crawford (1/20/2010)

---

Do I get a certificate of accomplishment for helping Lynn? Stuff like that doesn't happen every day and I'd like to have something to hang up...

Chad Crawford (1/20/2010)

---

Wow... it actually worked?!?!

I can't claim credit for the settings - I copied them from a website/blog/forum somewhere I can't now find and luckly it worked for...

I'm wondering if you are comparing apples to oranges.

How are you determining the first values (21 GB, 4 GB).

How are you determining the second value ~ 9 GB.

I see how...